Oracle Communities

Oracle Analytics and AI

Child Item

Cast a ServerVariable as Date in Dashboard

Dimitris Karydis

Hi,

I am using a ServerVariable in my reports to present today's date.

When I call it in a report it works fine and uses the data type that the database column has:

------>

But I also want to call the variable in a section title in my dashboard. When I try to do this I get a different type, the one that oracle supports.

------------->

I checked through the session manager in the online RPD and the type for this variable is LONGVARCHAR giving back this TIMESTAMP string. This also creates some other issues when I link through reports.

I tried to change the default initializer to DATE but didn't help. I also tried to change the SQL in my initialization block and cast as date but again nothing happened.

Is there any way that I can cast this as DATE so I can just see the date and not the hour?

Thanks

Find more posts tagged with

Accepted answers

All comments

Joel Acha

Why don't you simple TO_DATE the column in your SELECT statement of your initialisation block for the curr_date_RT session variable? It's being treated as a string because it is a string and not a date

Dimitris Karydis

Yes I know it's a string (I don't know why though), so I am trying to figure out how to change it to a date format so it works in my dashboard.

I changed the select statement in the initialization block using the TO_DATE function but still when I test the value of the variable remains the same

Joel Acha

Is it listed as a DATETIME type when you check the session manager in the Admin Tool?

Dimitris Karydis

No, as I mentioned the type in the Session Manager is LONGVARCHAR. To clarify, this is a Dynamic Repository variable and not a Session one.

Joel Acha

Try something like:

'Today - '||CAST(CAST (VALUEOF(NQ_SESSION.curr_date_RT) AS DATE) AS CHAR(10))

Venkata Yaswanth Ramisetty

Hi,

Try this..

Create repositiory initialization block (SELECT TO_CHAR(SYSDATE,'DD-MM-YYYY') FROM DUAL;) and dynamic variable accordingly.

Hope this helps..!

Regards,

Yaswanth

Dimitris Karydis

None of these commands is being recognised in the Titles.

For a biServer variable (have to mention again my variable is not a Session one but a Repository one) tthe right syntax to call in a title is @{biServer.variables[‘variablename’]} and no other command can be combined with that (I tried cast and a lot other options, so this is an assumption, if you have found something that works I will be glad to let me know)

This is why I am trying to find a way to set this variable as date in the first place

Dimitris Karydis

Venkata Yaswanth Ramisetty I will try this, thanks

Joel Acha

For a repository variable:

'Today - '||CAST(VALUEOF("curr_date_RT") AS CHAR(10))

Dimitris Karydis

Joel Acha No, Unfortunately none of these commands that work fine in Answers seem to work in the Section titles