while browsing the cube it is giving wrong data
-
Friday, June 15, 2012 2:05 PM
while browsing the cube it is giving wrong data. Grand total value> employees salary.
For example if we drop the 'EmployeeName' in Row field and 'Salary' in total field,
EmployeeName Salary
John 1000
Jeff 2000
GrandTotal 9000
Please suggest me, where is the problem?madhu ml
All Replies
-
Friday, June 15, 2012 2:21 PM
Hello,
What you are seeing is probably the Grand Total of all employees and not a total of the selected members.
To solve the problem you could define the employee set you are working on as a dynamic set and filter the cube with John and Jeff
We have a recent similar thread: http://social.msdn.microsoft.com/Forums/en-US/sqlanalysisservices/thread/006a4b94-5620-40dc-89a7-746958d59db1/#2fd1abcf-1fac-4591-aad3-58968ba559a0
Philip
- Edited by VHteghem_Ph Friday, June 15, 2012 2:44 PM
- Marked As Answer by Elvis LongMicrosoft Contingent Staff, Moderator Wednesday, June 27, 2012 1:28 AM
-
Friday, June 15, 2012 4:10 PM
while browsing the cube it is giving wrong data. Grand total value> employees salary.
For example if we drop the 'EmployeeName' in Row field and 'Salary' in total field,
EmployeeName Salary
John 1000
Jeff 2000
GrandTotal 9000
Please suggest me, where is the problem?madhu ml
- Merged by Elvis LongMicrosoft Contingent Staff, Moderator Wednesday, June 27, 2012 1:30 AM duplicate issue
-
Friday, June 15, 2012 4:21 PM
Hello,
What you are seeing is probably the Grand Total of all employees and not a total of the selected members.
To solve the problem you could define the employee set you are working on as a dynamic set and filter the cube with John and Jeff
We have a recent similar thread: http://social.msdn.microsoft.com/Forums/en-US/sqlanalysisservices/thread/006a4b94-5620-40dc-89a7-746958d59db1/#2fd1abcf-1fac-4591-aad3-58968ba559a0
Philip
-
Friday, June 15, 2012 5:56 PMIf it is many to many relationship, it could also be that the relationship is wrong in dimension usage
vinu
-
Monday, June 18, 2012 7:03 AMHi Vinu, yes, i am using Many to Many relationship. So problem might be there? if there can you please give me idea how to resolve. Regards, Madhu ML
madhu ml
-
Monday, June 18, 2012 8:12 AM
there is a very nice white paper that discusses all the use case. you should be able to figure out the issue from here
http://www.sqlbi.com/articles/many2many/
vinu
.png)
