April 21, 2004 at 11:15 am
HI ALL,
sorry for my english,
i have a problem. I neet do display some members on dimensions on depending by a date!
Es.
12/03/2003 i had 10 members
12/05/2003 i had 20 members
i want display 10 members on a dimension if i select 12/03/2003 in the oalp browser
or display 20 members if i select 12/05/2003.
Can anyone help me!!!
thanks in advance
Antonio
April 22, 2004 at 7:41 am
What client tool (ie olap browser) are you using? If you are refering to a fact table that contains products sold on particular days, then the measure you are viewing (say sales count) will be zero for those products not sold on 12/03/2003. Most browsers will let you suppress the members with empty (or sometimes preferably zero) values, which means that if you had your products on rows and the date on columns, suppressing your row zeros will show only those 10 products which had activity on the 12/03/2003. Changing the date to the 12/05/2003 (leaving suppression on) would result in only the products sold on that date being visible.
Excel does this by default (infact until you get the new AddIn Excel *always* suppresses empty cells), and you can get the 'viewer' within Analysis Manager to do the same thing by right clicking on the empty cell in the top left corner of the grid and unchecking the 'show empty members' option.
Steve.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply