Hide fact data on certain dimension levels.

[tmunson99]

I have a dimension that looks something like:

Company
Division
Labor Pool
Employee
Project

My fact table contains hours and dollars representing an employee's time on a project. This works fine in the OLAP report. However, I also calculate and store percent hours and percent dollars an employee spends on a project. This data only makes sense in the OLAP report when viewed at:

Employee
Project

Can I hide this cell at the other levels? Sorry if I'm not using the right terminology.

 

[MDXer]

Yes. if it is a matter that the data makes no sense at a level you can use calculated cells to display or supress the data as needed. if it is a matter of security then you can accomplish this through Custom security.

Shoot Me! Shoot Me NOW!!!
- Daffy Duck

 

[tmunson99]

Thank you for your suggestion. I haven't had much luck deploying it though. (I'm new to Analysis Services.) Percent Hours and Percent Dollars are already a measure, but I want to hide them at all levels except Employee > Project levels. I tried creating a calculated cell for Percent Hours and defined it at a single level (for now - Employee). I selected 'Apply the calculation formula to the entire calculation subcube' and set my MDX expression to [Measures].[Percent Hours]. When I processed the cube, I had NO measures until the Employee cube. I have 7 different measures that still should have shown up at the higher levels. I know I'm just not doing this right. Any help would be appreciated.