Add repository/session/presentation/etc variables to DV workbooks

Marcelo Finkielsztein

This is both an idea and also a question:

1) (idea) please, add repo & presentation variables to DV workbooks. We have tons of filters (and dashboard prompts in our classical dashboards) that show up with a default value taken from an RPD session variable, e.g. : " Transaction Fiscal Year IS EQUAL TO/IS IN @{CurrenFiscalYear}"

2) (Question) I am experimenting with abandoning "classic" on behalf of DV, but I keep finding missing features. Is DV supposed to replace the classical analysis/dashboard pattern ?

THANKS,

Marcelo Finkielsztein

Alan Lee - Oracle-Oracle

There are plans for a capability similar to "classic" presentation variables in DV. However, please clarify your request. RPD variables can be referenced in a workbook using an expression like: Fiscal Year = Valueof(currentFY) where currentFY is a repository variable.

Marcelo Finkielsztein

Hello Alan,

Thank you!

I had not tried a filter expression using a Repository Variable. Now I have, and it worked.

I also tried to use a Session variable, but I could not find the proper syntax. Tried to use VALUEOF(NQ_SESSION."variablename") and @{NQ_SESSION.variablename} without luck.

I could not find references to this in the OAC DV documentation (Part III Visualize Data). Could you please point me in the right direction to find syntax?

Still wondering: is DV supposed to complete replace "classical" ?

THANKS!,

Marcelo

Alan Lee - Oracle-Oracle

Hi Marcelo,

Did you try VALUEOF(NQ_SESSION.variablename) ?

It is not the intent for DV to replace Classic BI. Many customers have made significant investments in developing Classic content and will want to continue to use. Certainly more capabilities will be added into DV with consideration of what is frequently used in Classic. However, there will be not be an attempt to match features exactly.

-Alan

Marcelo Finkielsztein

That worked. THANK YOU.

also thanks for the answer about "roadmap". very important!.

--marcelo

SiddharthDang-Oracle

You can also use presentation variables in DV. The workaround here is to create a canvas and embed it in a classic dashboard. then create prompts in classic and use them to pass values in DV projects.

The only limitation here is that you need to pass the filter in a custom column using the filter function.

Regards,

Siddharth Dang

Marcelo Finkielsztein

@SiddharthDang-Oracle ,

I appreciate the idea, thank you.

(TBH, this is the type of work-around I would prefer to avoid.)

Thanks Again,

?Marcelo

Michal Zima

@SiddharthDang-Oracle - just one question to you reply to Marcelo: You have mentioned, that passing presentation variables from dashboard prompts into DV canvas exposed on dashboard is working. My experience (I have tried it in OAS 5.9) is different - when you set presentation variable from dashboard prompt, DV project (or canvas) exposed on dashboard is not able to get the value of this presentation variable. Could you, pls, be more specific on your statement - where have you tested it, could you describe/send your test scenario ?

Thanks

Michal

SiddharthDang-Oracle

@Michal Zima After reading your comment, I went back to one DV/Classic dashboard combo that we created for one of our customers, and yes you are correct it is not working. We created this scenario in OAC 5.4. Although, post checking the query generated by OAC DV still understands the presentation variable context but we are not able to pass the values. The presentation prompt plugin is able to bridge that gap but has lot of limitations in DV.

Regards,

Siddharth Dang

SiddharthDang-Oracle

Example : FILTER(<my measure column name> USING <my dim> IN ('@{<variable name>}{2021}'))

Michal Zima

@SiddharthDang-Oracle . Ok, we went to same conclusion (unfortunately not good for us...).

I know, that you can set presentation variable using Presentation variable prompt plugin from Analytics library (https://www.oracle.com/business-analytics/data-visualization/extensions/) - but this plugin is really "child toy" , it is not for serious usage , it lacks functionality you have (in respect of presentation variable settings) in classical dashboard prompts. There are plenty of ideas created, calling for ability to set/declare presentation variable(s) from filters in Data Visualization - like for example mine: https://community.oracle.com/customerconnect/discussion/541171 , which is in Planned status, so I hope, this "gap" will be handled soon in DV.