Workbook Variables and Variable Interpolation in Text Boxes and Expressions

Richard A. Wells

Hi all. I'm new to the platform and working in DV, but not (at all :-) new to programming. It seems to me there should be a concept of a workbook variable and the ability to use its value in contexts like string interpolation in a Text Box or within a Calculation's expression. Ideally, they also could be initialized using a SQL expression.

I've seen reference to Session variables from the Analytics side, so my guess is this is a variation of this concept, so perhaps something like this is already on the DV roadmap.

Is there something like this in the system and I'm just missing it? On the roadmap? Or is this missing from both and others also would find this valuable?

-- Richard

Gabby Rubin-Oracle

Look here; I think it might be what you are looking for. https://docs.oracle.com/en/cloud/paas/analytics-cloud/acubi/syntax-referencing-parameters.html#GUID-9082BCD7-B19D-4A3E-B2D7-12452272BF32

It does not currently support Textbox, but you can use it in property strings (e.g., chart titles, axis titles) and expressions.

Richard A. Wells

Thanks, Gabby. I will take a look at Parameter values.

Meta question to the Community: I got a notification that "Voting for this idea is closed." Why is that, when "Variable Interpolation in Text Boxes" is right in the title and Gabby agreed "It does not currenly support Textbox." Do I need to submit a more finely-tuned idea calling out only that element of the idea?

Gabby Rubin-Oracle

Voting is now reopen

Richard A. Wells

Oh, great, thank you!

And I've figured out that as a workaround/hack I can use the Title of a Tile viz without data to display interpolated @parameter() values.

An upvote on this idea should be considered an upvote for supporting @parameter() references in a Text Box.

Richard A. Wells

^Also important here is to turn off ALL filtering props on the Tile viz.