Error in dynamic security -
01-13-2004
, 09:56 AM
Hello!
I had implemented dynamic security with security cube plus a virtual
cube.
It works very well when the user exists in the security cube, but when
it doesn't i am reciving this message:
"The query could not be processed:
o Database 'DESPESAS' does not exist."
Or this:
"The query could not be processed:
o Either BOF or EOF is True, or the current record has been deleted.
Requested operation requires a current record."
The role i had define are :
"filter([Organização].[Nome].members,
validmeasure(([Measures].[int Permission],[Organização].currentmember,
strtomember(
iif(IsError(strtomember("[Dim_Users].[login].&[" +
mid(username,instr(1,username,"\")+1,len(username) ) + "]")),
"[Dim_Users].&[Unknown]", "[Dim_Users].[Login].&[" +
mid(username,instr(1,username,"\")+1,len(username) ) + "]"))))= 1)"
This errors only happens when i use someone that isn't in my security
cube!
What i am doing wrong?
Its shouldn't returnt a message like: "You don't have permissions to
access data!!"
Please help me!
Thanks in advanced!!
André Fonseca |