Browsing Anaysis services 2005 cubes through Business Intelligence Portal (Urgent hel needed -
03-10-2006
, 11:21 AM
Hi All,
I stucked somewhere::
I have created cubes in analysis services 2005 by pulling the data
directly from oracle.
And I have defined the security on the cubes by creating roles.
I have created 3 window users (No Active Directory no Domain) on my
machine(Ihave installed window 2003 on my machine)
and I created roled in analysis services for these 3 users.
In cube browser(Analysis services 2005) , I have option to change user:
In change user we have 3 options
Current user
Other User
Roles
I am able to browse the cubes when I connect to Current user
and also while connect to Roles and able to browse as per security
defined on the cubes.
But when choose other user option and I put the name over ther I am not
able browse the cube it is giving some account name error..........
And other problem is that when I browse that cube in Business
Intelligence portal in share point services with 3 different users. it
showing all data for all users , it is bi-passing or overwriting the
security...
I think i am doing some silly mistake , is there any setting i am
missing or what??
Please help me in that |