Cube Roles - How to restrict access to certain members

I have a dimension called Account that has five levels. I'm trying to define a cube role to deny access to accounts in the lowest level that starts with the letters GL. I tried applying a filter in the dimension data tab in the role designer, however, this only seems to create a static rule. The account structure gets updated all the time and I want to restrict access to all accounts that start with the letters GL now and in the future.

When I created a rule in another dimension using a top-level static member, a denied member set was created in the advanced tab. I think I need to create something similar for the Account dimension, but I just can't get the syntax of MDX. I tried the BOL samples but can't find anything since I want to filter only part of the member name.

Try typing something like the following expression for DeniedSet:

Filter(Account.Levels(4), Account.Name >= 'GL' AND Account.Name < 'GM')

|||

Thanks, but that didn't work. In addition, I tried Filter([Account].Members, Left([Account].CurrentMember.Name, 2) = "GL") but that didn't work either. I'm wondering if there are too many members to filter at the bottom level.

Oddly, I was able to solve part of the problem by Enabling Visual Total in my other dimensions. I can filter GL type accounts in my other dimensions because there is only one fixed GL member in those dimensions. Since GL accounts only match up to the GL members in the other dimensions and since those GL members have been filtered, GL Accounts are not displayed in the cube result.

I will still try to find a solution, although I can restrict GL data from being displayed in the cube, the GL accounts still show up in the drop down. It's a good thing that when the user selects GL accounts, nothing is displayed.

Cube Deploying error in SQL2005

Hi All
When I deploy a cube it starts processing then comes up with the error
"connection was either timed out or lost". This also manages to stop the
Analysis Services Service on the Server.
Any ideas?
Thanks
Peterepost in these and you'll probably get a quick responce:
http://groups.google.com/group/micr...ver.olap?lnk=li
[url]http://groups.google.com/group/microsoft.public.sqlserver.datawarehouse?lnk=li[/ur
l]
Byron
P wrote:
> Hi All
> When I deploy a cube it starts processing then comes up with the error
> "connection was either timed out or lost". This also manages to stop the
> Analysis Services Service on the Server.
> Any ideas?
> Thanks
> Pete

Cube aggregations stop unexpectedly

I am trying to design agreegations for all the partitions of my MOLAP cube. The aggregation calculation process starts but stops at 2% performance (about 20MB).

I have tried to re-argregate so many times by selecting all the options :-

Estimated Storage reaches (100 MB) /
Performance gain reaches (30%)/
I click Stop

But, in all these cases it just stops at 2%. I cannot understand why? And its not one particular partition. Rather all the partitions (eight of them) stop at 2%. There is enough free hard disk space as well (27 gb)

Any, clues could be of great help. Thanks.

Any idea from the MS Analysis services group?|||

The problem is that not all attributes are considered during aggregation design.

Try creating more user hierarchies. Try marking cube attribute AggregationUsage property as Unrestricted.

Hope that helps

Edward.
--
This posting is provided "AS IS" with no warranties, and confers no rights

Crytalreports.msi file

I have a barcode printing formula in my report.when I run the report it starts looking for Crytalreports.msi file.Is this file required to print barcode?I have a barcode printing formula in my report.when I run the report it starts looking for Crytalreports.msi file.Is this file required to print barcode?
It seems your report is trying to access unregistered COM of Crystal Reports.
It might be better to reinstall Crystal Reports in your user account.