COgnos DImensional Reporting .
I have a regions dimension where top level regions are Asia, LatinAmerica and so and so .
I am creating a daily sales report and on first I dont know all regions will have values and members will be generated.
so step 1 ,
I create a filter to see if member caption exists
item(filter([DailySales].[Customers SoldTo].[Customers SoldTo].[SoldToRegions],caption(currentMember([DailySales].[Customers SoldTo].[Customers SoldTo]))='L00 - LATIN AMERICA'),0)
Then I create a member on regions dimension
member(Total (Tuple([Full Revenue],currentmember([DailySales].[Items].[Items])) within set set([LACAMCheck])),'LACAM','LACAM')
step 2,
I have created say five members like this and put them in rows.And Now I have a Total for these with expression
Total( CurrentMeasure within set set([US Regions],[LACAM],[Canada],[APAC],[EMEA]))
All regions and it totals if one of members is present or not
step 3 ,
Below this I add an MTD Total , to show the same total for MTD ,since my slicer has daily days, I use complete tuple here
CompleteTuple([Day],currentMember([DailySales].[Items].[Items]),[RegionForMTD],[Full Revenue])
Here the [RegionForMTD] = [US Regions]+[LACAM]+[Canada]+[APAC]+[EMEA].
Now the issue is everything works fine if there is a member matched with filter caption,
but if say LACAM is missing then the MTD Total comes blank and it s not calulating other totals.
so is there a way I can replace this expression in my complete tuple with Set or other way to calculate mtd total
[RegionForMTD] = [US Regions]+[LACAM]+[Canada]+[APAC]+[EMEA].
Thnaks,
Nithya