# while browsing the cube it is giving wrong data

### Question

• 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?

Friday, June 15, 2012 2:05 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

Philip

Friday, June 15, 2012 2:21 PM

### All replies

• 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

Philip

Friday, June 15, 2012 2:21 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?

Friday, June 15, 2012 4:10 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

Philip

Friday, June 15, 2012 4:21 PM
• If it is many to many relationship, it could also be that the relationship is wrong in dimension usage

vinu

Friday, June 15, 2012 5:56 PM
• Hi 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