Jr?me,

I am defining cusom rollup formula in cube.

I did made it work by defining it in virtual cube as well, though I am not

happy with this approach.

I would be better if virual cube would use rollup formulas defined in base

cubes. Is that doable?

Example of my formula:

IIF([Report Currency].CurrentMember IS [Report Currency].&[255]

OR Measures.CurrentMember.UniqueName = "[Measures].[NonCurrencyMeasureName]"

, [Report Currency].Ignore

, [Report Currency].Ignore * LookupCube("CurrencyConvertCube","

(Measures.CurrencyValue, [Local Currency].[US$], [Report Currency].[CA$])

)

I was able to make this formula work just with function .Ignore, but I am

woring that this function is not described in BOL. Is there any way to write

same formula?

Thank you for your help.

> Have you any sample of your custom rollup formula?

> where are you defined this formula? (in a specific cube, in the shared

> dimension?)

> > Hi,

> > I have a cube that contains custom rollup formulas on one level of one

> > dimension. This works OK and all data looks like expected. Now if I

> > create virtual cube that is based on that cube (all same dim and same

> > measures), I loose all functionality of custom rollup formulas - I

> > just get standard aggregations. Ayone could help me with this problem?

> > I do this that I have an option to specify new custom rollup formula

> > for the same level in dimension, but I would like to keep formulas

> > from base cubes.

> > At this point I am trying custom rollup formulas work just with one

> > cube in virtual cube. Of course ultimatelly I will have more than one

> > cube in this virtual cube, and each base cube will have custom rollup

> > formulas defined on them.

> > Thank you,

> > Alex M.