Further note, I found the root cause of this issue. It happened when I specify the decimal digits in the property of the chart. Looks it's a bug from BIP? Any solution to avoid this issue by upgrading Word?

Wow...You didn't answer my question, but you broaden my mind about cross-subject modelling... After some investigation, here are some tips for future readers: You can only report on measures from multiple facts where all dimensions that are used in the analytic are shared. Subject areas should have Common Dimensions. Add…

Thanks for that Joel. The joins must exist for underlying physical tables? All the logical join will end up as physical join somehow as per my understanding.

Great workaround! Thanks

Thanks, Sorry I should explain more precisely. We explicitly want Male, Female and All Gender as display value in the prompts. the underlying value for gender column is male, female. How to we deal with All Gender option?

Thanks, Sorry I should explain more precisely. We explicitly want Male, Female and All Gender as display value in the prompts. the underlying value for gender column is male, female. How to we deal with All Gender option?

Thanks for looking into this. Thomas. We don't have a hierarchy for taxi level. I thought the logical dimensions will determine what aggregation level should apply. Is it possible to add over (partition by) in my case statement? RPD re-write my query to include BY [] clause, which is summary level aggregation?

I tried to use "CASE '@{P_Code1_Label}[@]{1}' WHEN '0,1' THEN 'Code 1' ELSE CONCAT('Priority ', '@{P_Code1_Label}[@]{1}') END". OBIEE treats this as a string rather than formula.

Thanks...Christian. I can unzip the first file now. however, my 256GB macbook run out of space. Each unzipped file is over 30GB...Sad. Now I have to use my Ubuntu machine, I downloaded the p7zip command line. I run "7z e SampleAppv506.zip.001" in terminal, it created a folder SampleAppv506p.zip; However, it throws an error…

any link to download 7zip for Mac? I tried, but couldn't find one.

Thanks a lot...I searched online, didn't for 7zip for Mac. Keka is the closest to 7zip in Mac world?

Thanks Joel, do we have use 7Zip? how about Mac Archive Unility?

Thanks Christian, I have renamed them to .zip. Still same error for the first file.