Skip to Content
0
May 11, 2008 at 09:13 AM

BW workbook (RRI) and dynamic columns

35 Views

Hi Gurus

1. I have two queries, Q1 has to pass values to the Q2 by using RRI in a workbook. I was able to jump from one workbook to another with the help of VB code but i also need to pass the values for a variable in the receiver query.

2. In my receiver workbook i have one column which has formula, below is the example.

Material group Day of month Plant1 Plant 2 Total Order Acc order (Formula)

Matgroup1 1 2000 3000 5000 Total order + Acc Order = 5000

Matgroup1 2 1000 3000 4000 Total order + Acc Order = 9000

Matgroup1 3 2000 1000 4000 Total order + Acc Order = 13000

.

.

.

.

Matgroup1 30 2000 2000 4000 Total order + Acc Order = 17000

Matgroup1 31 2000 5000 7000 Total order + Acc Order = 24000

The last column has formula and when i Jump from one workbook to another the last column should act dynamically since some months will only have from Day 1 to Day 30 and others will have Day 1 to Day 31 you know how its in Feb.

So the problem is when i jump from one workbook to another query (workbook) some months only has 30 days and hence the 31st day is also calculating by the results. So i need the last column be dynamic. Please let me know ASAP how to solve this problem.

Thanks in advance

Rahul