i wanted to use prequery option for SAP BW.
Based on FI-GL Line items I find assignment numbers (0ALLOC_NMBR; with the case i want to use it for these are purchasing document numbers); this prequery works fine.
However when i 'attach' this prequery to a cube with purchasing schedule lines I am not able to get data from this. I created the variable as a replacement path variable with the first query.
Anyone tried to do a thing like this?
Or hints how to achieve this?
I have thought about 'copying' the 0OI_EBELN characteristic to 0ALLOC_NMBR, but if that is the solution i will be at least disappointed :(.
Thanks in advance.