Cast a ServerVariable as Date in Dashboard

Dimitris Karydis

Venkata Yaswanth Ramisetty Yes, as a custom solution this will work. I will have a character though but not a date. If there is no possible way to cast as Date the current one, I will have to create a new one as a character as you mentioned. Thanks for that

Ideally I woudn't want to change this variable's type as I use it in my reports too

Joel

Understood - use a Narrative view and format the text accordingly:

Dimitris Karydis

I am aware of all these features, my problem is specifically for a SECTION TITLE in my Dashboard and for there only. This is the only place in the Dashboard that I haven't found a solution for.

Joel

Not sure you can reference a variable in a dashboard section title it appears. You can simulate the Section Title dependent on how your dashboard has been formatted. You could do something similar below displaying the narrative view as the "section title" with formatting of the section to align the text to the left etc.

To give you something like this:

Dimitris Karydis

You can call the variable in a section title, check the screenshots in my first post. The problem is that you cannot manipulate it in any way so this is why I wanted to find a way to initially change its type.

I have found some references online mentioning "The repository variable doesn't support the date datatype from Oracle. Oracle has one date datatype and it's the timestamp datatype of OBIEE. It means that you have always the hour, minute and second." but I don't want to accept it tbh.