OBIEE - Application URL in a variable

Question

Hi All,

I have a requirement to navigate to a different page in a same dashboard but be able to pass certain calculated column values.

Would like to use Navigate to web page option.  Now there are some columns which are common across both the pages.

Qn 1 - how to identify the application url and host in session variables ? This being test environment and would not prefer to hard code application url to be able to port between different environments.

Qn 2 - How to specify the common column parameters when building address? If I specify the calculated columns alone, it doesn't show up common columns in prompts even though prompt scope is set to dashboard.

Thanks in advance

[Deleted User] · Answer

User638087-Oracle wrote:1. Am using OBIEE 11.1.1.9

There have been 10 versions of "11.1.1.9" so "precise" would be "11.1.1.9.170718" for example. As an Oracle employee you should be more than aware of that.

User638087-Oracle wrote:2. The requirement I have is on first page -there is a summary table, this has a couple of dimensional attributes, and then counts falling in different ranges. (0-5, 6-10, 11-15.... ) The count calculation is based on certain groupings and my criteria has columns Dim Entity 1 and a case statement like "  SUM(case when Fact count between 0 and 5 then 1 else 0 end by <Dim Entity 2>) for a 0-5 range As you can see, there are 2 levels of grouping, first dim entity 1, and within that dim entity 2. I have dim entity 2 in criteria but that's excluded in table results. I tried to achieve this via RPD but didn't seem possible.

Not sure why this should not be possible. That's a normal degenerate dimension with fact-derived attributes.

User638087-Oracle wrote: On click of this count column, we need to drill down to the detail page and show records which cater for this range selection

"navigate", not "drill"

User638087-Oracle wrote:[...tl;dr...] Now 2 problems that I have here - I don't want to hard code application url or host and port - because it would be an issue when migrating environments. So would like to see if there is any space from

Why not put the URL / host / port / whatever into a static RPD variable and when moving from env to env simply run "datamodel.sh -cmd updaterpdvariables" on the RPD? That's what this functionality is there for.

User638087-Oracle wrote: My second problem - Am not aware how to pass dimensional attributes if using Navigation via web page.

With URL Parameters:

Integrating Oracle BI Presentation Services into Corporate Environments Using HTTP and JavaScript

User638087-Oracle · Answer

Hi Christian,

Hi Christian - Thanks for your reply. Please find my response below..

1. Am using OBIEE 11.1.1.9

2. The requirement I have is on first page -there is a summary table, this has a couple of dimensional attributes, and then counts falling in different ranges. (0-5, 6-10, 11-15.... )

The count calculation is based on certain groupings and my criteria has columns Dim Entity 1 and a case statement like "

SUM(case when Fact count  between 0 and 5 then 1 else 0 end by <Dim Entity 2>) for a 0-5 range

As you can see, there are 2 levels of grouping, first dim entity 1, and within that dim entity 2.   I have dim entity 2 in criteria but that's excluded in table results.

I tried to achieve this via RPD but didn't seem possible.

On click of this count column, we need to drill down to the detail page and show records which cater for this range selection and also the other dimensional attribute values.

Now if I change this to a pivot table, I can easily navigate to the detail page passing all filters as required. But the problem is Pivot will not show me the ranges for which there is no data.

Client insists that they need '0' to be displayed for all missing ranges.I tried to see if we can add via selection steps or so but no luck.  So I am going with table view and calculation for each range.

With the table view, I am not able to pass the range, the other dimensional attributes get passed though.

After trying all these possibilities - the only likely option to me seemed Navigation via webpage where I can hardcode the range to be passed.

Now 2 problems that I have here - I don't want to hard code application url or host and port - because it would be an issue when migrating environments. So would like to see if there is any space from which I can use this. One alternative I thought is I could store this in some database config table and read it from there.

My second problem - Am not aware how to pass dimensional attributes if using Navigation via web page.

Hope this clarifies my requirement. Am not sure if this is probably trying to do things in a bit of round about manner but don't see any options.

Thanks for your time and help on this.

[Deleted User] · Answer

Let's start with the basics:

1.) Which exact version?

2.) Why do you insist on using the "coding" path rather than using "Navigate to BI Content"? Just because of those "calculated columns"?

3.) If yes - what are you calculating that can't be done in the RPD which would allow you to use standard functionality?

As always: giving you a direct answer to your question will send you down a potentially wrong path since things can be done a lot more easy and direct