Data Display in Reports based on windows Authentication ID

Hi Experts,

I have a reporting scenario, where the reports are fetched from Analysis Services.

The reports should display data only spcecific to that user.

All users except those in admin roles should be validated using the Windows Authentication ID and data specific to them has to be displayed.

Any pointers/suggestions on how to implement this in Reporting services/ Analysis Services 2005 would be highly appreciated

Thanks,

Hi,

Easier said than done. I guess that the easier path would be to use data filtering based on parameters values limited by userid.

It depends, if you access cubes directly as well, i.e. from Excel, then that would be different. You would have to create custom MDX dimension access formulas based on roles and map these roles to Windows groups.

Assuming you are only going after AS data from RS, then you would still need to create an access policy.

i.e. you can segregate access to data slices based on membership to Windows groups.

We have found that using cumulative membership to groups was the most flexible and did not require too many groups.

You have to find a way to load LDAP (or Windows AD groups and membership) data, then each time an user access the report, you use the userid info to check what is the acceptable list of values for your parameters.

This way, a given user will be able to see and select only parameters values acceptable for her job function.

That is quite a lot of code, functions and procedures to write, no quick fix.

First thing first, you need the AD or LDAP data, there are quite a few ways to get it. I remember that SQL Server magazine ran an article a few month ago about getting it with a SSIS package.

You can also settle for another easier way, like calling Exporter Pro from a Windows scheduled task. Exporter Pro is part of the Hyena software.

Your question is not the type of question where a quick and precise answer is available. I can only give some high level clues. The rest would take time and require insider knowledge of your situation and requirements.

Hope it helps somehow

Philippe

Data Cubes using MS Analysis Services

I need to use cubes in VS 2005 web project. I have no clue how to create cubes or use them in my web page. I am familiar with Reporting Services but not cubes.

thanks in advance!

In SQL Server 2005 it depends on where your data is comming from, if you have a Data Warehouse running you can create the Cubes in Analysis Service but SQL Server 2005 also comes with UDM(unified dimension modeling) stripping the Algebra and moving to calculus in one step, some thing you need tools like Hyperion to do in SQL Server 2000. Try the link below for some SQL Server 2005 Analysis resources including UDM. Hope this helps.

http://www.mosha.com/msolap/yukon.htm

|||Thanks Caddre. I am sure I will find lots of info there. I also found this link: http://www.microsoft.com/technet/prodtechnol/sql/default.mspx.|||

Hi,

I have created a cube using MS Analysis Services 2005. I have a fact table that contains 6 different measures (actualUSrevenue, actualEURrevenue,Qty) and (scheduledUSrevenue,scheduledEURrevenue,scheduledQty). How do I break these up into two separate groups of measures.

I will be taking these separate measure groups to build a stacked column chart with both actual and scheduled in the same column but each in a separate series.

thanks,

marilyn

marilyn.beaudreau@.philips.com

|||

There is very good sample code from Microsoft in the file below and the second link is a tutorial to get you started. Hope this helps.

http://www.microsoft.com/downloads/details.aspx?FamilyID=790d631b-bff9-4f4a-b648-e9209e6ac8ad&DisplayLang=en

http://www.databasejournal.com/article.php/1459531

Dashboard on MSRS

Hi Everybody,

I am new to MSRS, just want to ask, can we create a dashboard on MSRS. Which will have tabs on top for different analysis.

Thanks in advance,

Siddharth Rai.

The Microsoft dashboard platform is WSS (Windows SharePoint Services) 3.0 which is freely availalble add-on to Windows Server. Starting with SQL Server SP2, you can deploy reports to a SharePoint site and you can have multiple report views on the same page.

|||Hey thanks Teo... thanks a ton..

Dashboard Guage type graph?

Hi,
I am on RS sp1, I have developed several reports bases on Analysis Services
cubes. I use in the reports several pie, bar, etc charts. I would like to
know if there is a Dashboard type Guage chart ( sort of like a speedometer
in the dashboard of one's car) in the RS graphicas library, maybe not built
in but can be added to the RS existing Graphics library, where I can use it
seemlesly as if it wa part of the product. If an addition exists, how do I
get it and what is the procedure to add it in.
Thank you in advance for your help.
--
Message posted via http://www.sqlmonster.comwould't that be nice. The extensions RS are very expensive. Every executive
now wants some sort of analog guage to display the overall aggregates of
their metrics at different levels of the enterprise.
--
Message posted via http://www.sqlmonster.com|||Here is an idea:
You could try creating a background image that gives the appearance of
the dashboard, then use a pie-chart with 2 values to act as the guage.
If you place it just right, you may be able to simulate the "Guage"
appearance you want.
Good luck!
~Lance Hunt
http://weblogs.asp.net/lhunt/