Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture
Comments
-
Thank you Arijit! We are testing on a similar solution. Created a database function where the timestamp is converted to correct date using cast .. at time zone . .as date. Use evaluate to call the function. Seems to be working so far. Thanks, Morten
-
Yes, all column values are blanked when I set None. No aggregation in rpd, and column is mapped (tried with expression as well, same thing happens).
-
Thanks choracy69, Agree, this should do the trick, but if I do this, then no values are retrieved for some reason. It blanks the entire column. Morten
-
Thanks, I guess I would then need to use Conditional Formatting on FACT Sales Average. How would I identify which cell is the totals row in Conditional Formatting? I still want to see the value for FACT Sales Average for the rows 1 and 2. Morten
-
Thanks for the feedback Thomas! Realized that I`m going to have a hard time getting this layout in BICS - Answers. If I had the choice, I would use BI Publisher.
-
Thanks guys, this works perfectly! Thanks, Morten