Analytics Software

Hi All,

Firstly apologies if the question has been asked before, however after some research I couldn't find anything.

I have created an OBI Answers report with a pivot table as its main view which I’d like to add the GO URL navigation on. The pivot table displays aggregate project data, where 1 row in the table could be made of multiple project numbers (in this example lets assume 4 projects).

When I add the below GO URL, instead 1 row being returned in the report, I get 4 rows with the individual project amounts split over the lines.

Saw.dll?Go&Path=/Shared/Sample/Report&Action=Navigate&P0=1&P1=eq&P2=Project.Project_Number&P3=Proj.Project_Num

Looking at the URL generated, it becomes clear that it is generating a new URL for each change of project. For example:

Saw.dll?Go&Path=/Shared/Sample/Report&Action=Navigate&P0=1&P1=eq&P2=Project.Project_Number&P3=12345
Saw.dll?Go&Path=/Shared/Sample/Report&Action=Navigate&P0=1&P1=eq&P2=Project.Project_Number&P3=54321
Saw.dll?Go&Path=/Shared/Sample/Report&Action=Navigate&P0=1&P1=eq&P2=Project.Project_Number&P3=67890
Saw.dll?Go&Path=/Shared/Sample/Report&Action=Navigate&P0=1&P1=eq&P2=Project.Project_Number&P3=09876

Ideally, I would like a single URL to be generated for this line, so that the pivot table displays a single row and not multiple rows. I believe the outcome I’m trying to achieve is the following URL generation:

Saw.dll?Go&Path=/Shared/Sample/Report&Action=Navigate&P0=1&P1=eq&P2=Project.Project_Number&P3=2+12345+54321+67890+09876

I've played with changing this syntax to the below, but the same project is passed into the URL 4 times instead.

Saw.dll?Go&Path=/Shared/Sample/Report&Action=Navigate&P0=1&P1=eq&P2=Project.Project_Number&P3=4+Proj.Project_Num+Proj.Project_Num+Proj.Project_Num+Proj.Project_Num

Does anyone have any ideas on how I can go about this?

Many thanks,

Lance

==============
OBIEE version 10.1.3.4.1