Re: Calculated members security
- From: "Thomas Ivarsson" <TI@xxxxxxxxxx>
- Date: Mon, 23 May 2005 22:10:54 +0200
1. Measures and calculated members are not in the same folder in the cube
editor, so I do not think this i possible. The order of measures and
calculated members depends on the client you use. In ProClarity professional
6.0 they will be listed in alphabetic order by their names.
2. Use the visibility property of the measures and set them to hidden. This
means that no one can see the base measures irregardless of the role they
are mapped to.
Hopes this helps
Regards
/Thomas Ivarsson
"akber via SQLMonster.com" <forum@xxxxxxxxxxxxxxxxxxxxx> wrote in message
news:bee1b3b4d8e84d38a727d34b26842bb7@xxxxxxxxxxxxxxxxx
> Hi,
>
> I have a virtual cube that have measures from the base cubes. In addition
> to the base cube measures I have some calculated members also which are
> using the base cube measures.
>
> There are two questions:
>
> 1. Is there any option through which I can order the measures in the
> virtual cube such that calculated members always appear before the actual
> base cube measures.
>
> 2. In the cube security, how I can create a role that would restrict the
> base cube actual measures but not the calculated member that is using the
> actual measure which I don't want this particular role to have access but
> other roles can. In the cube security what I have noticed is that when I
> restrict the actual base cube measure it also restricts the role from the
> caculated members (which I dont want)
>
> Any help would be greatly appreciated.
>
> Thanks.
> Akber
.
- References:
- Calculated members security
- From: akber via SQLMonster.com
- Calculated members security
- Prev by Date: Year Ago Calculation on PERIOD Hierarchy
- Next by Date: Re: table structure for olap
- Previous by thread: Calculated members security
- Next by thread: Aggregation Types (Additive or NOT) and Distinct count.
- Index(es):
Relevant Pages
|
