Skip to Content

query designer rri (drill down) currency translation

Oct 18, 2017 at 01:25 PM


avatar image

Hi Experts,

(SAP BW 7.5 Query Designer RRI from Analysis for Office)

I am having a source query and a target query. In the source query I have put a variable in the key figure tab "conversion" (picture 1). The source query can be executed without problem. So far so good.

When I try to run a go-to report, RRI, I can't pass the value from variable ZTARGET_CURRENCY. I have tried the most available settings and really like to get som input.

When RRI is called it collects the following information from the cell of the sender query before passing it to the receiver as selections:

  1. The global filter: the lines and columns of the query definition;
  2. the dynamic filter: Thes are the values in the navigation block of the query (filter that can be changed by navigation), including the hierarchies;
  3. Filters from the selected, restricted key figure;
  4. In formulas, only the selections that are identical in all operands are passed

As per my understanding my variable (pic-1.png) is not a part of the above (1-4).

My question is: How to send values from variable ZCURRENCY_TARGET to the receiver query? Is it possible or not?

pic-1.png (155.7 kB)
10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

0 Answers