Auerelio Vasquez
asked on
Measure Groups
Hi there, I'm trying to do some comparision from my cube to the current reporting system (SAP).
i'm  trying to get a count of a column for a measure group. the name of the column is Forwarded.
The value in the fact table is either 1 or 0. I only really care about the rows that have a value of 1. I can't see how to change this in the cube editor. i can see how to reformat the measure and all that. but i just want to make sure that i'm counting only the necesary rows. My values are coming ever so slightly different than what is in production, i wonder if this is the reason why, i nver explicitly tell the cube to filter out the 1's...
i'm  trying to get a count of a column for a measure group. the name of the column is Forwarded.
The value in the fact table is either 1 or 0. I only really care about the rows that have a value of 1. I can't see how to change this in the cube editor. i can see how to reformat the measure and all that. but i just want to make sure that i'm counting only the necesary rows. My values are coming ever so slightly different than what is in production, i wonder if this is the reason why, i nver explicitly tell the cube to filter out the 1's...
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER