Hello,
we just testing TM1 951for planning purposes and we try to load hierachys and data from SAP BW 7.0 via sap querys. We are using the "new" IBM interface and not syskoplan,
We have a lot of problems e.g.
elements of a hierachy gone lost
it takes more than 45 minutes to load a hierachy with 6 level and 15000 elements
no data reaching TM1
Does anyone have some experiences with this interface. Do you have suggestions for the design of the sap query or anything else?
Thanks in advance
Renee
The MDX generated for hierarchy extractions can be very slow for large dimensions if the NULL suppression option for SAP BW is turned on.
In Framework Manager, go to "Edit Governors" and uncheck the SAP BW null suppression option and republish your package.
Hierarchy extraction should now be much faster.
The recommended way to set up your TI processes is to create one process to do all of your dimension/hierarchy extraction, and another to do the fact extraction.
For fact extraction, define an Info Query with just the dimensions and key figures you want to extract. Define a restriction as documented on a variable that will be used to segment the data extraction. Pick one that will chunk up the data reasonably evenly; I recommend into < 1000 pieces.
Create a TI process and for each dimension in the fact query, select the dimension you already built in TM1 and choose "As Is" as the action. Select all the key figures. Click "Prompts" and select your SAP BW variable for segmenting.
Let me know if you have any further questions, or contact support.
For more performance, define the SegmenterParallelQueryCount option in the preferences as documented.