Re: Using named set in calculated measures.

#1

mr im Tomas Suppo please contact me

Originally posted by Roberto Ferraris

Quote:

I need to define a set from the client application and use it in some
calculated

member defined on the cube. The set can be changed during the
execution so it need to

be re-created each time. I find a way to do this defining the
calculated members with

the StrToSet function: eg. CREATE MEMBER [Measures].[Qty %] AS
'[Qty] /

Sum(StrToSet("[MySet]"), [Qty]) and defining a set in the session as:
CREATE SET

[MyCube].[MySet] AS '{Member1, Member2}' Using the StrToSet let me
delete and

re-create the cube because the [Qty %] doesn't depend directly from
the set, but this

solution is slower than a simple: CREATE MEMBER [Measures].[Qty %] AS
'[Qty] /

Sum([MySet], [Qty]) with a static set defined.

I've also tried to define a default set on the cube and redefine it as
a session set

but it doesn't seems working, the CM use always the default set.

Any suggestion? There is a way to re-evaluate Sets without
deleting them?

Thanks in advice Roberto Ferraris

--
Posted via http://dbforums.com

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Re: Using named set in calculated measures.

microsoft.public.sqlserver.olap microsoft.public.sqlserver.olap

Re: Using named set in calculated measures. - 09-02-2003 , 02:06 PM