Rules
Discuss Formulas and Business rules for your application
cancel
Showing results for 
Search instead for 
Did you mean: 

Forum Posts

[howto] Use "Insert Code" when posting on Forum boards

Hey guys! Just a reminder: if you're going to post code in this forum, please make it easier to read by using the "Insert/Edit Code Sample" button on the expanded formatting toolbar. Here's a short video showing how it works. If you need to edit code...

tmp.png 1c_code.gif
JackLacava by Community Manager
  • 1376 Views
  • 6 replies
  • 3 kudos

"YTD" like calculation but for custom periods

I am writing a member formula/dynamic BR where i have to get 'YTD" like cumulative members but instead get it from month 7 onwards i.e. if i want to get cumulative data from month 7 onwards, i wrote a very rudimentary code to do this and it works but...

osdevadmin by New Contributor III
  • 150 Views
  • 3 replies
  • 0 kudos

Resolved! Rule Rules - ONLY write rules when necessary.

Rules TIP - ONLY write / use Rules when necessary. OneStream projects should not be a contest to see who is better at writing complex rules. If you must write rules please remember: Unless specified, the calculation will run on Base Entities AND each...

cbriscoe_0-1712315199764.png cbriscoe_1-1712315428947.png cbriscoe_2-1712315428955.png cbriscoe_3-1712315468773.png
cbriscoe by New Contributor III
  • 436 Views
  • 3 replies
  • 9 kudos

Allocation

A = 50% allocated to B , 40% to C, -90% to A What will be the best approach to allocate data between entities? Also, If you have a code snippet for data buffer that will be helpful. 1. Data Buffer 2. ADC

OS_Pizza_0-1712252155649.png
OS_Pizza by Contributor III
  • 179 Views
  • 4 replies
  • 0 kudos

Resolved! SQL Table Insert Not adding all Records

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 ...

Insert SQL.PNG
Kneelay by New Contributor II
  • 502 Views
  • 15 replies
  • 0 kudos

Why is there no "View" dimension in Data Buffer ?

Dear community, I am working on some Data Buffer and I noticed something : As you can see (if it's not too small ...), the Data Buffer is not taking into consideration the data units (that makes sense) and not the View dimension either. However, the ...

Sergey_0-1712151377714.png Sergey_5-1712153261891.jpeg
Sergey by Contributor III
  • 193 Views
  • 4 replies
  • 0 kudos