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.