Re: Allowed Member Set with 2 Attributes
Based on my understanding of your dimension data, the scenario doesn't
quite match my Adventure Works Promotion example, because multiple
hierarchy members with different companies are to be allowed.
You could use cell security instead; but the only dimension security
solution that I can think of would entail adding another "Location
Division" attribute to your dimension, which would then be secured. This
attribute would have a composite key of {Company, Location Division}, so
that you could directly specify the Allowed Member Set for this
attribute. This is analogous to the [Month Of Year] and [Month Name]
attributes in the Date dimension of Adventure Works. A [Month Of Year]
allowed member set will not restrict the parent year, but a [Month Name]
member selects both year and month. In your case, a member would
simultaneously select both Company and Location Division.
- Deepak
Deepak Puri
Microsoft MVP - SQL Server
*** Sent via Developersdex
http://www.developersdex.com ***
.
Relevant Pages
- Re: Slow member loading in excel 2003 pivot table
... it loads member quickly... ... I'm gonna add a transform step in my cube loading and just truncate the data... ... Maybe a simply filter another file extension dimension table with a ">3)" and set all the fact with the missing key error to a default member... ... I'm gonna sound crazy, bu I need to find a way to create various sized dimension and see how excel react and display them, I want to range from ...
(microsoft.public.sqlserver.olap) - Re: Slow member loading in excel 2003 pivot table
... The more I think about it, the more I fear the "almost instantaneous" display of this dimension member was just a dream:'( ... I'm gonna sound crazy, bu I need to find a way to create various sized dimension and see how excel react and display them, I want to range from 2K to 30K with a 2K step... ... I couldn't process the cube anymore or load 2 smaller cube with 500MB dimtree. ...
(microsoft.public.sqlserver.olap) - Re: Slow member loading in excel 2003 pivot table
... I couldn't process the cube anymore or load 2 smaller cube with 500MB dimtree. ... with the cube browser in Visual Studio, the first load is long, but then the add/remove from the browser became instantaneous. ... and it is longer than a similar member data set (the only difference is this big parent child dimension which is smaller) ...
(microsoft.public.sqlserver.olap) - RE: How to count the cells between CURRENTMEMBER and LastNonEmpty?
... Slicing doesn't change the members of a set at all, ... change the current member of, making it useless to do any kind of IIF ... One solution--given the dimension assumptions I stated ... the time.CURRENTMEMBER of a specified product and its last sale. ...
(microsoft.public.sqlserver.olap) - Re: Slow member loading in excel 2003 pivot table
... Did you try Excel 2007? ... it loads member quickly... ... I'm gonna add a transform step in my cube loading and just truncate the ... (that way I could still have the whole dimension available, ...
(microsoft.public.sqlserver.olap) |
|
