Paramter for CR 2008 using the SAP
We have created a CR 2008 report where the users will want to drill down on the data for more details. When the users drill down on the data, they are running another SAP BW based CR 2008 report. We started out trying to access the data using the BW MDX driver, but we ran into two issues.
- We have created a BW query over the ODS table in BW, we have found that the hyperlink does not pass the BW variables to the hyperlink. We created a sub-report, instead of a hyperlink, and the report ran without any issues. But due to the report appearance, a hyperlink is the first choice.
- How can we add in a parameter field to the CR for the ODS table using the BOBJ SAP Operational Data Store (ODS) driver? Since we are connecting directly against the BW object, variables are not supported. We added in a parameter into the CR report, but the filter does not seen to work.
Any ideas if what we are trying to do is supported.