Report Portal

ReportPortal
ReportPortal
Home | Profile | Register | Active Topics | Members | Search | FAQ
 All Forums
 ReportPortal General Forum
 Report Portal General Issues
 Error while creating Local Cube

Note: You must be registered in order to post a reply.
To register, click here. Registration is FREE!

Screensize:
UserName:
Password:
Anti-Spam Code:
Message:

* HTML is ON
* Forum Code is OFF
Smilies
Smile [:)] Big Smile [:D] Cool [8D] Blush [:I]
Tongue [:P] Evil [):] Wink [;)] Clown [:o)]
Black Eye [B)] Eight Ball [8] Frown [:(] Shy [8)]
Shocked [:0] Angry [:(!] Dead [xx(] Sleepy [|)]
Kisses [:X] Approve [^] Disapprove [V] Question [?]

 
Check here to subscribe to this topic.
   

T O P I C    R E V I E W
ptirpude Posted - 07/06/2006 : 23:32:10
Hi,

I have installed your latest build that fixes a bug 'Unspecified Error' and 'Script Error' while creating Local Cubes. I tries creating local cubes and i was succeeded in creating 2 different Local Cubes. But if try creating Local cubes for some OWC reprts, I get either of the following error:

1) Errors in the metadatamanager. No dimension relationships exist within the 'PM Transaction' measure group

2) Query (4, 910) Parser: The syntax for 'UNKNOWNMEMBER' is incorrect.

Could you please help me out with this problem?

Thanking you in anticipation.


Thanks

SS2k5
3   L A T E S T    R E P L I E S    (Newest First)
admin Posted - 07/24/2006 : 06:08:27
Thank you for providing the detailed explanation to the problem. We will provide a fix ASAP.
ptirpude Posted - 07/20/2006 : 05:43:34
Hi,

I installed latest build of Report Portal on my machine and used 'Adventure Works DW' database which is a default OLAP database of SQL Server 2005. I tried creating local cubes of OWC reports generated for every cube. But every time I failed.

For example:

I generated an OWC report using 'Finance' cube of 'Adventure Works DW database'.

Measures used: Amount, Average Rate, End of Day Rate
Filter Field: Account Type
Column Field: Scenario
Row Field: Account Number

I saved the report. Then I tried creating Local cube for this report.
I got the following errors subsequently:

1)Amount could not be used because it is calculated.
2)Average Rate could not be used because it is calculated.
3)End of Day could not be used because it is calculated.
4) Query (4,1) Parser: The syntax for 'Dimension' is incorrect.


Trying with other cubes, I found some other error like 'Errors in the metadatamanager. No dimension relationships exist within the XXX measure group'

Kindly provide the solution.


Thanks

SS2k5
admin Posted - 07/07/2006 : 10:13:46
My guess it that you have selected a dimension that has no relationship to your measure... Can you reproduce this problem in Adventure Works sample OLAP database?

ReportPortal © 2000-2002 Snitz Communications Go To Top Of Page