I am currently using TM1 with Package Connector module to access SAP BW data.
I already managed to gather data to populate my cubes, but I am facing an issue to define drill-through processes (also using Package Connector).
When defining a drill process, just "ODBC", "Cube View" and "Other" are available : I tried "Other".
Then, when opening the Drill Process directly ("}Drill_..."), I can modify it : I change the datasource type to "Cognos Package", then define normally my query and finally add a "ReturnSqlTableHandle" in the Epilog. But now, impossible to "Save", only "Save As" is possible.
Then I tried to workaround this by stopping the service, renaming the files .pro to the correct name ("}Drill_...") and restart the service.
I get the following error message :
CCognosProxy::Connect C8Error: (TR0317) Invalid or missing parameter to command 'C8_REQUEST_TYPE_OPEN_MODEL'.
Error: Prolog procedure line (0): Unable to open data source "SAP BW Sources - Cost Analysis - Purchasing".CCognosProxy::Connect C8Error: (TR0317) Invalid or missing parameter to command 'C8_REQUEST_TYPE_OPEN_MODEL'.
I hope my explanation is clear enough ... and that someone already managed to find a workaround for this.
Thanks a lot.