.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Gaurav Pal
Post New Web Links

SSRS and Cube Roles on Internet

Posted By:      Posted Date: September 16, 2010    Points: 0   Category :Sql Server
Hi, I have a question: I have two reports in ssrs report server sourcing a SSAS cube which is on a same server. Now i want the ssrs manager portal to connect by some user over the internet and i want to have roles in cube to that public user in the cube. The public user will not be the part of the domain user where the SQL Server instance is installed. The user is some external user. I am ol with building a custom asp.net portal for this also but the roles in the cube must be applied to public user. So when public user connect to portal and executes a SSRS report he should see the data for which he will be reposible. We can maintaina mapping table if required for the public users. Please let me know how to move forward on this

View Complete Post

More Related Resource Links

needed information about the roles of access for a cube

we have a cube (regarding insurance), which is accessed by users by an excel sheet? now they want to restrict the grand total view by the users depending on the user id, i.e there are AccountExecutives each AccountExecutive must be allowed to view only commision related to them. How can it be achieved? and where can I get the information related to the roles and the permissions to access dimensions and restricting access to data depending on user id s? (kindly provide as much detail as you can, because I am new to ssas)

SSRS 2008 Against OLAP Cube reports rendering slow in IE 6 and IE8

We have SSAS cube built on SQL Server 2008 that has multiple parameters that have a default vault on running of all. The first time we run the report it renders the report in less than 30 seconds, but when we change one value on the data cube pull the reports can take up to 5 mins to run. If I do the same report in Firefox 3.6 it renders the report in 30 seconds. I have change changing the cache size in the IE explorer and ave the latest .net frame work on the computer. What would be causing this issue? The company upgrade from SSRS, SSIS, SSAS, SQL 2005 to 2008. Please advice, this is very annoying for our business end users.   Thanks for your help in advance.

How to enable caching on SSRS that using SSAS cube to bind data


Hi All 

 How to set Cach refersh option for a SSRS report that using SSAS cube to bind data 

when i tried to store credential in data source getting error as show below 

"Non-Windows user credentials were supplied for a non-http connection to Analysis Services. The Microsoft SQL Server Analysis Services data extension requires Windows Integrated Security unless connecting via http or https."





Setting Auto-Rules in Cube Security Roles configuration




Our client's requirements for some Charts are simply:

1. Users with no access to specific Business Units (A Dimension with Parent-Child Hierarchy, refereed as BU from now) shall see the total amount (Revenues for example) of All Top Parent BUs but should not be able to drill down on any of the children BUs of the Top Parent BUs they don't have access to.

2. Users with full access to specific BUs shall be able to see the whole value of All Top  Parent BUs and their children BUs as well.



1. User with No Access to  BU 'A' shall see the total Value for this BU A, but cannot drill down to A1,A2,Ax.. which are children of A.

2. User with Full Access to  BU 'A' shall see the total Value for this BU A, and can drill down to A1,A2,Ax..


