Posted on 2011-09-19
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...