TM1 Forum

I create a cube in Sdata server and a view based on the cube I want to hide element Actual in Year element but show it in Quarters elements What i tried to do - created cellsecurity cube for Report cube and add rule which put
None in cells for Actual and Year. Anyway it shows what I want to hide although values disappeared Is possible to hide elements in the way that I want?
May be I could try something else - MDX or something else?

In a word - No.

You have a few options available.

1. Write a rule that makes Year - Actual 0 and add zero suppression to your cube view
2. Add cell level security to the cube to prevent the user from seeing Year - Actual
3. Create a report in Excel via perspectives, this way you can specify exactly what you want to present to the user
4. Combine your version and time dimensions so that the Actual hierarchy doesn't consolidate up to years, but the Budget hierarcy does

I know this is probably an example you're using to test general functionality, but I would also question why you wouldn't want to show Actuals at the full year?

dan.kelleher wrote:In a word - No.

You have a few options available.

1. Write a rule that makes Year - Actual 0 and add zero suppression to your cube view
2. Add cell level security to the cube to prevent the user from seeing Year - Actual
3. Create a report in Excel via perspectives, this way you can specify exactly what you want to present to the user
4. Combine your version and time dimensions so that the Actual hierarchy doesn't consolidate up to years, but the Budget hierarcy does

I know this is probably an example you're using to test general functionality, but I would also question why you wouldn't want to show Actuals at the full year?

1. If I add zero supression it will supress everything but I don't want to supress everything.
2. I did it and result is unsatisfactory - see first message
3. I don't need to do it thourgh Excel
4. The question isn't not to calculate but not to show

It is only example. I don't want to show some measures (like Actual and Budget) elements with combination in long time hiearary.

The idea which come to mind - add dummy element in region hiearachy, add in elements (for combination time and measures) which I need - 1 and supress zero in columns. But I don't want to show for users this dummy element. It is a problem

This is just the way the cube viewer works. If you stack two or more dimension on rows or columns then it is going to show every intersection of the selected elements, subject to element level security. To do what you want in the cube viewer you would have to do one of the suggested dimension changes. The best way is to create an Excel report and then publish it to an application folder. Then the users can see it in Perpectives, a Contributor app, or TM1Web.