ReportPortal
ReportPortal
Home | Profile | Register | Active Topics | Members | Search | FAQ
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server General Issues
 SQL Server Analysis Services (SSAS)
 Filter a cube
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

adtvnetwork

United Arab Emirates
2 Posts

Posted - 07/10/2012 :  02:32:30  Show Profile  Reply with Quote
Hi,

I have two cubes in same database.
When I am creating a XMLA URL connection both the cubes are visible to user. (I am using IUSR authentication)
Is there any way to hide one cube.
Actually I want to create two connection each of them will connect to separate cube; it will help me to create proper permission to end users.


Regards
Tarun Ghosh

marco

Netherlands
588 Posts

Posted - 07/10/2012 :  12:39:24  Show Profile  Reply with Quote
Hi,

Which SQL Server 2005, 2008, 2012 are you using for SSAS Dimensiona or Tabular Model ?

If you use authentication you can show on/off dimension members, perspectives, groups, cubes and olap databases.

If you have questions, please let me know.

Regards, Marco
Go to Top of Page

adtvnetwork

United Arab Emirates
2 Posts

Posted - 07/10/2012 :  23:40:07  Show Profile  Reply with Quote
Hi macro,

I am using sql server 2008 R2 SSAS Dimensiona.
I cannot use domain authentication; so in role I have given full access to IUSR; Is there anyoption to restrict cube list in report portal data connection settings.

Regards
Tarun Ghosh
Go to Top of Page

JonesGaron

USA
1 Posts

Posted - 11/06/2013 :  02:55:20  Show Profile  Reply with Quote
Could you please send me the demo so that I can clearly understand those things.
bar chart

Edited by - JonesGaron on 11/06/2013 03:01:19
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
ReportPortal © 2000-2002 Snitz Communications Go To Top Of Page