I have a dimension called Tenant. In thee you have Tenant key, Tenant name, Tenant resident type, e.t.c.
Can I make a dimension in Analysis server with resident type='permanent'?
So, when I get this data to crystal analysis I don have to filter it out.
Am I going in the wrong path? How do you'll do it? This I know would be simple, but am a newbie , and still grasping the concepts.
All i want is actually to display resident type='permanent' data (IF it can be done in cube level even please do tell... I am not sure how to do it)