| Author |
 Topic  |
|
|
rMy0G3KH
USA
28 Posts |
 Posted - 12/21/2005 : 13:53:16
|
Greetings,
I think I have found a bug with the report portal, I can only add a certain number of dimensions to a report before I get errors.
I think it has something to do with the length of the fields in each dimension.
I verified by creating a report and adding a field from every dimension until it give me an error.
Any advice greatly appreciated.
I am getting this error:
Error: An unexpected internal error has occurred.
|
|
|
admin
1644 Posts |
Posted - 12/23/2005 : 02:50:27
|
| Can you reproduce this problem with Foodmart 2000 database? Can you please provide detailed steps? |
 |
|
|
rMy0G3KH
USA
28 Posts |
Posted - 02/07/2006 : 15:40:09
|
To reproduce this problem with Foodmart 2000 database, please follow these steps:
Select a Sales cube
Drag and drop Unit Sales measure from the field list panel onto the measures section.
Drag and drop dimensions levels e.g. Country, Education Level, Gender, Marital Status, Product Family, and Media Type field list panel onto the rows sections.
After short hesitation, system responses and displays this error, Report returned over 500 rows. Cancel report execution?
Click No
No response; just blank white page
|
|
|
|
admin
1644 Posts |
Posted - 02/12/2006 : 20:13:03
|
Cross joining six dimensions produces too many records (about 1910). Here is the MDX:
[code]Select non empty HIERARCHIZE(DISTINCT({Crossjoin({
[Customers].[State Province].Members},Crossjoin(
{[Education Level].[Education Level].Members},Crossjoin(
{[Gender].[Gender].Members},Crossjoin(
{[Marital Status].[Marital Status].Members},Crossjoin(
{[Product].[Product Family].Members},
{[Promotion Media].[Media Type].Members}
)))))})) on rows,
non empty {
[Measures].[Unit Sales]} on columns
From [Sales]
[/code]
Please try using the drilldown mode, "top 10" filter or paging to limit the amount of data returned to the browser. |
|
|
| |
Topic |
|
|
|
Report Portal
Report Portal Error
