AS2000 sp3 Dimension Security Visual Totals

#1

I have a simple Cube (testing), 1 dimension, 2 levels, (salesperson and
customer)
and 1 measure (Xaction Amount)
When I enable Visual Totals, and 'test role' then the measure says #ERR
If I disable Visual Totals, then I see the total for the restricted
Salesperson and the grand total for all sales people.

Hopefully this is a simple issue to fix
Any ideas?

TIA

#2

I am not using MDX code directly, just selecting the salesperson using the
GUI and enabling Visual Totals

"阿固" wrote:

Quote:

Can you show the mdx how you write in dimemtion sercurity?
The following MDX is a smaple I uesd in my project.
Filter( dimension.allmembers ,
ancestor(dimension.currentmember,salesperson ).properties("name") =
"Gary")

"Neil" wrote:

I have a simple Cube (testing), 1 dimension, 2 levels, (salesperson and
customer)
and 1 measure (Xaction Amount)
When I enable Visual Totals, and 'test role' then the measure says #ERR
If I disable Visual Totals, then I see the total for the restricted
Salesperson and the grand total for all sales people.

Hopefully this is a simple issue to fix
Any ideas?

TIA

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

AS2000 sp3 Dimension Security Visual Totals

microsoft.public.sqlserver.olap microsoft.public.sqlserver.olap

AS2000 sp3 Dimension Security Visual Totals - 02-21-2006 , 11:35 AM

RE: AS2000 sp3 Dimension Security Visual Totals - 02-28-2006 , 06:28 AM