For disabling access to specific BUs with the ability to see their total values, I did the following in the cube security roles configuration (Consider the latter Example #1):

1. In the Dimension Data Page, I chose the radio box Select all members, And checked the box beside the BU A, unchecked all

SSRS 2008 formatting issue - different in visual studio preview/pdf/excel vs. internet explorer


The formatting of the report is perfect when viewed in Visual studio and also after exporting it to pdf or excel. But when I deployed my solution and opened it on IE/Firefox there is a lot of problem in formatting. Specifically the row height is giving me a problem. I manually entered them to be 0.1in and made the CanGrow field as false to force that row height but some rows in the tablix expand ( to 0.15in, which is the height of my header). This is true for a matrix as well. Is there is a feature to lock the row height in IE o any other web browser?


SSRS 2008 Interface with cube data source


Hi All,

Need some brainstorming and your experience here. Here is a situation and would like to understand your thoughts on this.

1. We have developed some cubes using SSAS 2008 to analyse the data.

2. We had some reporting requirement in the past and we decided to use our cube as a data source for the reports and develop using SSRS 2008.

3. We have developed many reports using the SSRS.

4. Now when the reports are passed on to the end users, they are not liking the SSRS interface...like at present we cannot increase the size of the drop down box, sorting any many other things..

As you might already know the SSRS interface i

Default date selection in SSRS with SSAS cube as a source




I am fairly new to SSAS and I am hoping that someone can help me with an issue I am experiencing.  I am create a SSRS report that goes against a SSAS cube.  My cube has a Date dimension with a Fiscal Year - Fiscal Quarter - Fiscal Month hierarchy.  In my report I have created filters for a From Date and a To Date, which are populated with the hierarchy of the Date dimension.


I need to default the filters as follows:


To Date = current quarter (that is the last quarter with fact data)

From Date = the To Date quarter from the previous year (e.g. if To Date quarter = Q1 2008, then From Date quarter needs to be Q1 2007)


I found some SSAS code that allows me to get the index of the last quarter with data, but I am stuck at this point.  I am not sure how I can translate this into a default selection for the To Date SSRS report parameter.  I also realize that there may be a better approach.



SSRS Roles


What is the difference between the tasks "Consume reports" and "View reports" .  What does "Reads report definitions" mean?


Our goal is to prevent users from running reports but allow them to view reports from the history tab.  Is this possible?  If not what would be a work-around?


Value in cube not showing in SSRS report



I'm scratching my head on this one!

I have an MDX query which gives me the value 287529 for a field. I can see this in SSAS, excel, and in the query designer is SSRS but when the report renders it brings back 0 for that field.

All other fields are okay its just that one. I have taken off alll cell formatting in the mdx script and on the report.


Any iedas...


Many thanks.



Strange results in SSRS query to Cube


I have discoverred a strange issue when running a MDX query from SSRS 2005. The (All) member of a dimension is comming back as "(null)" instead of "All". The identical query run from SSMS produces the correct results. Some thing to mention is that we are in a phase for the next few days where there are no fact records in my cube (essentially no data, but dimensions are populated). Below is my Query. The problem is with the Subscriber dimension. FYI - I am using SSAS 2005 with SSRS 2005
 SELECT { [Measures].[Total Volume In Bytes]} ON COLUMNS, 
  ({[Subscriber].[Role].Members } * [Traffic Class].[On Off].[On Off].Members) ON ROWS
from [Cube Name] 
Below is the result (correct) from SSMS
    Total Volume In Bytes

show part of the Cube data in SSRS report prompts



I have generated one report in SSRS 2008 report designer, and one prompt was added in it. when I am running this report, selecting the data from prompts, it shows all the Cube data for this field.

But I want only a small part from cube data, how can I make this? Thanks!


Connie Zhu

Prompted for network credentials via internet while accessing SSRS reports in SharePoint integrated


We have developed a SharePoint- FBA site and published it through ISA.  The site, among many features, displays SSRS reports through Performance Point Monitoring dashboards.  SSRS is using windows integrated authentication (Kerberos).  Through intranet, the reports are getting displayed without any issue, but, through internet, its getting prompted when we try to access the reports for the first time after logging into the site using FBA credentials.  When we enter valid domain credentials after being prompted, it starts displaying reports without any issues and never prompts again for that FBA session.

We have been trying to eliminate the prompt through internet, but couldn't do so. 

Has anyone experienced the same before?

Any help is appreciated.

Delpoy Cube in BIDS - without deploying roles.



I am currently using BIDS to deploy my cube into 3 different enviroments, Dev, QC, Prod.

The issue that I am having is that I have different roles in all three environments.  The roles that are in the solution are for Production.

So, that means that when I deploy to Dev or QC the roles that I have specific to those environments are getting overwritten.

Is there a way to deploy the cube schema through BIDS without deploying roles?

Thanks in advance.

ASP.NET forms authentication with roles

.A timeout is specified in minutes. This is "time since last request" not the "time since login". If a login is indicated to be persistent (described later) this is ignored.
.A protection method is specified for the cookie.
Next I wanted to specify a folder to which access is restricted to people who have logged in. To do this I entered the following code in the web.config file (beneath

Hard Code Roles on the Pages


If i hard coded role=Manager on the specific SiteMap/Folder/Page/etc. I will have problem when the manager need to remove from access a specific page. I need to change the code ont eh page/SiteMap/Folder more move the file into another folder.

What i have in mind is to change the role to taks oriented. such as role=AddStock, Edit Stock, Delete Stock, Print DO, Add Sales, Edit Sales, Deleted Sales..... (but it will be many role for 1 user compare to just 1 as Manager)

Will this cause performance issues later when each user have 60 roles and if i have 20,000 user will it affect the application performance?

Otherwise any other option? to make it flexible.

where can i download from SSRS?


Hi all,

My  machine is alread installed with Sql Server 2005.  I need to install sql server 2005 reporting services as a add-on.

Where can i download this from. Can anyone post the link here..?


Thanks in advance


MDX Query parameter from SSRS


I've a MDX Query that has where clause as shown below.
I'm designing report using SSRS 2008. How can i pass date as parameter ? I tried to setup @from and @to as parameter but not working ?
any ideas....

WHERE ( {[Date Central].[Calendar Date].[2010-04-01 00:00:00]:[Date Central].[Calendar Date].[2010-08-30 00:00:00]} )

need it to work as
WHERE ( {[Date Central].[Calendar Date].[@From]:[Date Central].[Calendar Date].[@To]} )



ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend