| T O P I C R E V I E W |
| myszak |
Posted - 02/10/2009 : 04:52:12
Hi!
I have some difficulties with creating ROLAP report.
I set up a connection (SQL server, SQL 2000) to my database – it was success.
I go to Admin->ROLAP, create the new cube: name, connection, type, fact table, alias,
(I can see all of the tables from my database, I select the fact table) and Add the cube.
The problem is that I am not able to add measures to the selected measures. I can see them but clicking or using arrows is useless - nothing happens. I also can’t see the Functions (the functions tab is empty). I checked CubeFunction and CubeFunctionDb tables. First one seems to be ok, the second one is empty.
There are no problem with adding dimensions to the cube.
What do I do wrong?
(I did the same with Pubs and Northwind, I imported them first – the problem was the same.)
Please, help me to resolve the problem.
|
| 5 L A T E S T R E P L I E S (Newest First) |
| myszak |
Posted - 02/24/2009 : 01:39:45
Yes, now I know
I had to modify Your script to populate the CubeFunctionDb table, now I understand why
|
| admin |
Posted - 02/23/2009 : 18:50:29
This problem was caused by the fact that your database in case sensitive. Here are the instructions on how to change it to case insensitive collation:
http://bytes.com/groups/ms-sql/80144-change-case-sensitivity-after-database-set-up |
| myszak |
Posted - 02/12/2009 : 02:40:56
Thank You both.
I populated the CubeFunctionDb table by running this script.
Now I can see functions in the "Funcions" tab and I can add measures.
I hope there'll be no other problems with ROLAP report.
Thaks once again:)
myszak
|
| admin |
Posted - 02/11/2009 : 20:30:45
CubeFunctionDb table should not be empty. Perhaps the installation process failed to populate it.
You can populate this table by running this script against your ReportPortal database C:\Inetpub\wwwroot\ReportPortal\Data.sql (ignore all errors).
You can also populate this table by running this script:
http://www.reportportal.com/Download/CubeFunctionDB.txt |
| marco |
Posted - 02/10/2009 : 09:28:28
Hi,
Which ReportPortal version / build are you using ?
Are you able to import a sample ROLAP Cube ?
Are you able to make a ROLAP Cube based on the userstats of ReportPortal ?
Please email me some screenshots of what you will see at support at reportportal.nl
Marco |
Report Portal
