Skip to Content
0
Jul 03, 2009 at 11:20 AM

Data validation check before generating

33 Views

Hi,

Before using the generate new combination planning funciton, I want to do the data validation (validation table is stored in BI) firstly. I came up with the following idea.

1. create a planning funciton with formular type, but becasue this new comination does not exist in the plan cube, it seems foreach will return zero record, which means this formular planning function read 0 record, so I can not do the operation here.

I checked there are other foreach, such as Foreach COUNTRY in Selection, Foreach COUNTRY in Variable. I tried, but still not working.

Can anyone confirm that formular planning funciton can do this kind of check? and how to use Foreach COUNTRY in Selection?

2. if the above can not do this, I need to check the data in workbook. Does any know how to call the function module in BI system within workbook?

or is there any solution for this requirement?

Many Thanks

Jonathan