Dynamic Dimension Security using something else than ROLES

We are incorporating some OLAP cubes into our secure website and what to restrict the cubes information base on the person or client logged in. We are using Dundas OLAP as the front end for displaying the cubes. The Roles approach is not a viable solution since it is impossible for us to gather and keep track of our client’s windows usernames.

Is there a way to somehow pass a value through the control or the connection string and later use this value to filter dimension members?

> Is there a way to somehow pass a value through the control or the connection string and later use this value to filter dimension members?

Yes, there is a connection string property called "Roles", where you can specify which Roles should be used.

|||

I did a little bit of digging on connection string properties and came across this in one of your blogs.

There is a new MDX function for SSAS 2005 called “CustomData”.

http://sqljunkies.com/WebLog/mosha/archive/2005/10/11/mdx_functions_as2005.aspx

I am using the “Roles” and “CustomData” properties of the connection string to achieve my purpose.

Thanks Mosha

Dynamic (user requested) Dimension

In our project, we constantly have the need to analyse the data in the cubes, but with "restricted" dimension... maybe an example helps:

Like this: "Get the total for orders, but only those placed on a Wednesdays". This would be an easy task, since you only have 7 weekdays. In your cube browsing frontend you simply click away the 6 you do not need, and there is your result.

Now imagine you get a list of 10,000 Customer IDs, or maybe 30,000 Invoice IDs, or only 300 Product IDs that shall be used to restrict the space in which all further analysis takes place. No one wants to (manually) select 10,000 items out of a list of 2.5 million... even selecting the 300 Products out of the Products list (2,500 items) is a task you cannot really explain to someone.

The content of the lists do change, but not very frequent. IF the lists are changed however, they are changed completly, not just added upon! These special jobs happen maybe once a week, and are started only by one user at a time. So there is no need to make this work with several different lists at once or so.

Currently, I am importing the list into SQL Server, then build a query "joining" the list with my tables so I get the restricted data, and then recreate all groupings and calculations the cube does by manual SQL - the last part is the really bad job.

What can be done to have a dimension (or in this case, 3 lists = 3 dimensions) in the cube whose content is based on an "external" list that changes from time to time?

I will solve the "external" part first by creating a either mail-in or html form to upload a txt list file to the server and then run a SSIS package to import the data so it is part of the database - no problem there!

How would "intelligent" processing of this dimension and the cube be handeled? I understand it that "dimension update processing" is not possible, as the content can be totally different. Doing "dimension full processing" will solve that, but require a "full cube processing" as well?

Hi Ralf,

try to have a look at this precious document by Marco Russo and check the Multiple Groups chapter, probably is what you're looking for:

http://www.sqlbi.eu/Portals/0/Downloads/M2M%20Revolution%201.0.93.pdf

DW with WInXP

