Thats great. it's proven one more time "picture tells 1000 words" !!

No need to read anything and try to work on database query to get your output data once you done let me know I'll guide next steps. BI cant get anything which is not related to existing fact table

what you tried!!

just in case verify your config with doc id 1350125.1 and 1928807.1

What are you using ? Administrator/Admin123 or else weblogic with given password

Col props->Column Format->Click on A at end of text field and then uncheck Wrap Text

Good to know. mark your self and close this post

Use this filter on date "Time"."Date" = max(rmax("Time"."Date")) if this is not working then use a column with exp max(rmax("Time"."Date")) with above filter

Its is not clear of what max date you want it!! is it from your warehouse or just in the report based on the criteria. You decide the logic to get the max date and create a report calling as A then on the current report filter on the date column and use report A.

Pivot table properties then select Fixed headers with scrolling content

Try with Admin123

Check this cool-bi.com

Just to do it and see how that works for you. for any issue share with more details.

Use Dashboard object Embedded Content, Link or Text with HTML markup etc also Narrative views

Check these doc ID 1475489.1

Helan, Its up to you. No one is forcing you to go with a specific solution. grab whats suites you, thats it!! Dont forget to mark on suggestion!!

I would say effort is more complex for this small requirement and waste of time to work on.

+1 ++ Thomas Dodds. If you want go your own then column->prop->data format->Custom then ####-##-##

Check in NQSconfig file. You need to work with WORK_DIRECTORY_PATHS

Customization on Charts !! I would say go with how it works.