Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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)
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?
yes but when I map null values to * and use Star is * they will display
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.