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].&
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
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
> > 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.