Question:
Hi dear experts,
I'm quite having a problem with finding the specific field where the RKF's in the report are getting its data. The only technical name that it produces is ZPS_C04RK071. I can't make use of it to see which objects in the cube (0PS_C04) is related to it.
Hope to get responses from you!
Thanks and regards,
qt_cryst
Answer:
Right click - Edit - Look
?
Answer:
Hi Mr. Mod,
Well thanks for that sarcastic reply but I appreciate it anyways. I did it actually many times already and it hasn't gave me any good output. Oh well. Maybe my question is vague, I have to make it more precise, i think?
Thanks and still best regards,
qt_cryst
Answer:
Dear Mr qt_cryst,
first of all you should not consider me as "Mr mod", since I was replying as CHC, normal basic user like you.
Now, you gave us the info that your restricted key figure is a "z" one, which obviously means that nobody can give you the fields used in it, even if it's on a standard cube, without having a look in your system.
If we had access to your system, what we would do is "right click on the restricted key figure - edit - look".
And by "Look", I not only mean have a look at the useless technical name you gave us, but rather at the definition of your restricted key figure.
The panel you should reach when doing this should show you the name of the basic key figure considered, along with the characteristics considered for the restrictions, and the filters applied on it.
Now, if you knew everything this, then yes, you should have posted a more detailed explanation of your problem.
Ch
Answer:
Hi, qt_cryst,
First question : are you familiar with the query builder ?
This is not to be sarcastic, but this can only be done in the query builder, with some rights.
_________________
When my car stops, I first look at the gasoline's level before dismounting the engine.
Tuly Idiot's fan club active member.
Answer:
Dear Mr. qt_cryst,
Are you looking to the RKF definition in the Query Definition?
You can see the RKF on the Left HAnd Side, (Cube Definition of the BEx Screen.)
Key Figures --> Restricted KFs --> ZPS_C04RK071 --> rt click edit
Good Luck!