K
Kasper S Nielsen
Hi
I'm trying to run OWC on a network with Active Directory controls (AD).
I'm having a Pivot Table with some FilterAxis variables, where one of
them (market) is access-controlled by AD.
I'm having the following strange problem.
User 1 has access to all values of the 'market' variable.
User 2 has access to only 3 of the 10 total values of 'market' (and NOT
to the 'all' value).
For User 1 everything works fine, he can see all markets, The Total or
any chosen subset of Markets.
For User 2 the problems occur. In the 'marker' filter variable only the
3 values that he has access to shows - so far so good.
He can also choose any of the 3 markets and get the correct information
of thoose.
However - when he chooses all 3 markets, or any subset of two of the
markets, I get this error message :
Formula error - cannot bind: unknown menmber: "Pivot3Hier1MultiFilter__"
What is wrong here?
Is it because the pivot table tries to make a call to 'all' markets, and
user 2 dont have sufficient privilegies to do so?
How do I fix it?
Regards
Kasper S Nielsen
I'm trying to run OWC on a network with Active Directory controls (AD).
I'm having a Pivot Table with some FilterAxis variables, where one of
them (market) is access-controlled by AD.
I'm having the following strange problem.
User 1 has access to all values of the 'market' variable.
User 2 has access to only 3 of the 10 total values of 'market' (and NOT
to the 'all' value).
For User 1 everything works fine, he can see all markets, The Total or
any chosen subset of Markets.
For User 2 the problems occur. In the 'marker' filter variable only the
3 values that he has access to shows - so far so good.
He can also choose any of the 3 markets and get the correct information
of thoose.
However - when he chooses all 3 markets, or any subset of two of the
markets, I get this error message :
Formula error - cannot bind: unknown menmber: "Pivot3Hier1MultiFilter__"
What is wrong here?
Is it because the pivot table tries to make a call to 'all' markets, and
user 2 dont have sufficient privilegies to do so?
How do I fix it?
Regards
Kasper S Nielsen