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 default value for parameter in OLAP report

I have a basic SSRS report against an SSAS database with a "start date" parameter. I want to set the default value of that date parameter to Today's date. What is the easiest way to do this? I have no problem doing it against a relational source, just haven't done it against an OLAP source.

Thanks for any ideas.

-Josh R.

At parameter properties page in section "Default values" check radio button "Non-queried" and then at Expression box write:

=Today

Dynamic default value for parameter in OLAP report

I'm trying to set up a parameter report from a OLAP cube. I need 3 dynamic parameters(ThisYear, ThisMonth, YESTERDAY).

THISYEAR: =CStr(DatePart("yyyy",Today()))

THISWEEK: =CSTR(DATEPART("ww",Today()))

YESTERDAY: =CSTR(Datepart("d", Today().AddDays(-1)))

So far so good. I want to send this report by email everyday, so I need to set these parameters as a default value. This is where I run into problems.

When I add any of these parameters I get the following error "The restrictions by the CONSTRAINED flag in the STRTOSET function were violated". This problem occur when I choose NON-queried under Report->Report Parameters, and set a default value for THISYEAR under DEFAULT VALUES

=CStr(DatePart("yyyy",Today()))

Hope someone found a way around this problem.

Thanks in advance!

It is because ASPNET user on the server machine does not have rights to access system date and time. On the report server, go to Control Panel -> Administrative Tools -> Local Security Policy and then select "Change the system time" and right click and select Properties. Then click on Add User or Group and add ServerName\ASPNET user to that list.

Also try this work around if you dont have access to the report server:

Create a new dataset called "DataSet2" and type the SQL text as SELECT GETDATE() AS CurrentDate

And use First(Fields!CurrentDate, "DataSet2") in place of Today() in your above default value expressions for parameters.

Shyam

|||I am using Reporting Services, so ASPNET user is not an issue here. I tried to create a new dataset, but I get an error that says that "Fields cannot be used in report parameter expressions". Any ideas?

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
>