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

Forum Posts

Update Dimensions using a rule

Hi all We have a process where we update dimensions and their children on a regular basis. This means we need to delete the relationships between parents and children and then reload the new updated dimensions...etc. This takes a very long time, beca...

Nou by New Contributor III
  • 29 Views
  • 1 replies
  • 0 kudos

Updating entity relationships through a Business Rule

Hi, How is it possible to update Entity Relationships through Business Rules, including Ownership Type, Percent Consolidation and Percent Ownership? It must be possible since the latest version of the Application Control Manager can also update entit...

StephaneS by New Contributor
  • 271 Views
  • 3 replies
  • 1 kudos

Create Metric Account from Specific SQL database pulls

Hello, I am trying to create a hierarchy for cubeview reporting that is based on a series of metrics that are extracted from the Journal Line Item application database table. The metric is based on one half of the JE, but it is only applicable if a s...

Tom_R by New Contributor II
  • 243 Views
  • 3 replies
  • 0 kudos

Identify New Member in Dimension

Is there any function or SQL to identify the newly added member in OS ? Ex - If I added an new account and I want to check whether the data was loaded to that new account ? Thanks

Kris by Contributor II
  • 238 Views
  • 2 replies
  • 0 kudos