on 01-14-2013 3:00 AM
Dear Experts
I have a query with 2 hidden key figure fields and 1 unhidden key figure that is adding these 2 using a formula key figure.
I created a APD using this query for a routine. The issue is the APD ran but the Key figure result is all 0.
The routine source fields have been selected from the query except the 2 hidden fields which are quantitites and the APD shows units for these also.
But i did not select the units for the formula key figure.
This key figure is shown as field KYF_003 . I filled up the target field structure for the routine.
I am not sure what TYPE (infoobject) to use for this keyfigure kyf_003.
Also, in the query designer, should the Technical name in the General tab of this keyfigure be filled with a technical id?
The routine generated Type declarations shows the Source field KYF_003 is defined as type FLOAT.
How does the system know it is type float when the components for this formula key figure is of type quantity?
This formula is (Nodim(orecvalstck) + Abs(nodim(kf2)).
Thanks for reading.
Regards
Pascal
Hello SCN Experts
To make it simple, could you kindly confirm if APD allows use of Formulas in a Query for routines.
I tried, it does not seem to allow. I tried with restricted key figure was ok.
Thanks so miuch for reading.
Regards
Pascal
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
that is not normal.
Anything that requires a user input won't work, but all the rest should.
Have you checked the intermediate data after the query, so before the routine?
Also: hiding kfs for an apd does not make sense of course.
I always create separate queries which are as simple as possible.
User | Count |
---|---|
94 | |
11 | |
11 | |
10 | |
9 | |
7 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.