cka11


Hi,

I have an AS2000 utility dimension that hold one calculated member and one 'dummy' member for the fact - dimension join. I use it in a virtual cube to achive currency conversion and I implemented the utility dimension to be able to use it with the aggregrate function that Excel uses on multiple filter selections.

I want to prevent this dummy member to appear in my Excel pivot table. I have tried to use the setting 'Hide member if -No name' and it works great when I browse my cube in ASManager but when I browse it Excel 2007 I get a popup message saying something like 'member could not be found...'

Any idea

Thanks,Christer




Re: Hidden member causes Excel to throw error

Thomas Ivarsson


It has been some time since I have worked with AS2000 but I think there is a "Visible" property that you can set on your dummy member.

Another way can be to remove the parent for the calculated member in you shell dimension. Only use the dimension without parent member. 

HTH

Thomas Ivarsson






Re: Hidden member causes Excel to throw error

Mosha Pasumansky

Another thing to try is to change the default member for this dimension to point to the calculated member.