| Author |
 Topic  |
|
|
myszak
Poland
8 Posts |
 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.
|
|
|
marco
Netherlands
588 Posts |
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 |
 |
|
|
admin
1644 Posts |
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 |
|
|
|
myszak
Poland
8 Posts |
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
1644 Posts |
|
|
myszak
Poland
8 Posts |
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
|
|
|
| |
Topic |
|
Report Portal
ROLAP report - not able to select measures.
