Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

GO URL syntax

660366Feb 27 2009 — edited Feb 27 2009

Hi ,
I am trying to pass a parameter from parent to child report.....
the child column to which i am passing the value is a variable calculated using two table columns.....
Does Go Url passes values only to a table column and not to a variable.

This GO URL is working:

https://XXXX.com/analytics/saw.dll?Go&Path=/Shared/LDD_new/IndentedBOMChildLevels&Action=Navigate&p0=1&p1=eq&p2="-%20Nx_LNBBM_Current_Structured_Bills%20(LNBBM_BILL_OF_MATERIALS)".Item_Structure&p3=10&Options=rmf

in the above URL p2 = direct table column.if i replace this p2 with a variable it is not working....

https://XXXX.com/analytics/saw.dll?Go&Path=/Shared/LDD_new/IndentedBOMChildLevels&Action=Navigate&p0=1&p1=eq&p2_="*SUBSTRING("-%20Nx_LNBBM_Current_Structured_Bills%20(LNBBM_BILL_OF_MATERIALS)".Item_Structure%20FROM%201%20FOR%20(LOCATE('.',"-%20Nx_LNBBM_Current_Structured_Bills%20(LNBBM_BILL_OF_MATERIALS)".Item_Structure)-1))*"&p3=10&Options=rmf

waiting for reply....

Thanks
Raj

Locked Post

New comments cannot be posted to this locked post.

Locked on Mar 27 2009

Added on Feb 27 2009

#business-intelligence-applications, #business-intelligence-foundation, #business-intelligence-suite-enterprise-edition-obiee

2 comments

1,323 views