OneStream Community

Kneelay

HI All, I'm running into an issue when running a Finance Business Rule, essentially this rule creates a data buffer and loops through where U8 member is not 0. From here we have a SQL statement where we're inserting these dimensions and the Business ...

Kneelay

Thanks Robb , I had to make a few edits, but this seemed to do the trick the first time. However, I refreshed a few times afterwards and the table count changed / deleted rows. Initially 112 was added which was expected. Then 112 again, but afterward...

Kneelay

'Create a databuffer for all combinations that would hold a value in U8#Alloc_Perc Dim SrcDataBuffer As DataBuffer = api.Data.GetDataBufferUsingFormula("FilterMembers(V#Periodic:I#None:O#Top:U5#None:U6#None:U7#None:U8#Allocation_perc:U3#Primary,[U1#C...

Kneelay

Posted below to my reply to Jack. For this particular case should be 112. It seems if it's less records it's doing it correctly.

Kneelay

Yes that's correct, I tried following what you showed but not sure if it's correct. Somehow I still see the 112 records being added to the error log. I created a test variable and was trying to see how many times it loops, seems like only 10, even th...

Kneelay

Thanks, I changed it to ExecuteSql instead. I'm trying to think of the best way to do this besides running the SQL query inside the loop, but having some issues with that.

OneStream Community

User Statistics

User Activity

SQL Table Insert Not adding all Records

Re: SQL Table Insert Not adding all Records

Re: SQL Table Insert Not adding all Records

Re: SQL Table Insert Not adding all Records

Re: SQL Table Insert Not adding all Records

Re: SQL Table Insert Not adding all Records