map using

[ali_hijazi]

I got several fact tables concatenated together these tables share some columns and one of the shared columns is used as a flag to know each record to which fact or module it belongs to and there are columns

the data is something like this

A. B. flag. GroupCurrency

xx 4500 finance usd

yy 2500 finance aed

zzz 500 productivity

add 200 producticity

...

on the same sheet there are charts displaying figures related to different flags

however if user wants to filter by group currency the charts displaying info related to productivity will show nothing

so I thought I map all null fields to the value * using map using

does this affect performance or expressin results? Knowing that I will apply this on several columns as the fact table has about 15 columns that are not shared between modules (flags)

[Carlos_Reyes]

I don't follow your idea about using MAP USING...

Isn't it correct that charts displaying info related to productivity don't show data because these records don't have GroupCurrecy values?

[ali_hijazi]

yes but when I map null values to * and use Star is * they will display

[Carlos_Reyes]

Well, if that way you get the desired result it's ok. I just think that it may be misleading to show all types of records regardless that field selections, but I'm sure you already thought about that.

About performance issues? I don't see why using that method will create more performance issues than the number of records or the complexity of your expressions. In my experience 15 columns is not a big deal, you bettter optimize your expressions or reduce the amount of data if you get performance issues.