Skip to Content
0

TMVL Issue

Jan 31, 2017 at 06:38 PM

23

avatar image

Hi,

I am on BPC 10.1 standard without HANA on Netweaver platform. I have to aggregate sales from a certain back/previous date for 400+ products. The back date and the number of months to be used for sales aggregation will be defined by the user. I need to save both of these for traceability.

I was planning an input form to save the values for back_date as well as number of months for aggregation and then run a script logic to aggregate the numbers.

Back date entered by the users is in the form of the base members of the time dimension i.e., 2016.01, 2016.02 etc. NUmber of months to aggregate is in the form of integers i.e., 1,2,3,4...

The issue which I am facing is that TMVL does not seem to work with value stored in the cube, for example: TMVL(-1, [ACCOUNT].[BACK_DATE]) does not work. Can you please help me out with any suggestions? Due to the number of products,I cannot pass the back date from a DMP.

Regards,

Nicky

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Vadim Kalinin Jan 31, 2017 at 06:47 PM
0

Sorry, but why do you think that this strange syntax like "TMVL(-1, [ACCOUNT].[BACK_DATE])" will work???

Have you read help on TMVL: http://help.sap.com/saphelp_bpc10_nw/helpdata/en/c8/d961d0dbfd4745af4b667279573702/content.htm?frameset=/en/4c/2c4e6c97df1ca9e10000000a42189e/frameset.htm¤t_toc=/en/82/f51cf12cfc48c58975b9b5e6fba9aa/plain.htm&node_id=162

In general, please clearly describe your requirements - calculation logic using some data sample!

Please read: https://blogs.sap.com/2014/01/31/how-to-ask-questions-about-script-logic-issues/

Share
10 |10000 characters needed characters left characters exceeded