Skip to Content
0
Former Member
Feb 20, 2009 at 06:51 AM

Opendocument.jsp link throwing ora-01722 error

33 Views

Hi Mentors,

Can you please help me in resolving the drill down report issue created using opendocument.jsp.

Environment : BO XI R3.1 on Microsoft Windows Server 2003 R2 with service Pack 2

Universe Object Definition :Defined primary and foreign key for the object Product in Product dimension

I have created a Product summary report for an orders fact table and providing a drill down to detail report using opendocument.jsp as the volume of the data is more.

Please fidn the link used to invoke the drill down report.

http://<server>:<port>/OpenDocument/opendoc/openDocument.jsp?sPath=[ParentFolder],[sub Folder]&sDocName=Product Details&sRefresh=Y&lsSEnterProductName=Product4

The product filter in the query is not filter condition defined using @prompt rather created the filter condition at query panel and using prompt int eh filter definition.

The query translates as below :

SELECT

DIM_PRODUCT.PRODUCT_FULL_NAME,

DIM_PRODUCT.PRODUCT_LINE_DESC,

DIM_PRODUCT.PRODUCT_GROUP_DESC,

DIM_PRODUCT.PRODUCT_TYP_CD,

DIM_PRODUCT.INTL_CD,

DIM_PRODUCT.DOMESTIC_CD

FROM

DIM_PRODUCT

WHERE

DIM_PRODUCT.PRODUCT_KEY In @prompt('Enter Product Name:','A','Product\Product Name',Multi,Constrained_key,Persistent,,User:0,KEY_'N')

After selecting the product name the query is translated as below :

SELECT

DIM_PRODUCT.PRODUCT_FULL_NAME,

DIM_PRODUCT.PRODUCT_LINE_DESC,

DIM_PRODUCT.PRODUCT_GROUP_DESC,

DIM_PRODUCT.PRODUCT_TYP_CD,

DIM_PRODUCT.INTL_CD,

DIM_PRODUCT.DOMESTIC_CD

FROM

DIM_PRODUCT

WHERE

DIM_PRODUCT.PRODUCT_KEY In (7)

Can you please let me know how can I fix this issue ?

Thanks and Regards,

Shireen.