Showing posts with label login. Show all posts
Showing posts with label login. Show all posts

Friday, February 24, 2012

Cube Browser not filtering the data for the user having only read definition permission

Hi,

I am started working with SAS2005 recently. Using Adventure works sample database.

When I login to the Management Studio as administrator and browse the cube, the browser filters all the null value columns and rows.

Steps:

1. Add Product.Product Categories to filter area and select only Bikes

2. Add Date.Calendar.Date Calendar year to filter area and select year 2005

3. Add Product.Product to Row area

4. Add Measures.Internet Sales.Internet Sales Amount in the Total or detail area

5. Add [Date].[Month of Year] in the column area.

When I logged in as administrator or the user with the role Full control (administrator) and all the nessasary permission set on all the objects. The cube browser displays the data where only it has values. If the entire row or column are null then the row and columns are not displayed.

When I do the exactly same with the user has a role instead of full control using just read definition option (I do not want the user to get full permission, like to make a role as read only) , the browse cube shows all the rows and columns, even the row and columns where all the values are null.

The empty cells are displayed as #N/A.

Is it possible to make the browser behave for the read only user as exactly like administrator user.

Any suggestions and recommendations are great.

Thanks

I am stuck with this problem. Please somebody help...

Tuesday, February 14, 2012

CrystalReportViewer check for guest login

Hi all

I have added crystalreportviewer using ASP .net (VB .net)

I was able to view the report when I run the web page on
my server. Everything seems fine on the server.

However, if I access the crystal report on a client machine,
it will prompt for guest login and password to the server machine.

I am using anonymous access for my IIS setting.
I can access the rest of the .net webpage without any problem.
However, when I enter the webpage with the crystalreportviewer,
it will prompt for guest password.

Even after I have keyed in the guest password, mutiple prompts appear again. The server event log show this error -
The server was unable to logon the Windows NT account 'IUSR_Machinename' due to the following error: Logon failure: unknown user name or bad password. The data is the error code.

After canceling the prompt a few times, it will show the page with
the report and its data but the sort tree and reportviewer
functions bar on top will show all weird marking. :(

For testing, I have tried adding just a crystalreportviewer object
on a empty webpage. I did not link the crystalreportviewer to
any .rpt file and the same prompt appear. Its seems that the
crystalreportviewer object need to be authenticated on the server
when accessing from the client machine.

I am using MS studio 2003 and IIS 5.1 on XP professional server.

Please help advice.

Thanks.
DerekHi all,

I have found the solution myself.

Give access rights to this folder
C:\Program Files\Microsoft Visual Studio .NET 2003\Crystal Reports

to the IUSR_<MACHINENAME> anonymous account.

This is because all the .net dll for crystal report is installed in
this folder. Hence the correct access should be provided to this
folder.

Regards,
Derek