Hi.
I have Question.. If possible install the olap server with winXP to
make cubes in my computer non in the server to practices? if is yes,
what am I Must to do?
thanks
Nacho
Yes, you can install a local MS Analysis service and also the developer
version of SQL Server.
"Nacho" <mikicazares@.yahoo.com> wrote in message
news:1121443964.702273.10790@.o13g2000cwo.googlegro ups.com...
> Hi.
> I have Question.. If possible install the olap server with winXP to
> make cubes in my computer non in the server to practices? if is yes,
> what am I Must to do?
> thanks
> Nacho
>
|||Correct you can -- use the Developer Edition for both SQL and for AS.
I run my laptop like that all of the time.
Dave Wickert [MSFT]
dwickert@.online.microsoft.com
Program Manager
BI SystemsTeam
SQL BI Product Unit (Analysis Services)
This posting is provided "AS IS" with no warranties, and confers no rights.
"JT" <someone@.microsoft.com> wrote in message
news:%23VbbO1XiFHA.2904@.tk2msftngp13.phx.gbl...
> Yes, you can install a local MS Analysis service and also the developer
> version of SQL Server.
> "Nacho" <mikicazares@.yahoo.com> wrote in message
> news:1121443964.702273.10790@.o13g2000cwo.googlegro ups.com...
>
|||hello JT.. thanks for your answer, but i dont know when I connect to my
computer in the analysis server said "Unable to connect to the registry
on the server (Micomputer) , or you are not a member of the OLAP
Administrators group on this server"... Why said this? I install
everything in my computer, I need to change my users...
thanks
|||There are many explanations to that error message. It is a catch-all for
many problems.
Look at the Problem Sovling Tips section in the AS Operations Guide. I
review a couple of them there. Also there is a section on the Administrator
Security which talks a bit about various services which must be running.
http://www.microsoft.com/technet/pro.../anservog.mspx
Dave Wickert [MSFT]
dwickert@.online.microsoft.com
Program Manager
BI SystemsTeam
SQL BI Product Unit (Analysis Services)
This posting is provided "AS IS" with no warranties, and confers no rights.
"Nacho" <mikicazares@.yahoo.com> wrote in message
news:1121888852.767179.212390@.g47g2000cwa.googlegr oups.com...
> hello JT.. thanks for your answer, but i dont know when I connect to my
> computer in the analysis server said "Unable to connect to the registry
> on the server (Micomputer) , or you are not a member of the OLAP
> Administrators group on this server"... Why said this? I install
> everything in my computer, I need to change my users...
> thanks
>

DW with WInXP

Hi.
I have Question.. If possible install the olap server with winXP to
make cubes in my computer non in the server to practices? if is yes,
what am I Must to do?
thanks
NachoYes, you can install a local MS Analysis service and also the developer
version of SQL Server.
"Nacho" <mikicazares@.yahoo.com> wrote in message
news:1121443964.702273.10790@.o13g2000cwo.googlegroups.com...
> Hi.
> I have Question.. If possible install the olap server with winXP to
> make cubes in my computer non in the server to practices? if is yes,
> what am I Must to do?
> thanks
> Nacho
>|||Correct you can -- use the Developer Edition for both SQL and for AS.
I run my laptop like that all of the time.
--
Dave Wickert [MSFT]
dwickert@.online.microsoft.com
Program Manager
BI SystemsTeam
SQL BI Product Unit (Analysis Services)
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"JT" <someone@.microsoft.com> wrote in message
news:%23VbbO1XiFHA.2904@.tk2msftngp13.phx.gbl...
> Yes, you can install a local MS Analysis service and also the developer
> version of SQL Server.
> "Nacho" <mikicazares@.yahoo.com> wrote in message
> news:1121443964.702273.10790@.o13g2000cwo.googlegroups.com...
>|||hello JT.. thanks for your answer, but i dont know when I connect to my
computer in the analysis server said "Unable to connect to the registry
on the server (Micomputer) , or you are not a member of the OLAP
Administrators group on this server"... Why said this? I install
everything in my computer, I need to change my users...
thanks|||There are many explanations to that error message. It is a catch-all for
many problems.
Look at the Problem Sovling Tips section in the AS Operations Guide. I
review a couple of them there. Also there is a section on the Administrator
Security which talks a bit about various services which must be running.
http://www.microsoft.com/technet/pr...n/anservog.mspx
--
Dave Wickert [MSFT]
dwickert@.online.microsoft.com
Program Manager
BI SystemsTeam
SQL BI Product Unit (Analysis Services)
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"Nacho" <mikicazares@.yahoo.com> wrote in message
news:1121888852.767179.212390@.g47g2000cwa.googlegroups.com...
> hello JT.. thanks for your answer, but i dont know when I connect to my
> computer in the analysis server said "Unable to connect to the registry
> on the server (Micomputer) , or you are not a member of the OLAP
> Administrators group on this server"... Why said this? I install
> everything in my computer, I need to change my users...
> thanks
>