Hi all,
I have read in this link :http://oraclebizint.wordpress.com/2008/02/17/oracle-bi-ee-101332-drilling-on-measures-passing-multiple-parameters-during-drills-go-url-and-html-formatting/
about how to pass parameter using URL.
But I confuse with this syntax:
*’<a href=http://localhost:9704/analytics/saw.dll?GO&path=/shared/Dynamic%20GO%20URL/Report2&Action=*
Navigate&P0=2&P1=eq&P2=Geography.Region&P3=’||Geography.Region||’&P4=eq&P5=Geography.Country&P6=’||Geography.Country||
*’ style=”text-decoration:none;”>’||CAST(Sales.Amount_Sold AS CHAR)||’</a>’*
In the example from link, they want to pass the parameter from region and country when clicking cost.
The structure is like this:
DIM-REGION DIM-COUNTRY FACT-COST
what I don't understand when tried to apply on my own analysis, how If I have analysis like this:
DIM_PERIOD DIM_ORGANIZATION DIM_CONDITION FACT_ABSENCE_COUNT
If I just want to pass parameter DIM_CONDITION when clicking FACT_ABSENCE_COUNT, what I must do to create the html syntax like above?
what is P1,P2,P4,P5?is that sequence mandatory?
Any Help will be appreciated
Regards
JOE