Dear All,
I have some problem about foreach statement. I have 5 records in info cube
First record => version = 0 value type = 10 fiscal period = 009.2006 calendar year = 0000 key figure = 5
second record => version = 0 value type = 10 fiscal period = 009.2006 calendar year = 2006 key figure = -5
third record => version = 0 value type = 10 fiscal period = 009.2006 calendar year = 2006 key figure = -5
forth record => version = 0 value type = 10 fiscal period = 009.2006 calendar year = 0000 key figure = 5
fifth record => version = 0 value type = 10 fiscal period = 009.2006 calendar year = 0000 key figure = 5
so l want to repost the first,forth and fifth record to version = 0 value type = 10 fiscal period = 009.2006 calendar year = 2006 key figure = 5
when i use foreach in FOX to repost data by call function convert fiscal period to calendar year, it has only 3 records like this.
First record => version = 0 value type = 10 fiscal period = 009.2006 calendar year = 2006 key figure = 5
second record => version = 0 value type = 10 fiscal period = 009.2006 calendar year = 2006 key figure = -5
third record => version = 0 value type = 10 fiscal period = 009.2006 calendar year = 2006 key figure = -5
but i want on 5 records
First record => version = 0 value type = 10 fiscal period = 009.2006 calendar year = 2006 key figure = 5
second record => version = 0 value type = 10 fiscal period = 009.2006 calendar year = 2006 key figure = -5
third record => version = 0 value type = 10 fiscal period = 009.2006 calendar year = 2006 key figure = -5
forth record => version = 0 value type = 10 fiscal period = 009.2006 calendar year = 2006 key figure = 5
fifth record => version = 0 value type = 10 fiscal period = 009.2006 calendar year = 2006 key figure = 5
how can i configured in this error???
thanks for your help,
Joy