Skip to Content
Feb 20, 2019 at 09:22 PM

Analysis for Office 2.7 File Upload doesn't allow to fix or pass dynamic values

402 Views Last edit Feb 28, 2019 at 01:30 PM 3 rev


When loading a flat file using planning function type - "File Upload from AO" and calling it via AO 2.7, I need to fix the value for a specific dimension member and for some pass a dynamic value using input variables from the user, but there is no way to do that currently.

If I mention the fixed values or variables in the RSPLAN filter it still doesn't consider it. The only way to do it is to mention it in the flat file only.

In our case there are a lot of dimensions which are of no relevance to the user and so we do not wish to mention that in the flat file, also the same file needs to be loaded to different 0CALMONTH (e.g.), then there is no provision to pass it as a variable selection.

Please let me know how we can achieve this using the standard planning function and if I am doing something wrong here.

A quick help shall be really appreciated.