Set expression issue..??

[vishalgoud]

Team ,

we have 5 tables and each tables is having a separate flag field, so that we can differentiate and compare the data together,remianing all columns are common in all 5 tables and we are concatinating all into a single fact.  in the below expression Flag_EE is from table EE.

sum({<Flag_EE={1},[Call Type]={Voice}>} $(vShowDurationAs))

is my above expression is right to get the data from a single table where Flag_EE =1 is the defualt value we are giving in that table.

and call type and $(vShowDurationAs coming from over all fact table which is a combination of all 5 tables..

Now i want to get the data from the table 5 where the flag is Flag_EE, am i using the correct set exp ???

please advise..

[sunny_talwar]

Looks right to me... is it not working?

[vishalgoud]

it is working Sunny, But business was saying that the counts are coming from all the tables not from a single EE table where i was bit confused.

in the set modifiers whatever we mention then the set expression pick the resultant counts only right ??

in the Qvd we are taking 1 as Flag_EE and am using Flag_EE={1} which is correct only right ??

[sunny_talwar · Accepted solution]

As far as I know and understand, what you are saying is correct. If you have flagged a single table with 1, and you use it in your set analysis, then it should show you the count from that table only. May be someone else can verify me here. pcammaert‌

[Clever_Anjos]

You´re right stalwar1‌, as usual

vishalgoud,please elaborate a bit more what you mean by

"vShowDurationAs coming from over all fact table which is a combination of all 5 tables"

[Peter_Cammaert]

It probably depends on how the table containing Flag_EE links to the central table, if I understand it right that the common data is residing in a central table.

To be absolutely sure that no other records are used when a particular flag is chosen, it may be better to throw everything together and add a single Flag that contains values identitying the different sources (Set analysis then becomes Flag={EE} or something). If possible.