Page 1 of 1
TI prompts
Posted: Sat May 09, 2015 7:13 am
by late.vaibhav
Hi
I have created a Ti to load data from SAP with package connector in 9.5 version.
in that to minimize time and data load i have use filtering for month and year by using prompts in framework manager.
now i want that the prompts should be picked up from any cube or dynamic ti process so that i can schedule this ti. and there would be no need to change the prompt value every month.
So please suggest me the solution or alternative to do achieve this....
Re: TI prompts
Posted: Sat May 09, 2015 9:42 am
by lotsaram
late.vaibhav wrote:Hi
I have created a Ti to load data from SAP with package connector in 9.5 version.
in that to minimize time and data load i have use filtering for month and year by using prompts in framework manager.
now i want that the prompts should be picked up from any cube or dynamic ti process so that i can schedule this ti. and there would be no need to change the prompt value every month.
So please suggest me the solution or alternative to do achieve this....
That's the problem with using FM packages. The last time I looked into this the only acceptable solution we could find was to define variables
within SAP BW named for example Current Year, Last Year, Current Month, Last Month. We then used these variables within the FM package. It meant something extra to maintain in SAP but at least it was then possible to automate loads to TM1 with a time filter in the query.
Re: TI prompts
Posted: Tue May 12, 2015 12:18 pm
by Michel Zijlema
late.vaibhav wrote:Hi
I have created a Ti to load data from SAP with package connector in 9.5 version.
in that to minimize time and data load i have use filtering for month and year by using prompts in framework manager.
now i want that the prompts should be picked up from any cube or dynamic ti process so that i can schedule this ti. and there would be no need to change the prompt value every month.
So please suggest me the solution or alternative to do achieve this....
Could the CGAddPromptValues function be what you're looking for? See
this link, item
14. Prompt Editing.
I used this some time back to assign prompt values dynamically in TI (on the Prolog tab) using the package connector and that what working for me (but the package connector itself was not stable enough to be used in the end).
Michel