"Total" and "GRAND TOTAL" are incorrect

Hi all,

When browsing my cube i get the correct data per enitity, but incorrect data in the "total" and "grand total". what happens acutally is that i'm getting the same value of the "all" member in the totals of all the levels of the hierarchy that i'm slicing the cube with.

For example, if the hierarchy is as follows: A-->B-->C, then i'm getting the below:

A B C

a1

b1 10

b2 20

total 800

Grand total 800

i suspect that it is related to the attribute relationships which i have defined, where the aggregation of the data is being performed on

mmmh ...

yes I'm quite sure there's a problem with your attribute relationships.

Try to check all the relationship in your hierarchy.

|||How are your attributes related? It should be something like C has a relationship to B, and B has a relationship to A.|||

Hi,

Are the attribute-key relationships correct?

or

Do you got some NULL-key-columns in your fact-table !?
the grand total maybe sums up also the Unknown data ?

Kind regards

"Either the computer running IIS is out of memory, or an incorrect session ID was sent in a

Has anyone ever seen this error? It's listed as SSCE_M_INVALIDRSCBID on this page.

That site also advises very clearly:

"If you experience any errors with the prefix "Internal error" while you use SQL Server Compact Edition, try the operation again as the error might not reproduce. If the error appears again, you should immediately contact Microsoft Product Support Services. The internal errors cannot be resolved by common troubleshooting techniques."

IIS 6.0 is located on a separate server from SQL Server 2005. Installation instructions from Microsoft.com were followed to a "T". I've spent a full day with our client's DBA enabling/disabling various settings on these two servers. Replication works fine if IIS is running on the same server. I'm confident our publication and web-sync settings are correct.

There is no firewall between these servers. They are on the same local network.

Have you been able to resolve this, noluck? I encountered the same problem. I posted it here before finding your post:

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1601966&SiteID=1

In my case, IIS and SQL Server are on the same machine.

"Either the computer running IIS is out of memory, or an incorrect session ID was sent in a

Has anyone ever seen this error? It's listed as SSCE_M_INVALIDRSCBID on this page.

That site also advises very clearly:

"If you experience any errors with the prefix "Internal error" while you use SQL Server Compact Edition, try the operation again as the error might not reproduce. If the error appears again, you should immediately contact Microsoft Product Support Services. The internal errors cannot be resolved by common troubleshooting techniques."

IIS 6.0 is located on a separate server from SQL Server 2005. Installation instructions from Microsoft.com were followed to a "T". I've spent a full day with our client's DBA enabling/disabling various settings on these two servers. Replication works fine if IIS is running on the same server. I'm confident our publication and web-sync settings are correct.

There is no firewall between these servers. They are on the same local network.

Have you been able to resolve this, noluck? I encountered the same problem. I posted it here before finding your post:

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1601966&SiteID=1

In my case, IIS and SQL Server are on the same machine.