Generate calculated members automatically ?

[jcoira]

Hi,

I need to create a set of calculated members (around 30) in one of my OLAP cubes and would like to do it from a script or something similar to avoid the laborious task of creating them one by one (calculations are very similar)

Maybe using DSO object model or MDX I can do it but I cannot figure out how.

Any clue?

Thank you

// jcoira

 

[MDXer]

I have a dso app the reads in a file of containg Calculated measures and runs them using the Creat Command Statement.

Set your Server and DB and Cube properties the use the DSO.Command.

the mdx looks like this

CREATE MEMBER CURRENTCUBE.<Dimension>.[RAC] AS 'MDX'

Hope this helps.
Paul

 

[jcoira]

Thank you Paul. It seems to be what I need.

 

[jcoira]

It worked !

Thanks.

// jcoira