Hide Calculations for some users

Hi,

anyone know if it is possible to secure some calculated measures from different users?

I have a calculated field in the cube that I just want to show for one user.

I guess I need to write some MDX in the "Allow reading of cube content" under Edit Cell data when I edit the role.

Someone have any suggestions?

I found a solution! =)

If you want to hide the measure TB this is the code that you write in the "Allow reading of cube content" under Cell Data.

Code Snippet

Not Measures.CurrentMember IS Measures.TB

Hide Calculations for some users

Hi,

anyone know if it is possible to secure some calculated measures from different users?

I have a calculated field in the cube that I just want to show for one user.

I guess I need to write some MDX in the "Allow reading of cube content" under Edit Cell data when I edit the role.

Someone have any suggestions?

I found a solution! =)

If you want to hide the measure TB this is the code that you write in the "Allow reading of cube content" under Cell Data.

Code Snippet

Not Measures.CurrentMember IS Measures.TB

sql

Hide Calculated Column in Matrix Report And show only in Total

Hi All,

I need to show the Cumulative calculated value only in Total by year/Group. I could not use Visibility expression using

InScope, as it creates *Blank column. Please go thru details below.

Year

Month01 02 03 Total

Salary Salary Salary Salary Cumulative (Calc)

Employee01 20 5 25 25

Employee02 10 10 20 45

.....

Total

How can i achieve this?. Any suggestion on this would be appreciated.

Thanks,

You have a couple of options:

1 - Can you add Total Salary as part of your dataset and return that for each Employee/Year ?
If so, then you just include that field in your cumulative statement, so no need for the column

2 - You may be able to take both Tot Salary and Cumulative salary and place them in a single cell using the cells in cells technique. Select your cell and drop a Rectangle control into it. You’ll notice the background change from solid white to the transparent grid pattern. Next, select a textbox control and drop this into the rectangle. You have to get it perfect and sometimes it’s a bit annoying when you don’t land exactly on the control. Next, drop in another textbox so it rests directly beside your first one.
In one cell add your Sal Tot, and in the right textbox the Cumulative Salary. Set the Sal Tot textbox to hidden=True and as small width as possible. To the end user it will appear as though this is a single column.

Hide a column (value) in a subtotal of a matrix?

Hello,
I am trying to hide (or possible show a calculated value in a subtotal)
a value in a matrix. My dataset returns something in this format.
RowHeader1, RowHeader2, ColumnName, ColumnType, Amount
1, 1, Total, Amount, 100
1, 1, Total2, Amount, 0
1, 1, Variance, Percent, 1.00
1, 2, Total, Amount, 50
1, 2, Total2, Amount, 55
1, 2, Variance, Percent, .10
I have row groups on RowHeader1 and RowHeader2. Also, I have a Column
Group on ColumnName and I have SUM(Fields!Amount.Value) in the Data
cell. The Matrix looks something like this:
Total Total2 Variance
1 1 100 0 100%
2 50 55 10%
TOTAL 150 55 110%
What I would like to do is either have the correct value in the
SubTotal field for the Variance (which I don't think is possible) or
just hide it. I tried to use InScope() as a start but I have been
getting nowhere.
Any help would be greatly appreciated.
Thanks,
AbeIs there a way to know if you are in the Subtotal Row or not?
Thanks|||Apparently you looked already at the InScope function. If you have multiple
row/column groupings you need to make sure that your conditional expression
considers all cases. E.g.
=iif(InScope("ColumnGroup1"), iif(InScope("RowGroup1"), "In Cell", "In
Subtotal of RowGroup1"), iif(InScope("RowGroup1"), "In Subtotal of
ColumnGroup1", "In Subtotal of entire matrix"))
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"Abe" <abe@.flonet.com> wrote in message
news:1106156667.460735.143790@.c13g2000cwb.googlegroups.com...
> Is there a way to know if you are in the Subtotal Row or not?
> Thanks
>|||Thanks a lot for your help, I really appreciate it.

Hidden Values are not calculated in SSRS 2005?!

Hi,
I just created a Report in SSRS 2005 and wanted to use the "old" trick to
display data values in the header (reference body-elements from the header).
I know this worked fine in SSRS 2000, but in SSRS 2005 it seems, that they
have build in some "optimization" which doesn't render/calculate hidden
Fields anymore.
So, when I reference a Field that isn't hidden it works just fine - but as
soon as I hide the referenced field in the body it never gets a value, thus
the textbox in the header stays empty as well.
Initially I referenced Textboxes embedded in a table, but it neither works
for texboxes which are directly contained in the body-region. As soon as an
element is hidden it seems to be ignored by the rendering engine.
Any help would be appreciated.
Thanks,
FlorianA suitable workaround would be to set the font color to the same color as
the background color.
-Tim
"Florian" <Florian@.discussions.microsoft.com> wrote in message
news:AB31608E-EFF9-4D0B-865C-956519A96859@.microsoft.com...
> Hi,
> I just created a Report in SSRS 2005 and wanted to use the "old" trick to
> display data values in the header (reference body-elements from the
> header).
> I know this worked fine in SSRS 2000, but in SSRS 2005 it seems, that they
> have build in some "optimization" which doesn't render/calculate hidden
> Fields anymore.
> So, when I reference a Field that isn't hidden it works just fine - but as
> soon as I hide the referenced field in the body it never gets a value,
> thus
> the textbox in the header stays empty as well.
> Initially I referenced Textboxes embedded in a table, but it neither works
> for texboxes which are directly contained in the body-region. As soon as
> an
> element is hidden it seems to be ignored by the rendering engine.
> Any help would be appreciated.
> Thanks,
> Florian

Hidden member causes Excel to throw error

Hi,

I have an AS2000 utility dimension that hold one calculated member and one 'dummy' member for the fact - dimension join. I use it in a virtual cube to achive currency conversion and I implemented the utility dimension to be able to use it with the aggregrate function that Excel uses on multiple filter selections.

I want to prevent this dummy member to appear in my Excel pivot table. I have tried to use the setting 'Hide member if -No name' and it works great when I browse my cube in ASManager but when I browse it Excel 2007 I get a popup message saying something like 'member could not be found...'

Any idea?

Thanks,Christer

It has been some time since I have worked with AS2000 but I think there is a "Visible" property that you can set on your dummy member.

Another way can be to remove the parent for the calculated member in you shell dimension. Only use the dimension without parent member.

HTH

Thomas Ivarsson

|||Another thing to try is to change the default member for this dimension to point to the calculated member.