Hi,

I have a simple lookup cube with Time, Product and 1 measure called
Budget. In the lookup cube Product doesn't go down to the lowest
level like it does in the virtual cube.

eg.
Product
-->Type Level 1 - Lookup cube only goes to this level.
-->Category Level 2
-->Widget Level 3 - All other cubes

This budget is the budget per product at the lowest level, however the
customer wants a quite odd setup, so what i need to do is carry that
Level 1 value all the way down to Level 3 in the cube. So the cube
would show values like

Product
-->40
-->40
-->40

In my lookup cube statement i only need the first level membername
passed to the lookup cube, this is what i have so far, however when
you drill below level 1 i get ERR#

LookupCube("ProductBenchmark","([Measures].[Benchmark], " +
Time.Currentmember.UniqueName + ", " +
[Product].CurrentMember.UniqueName + ")")

Thanks to anyone that can help

Regards

Ben

You could use :

ancestor([Product].CurrentMember.UniqueName ,[Type])

in your lookup expression.
HTH,
Brian
www.geocities.com/brianaltmann/olap.html

"Benaud" wrote: