Home > Archive > MS SQL Server OLAP > August 2005 > Shared level in dimension screwed up the custom rollup formula









You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

 

Author Shared level in dimension screwed up the custom rollup formula
Joel Leong

2005-08-28, 3:23 am


I have
Packaging_Product_Sh
op with level packaging, product, shop
Shop_Packaging_Produ
ct with level shop, packaging, product
dimension.

When I put in
SUM(& #91;Product_Packagin
g_Shop].CurrentMember.children-& #91;Product_Packagin
g_Shop].CurrentMember.FirstChild)it works for Product_Packaging_Sh
op but other dimension, which shared thelevel, screwed up with #Value!. What has happen? What shoud i do to isolate th
is? IIf staement? Pleasehelp. TQ

Sponsored Links





Also available: Server administration forum archive | Web Design forum archive | Software forum archive | Hardware reviews archive | Programming forum archive

Copyright 2008 droptable.com