OneStream Community

cbriscoe

Given a situation, determine the correct properties for the Cube. Certification Exam. Workflow The most common setting Is Top Level Cube for Workflow (Main Cube) = True Project requirements dictate Suffixes for varying Workflow by Scenario Type Assig...

cbriscoe · 04-05-2024

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 · 03-17-2024

Api.Data.Calculate(“A#28100=A#69000”) What is wrong with writing a calculation like this? Tips. A#28100 might contain thousands of cells. Calculation MAY work but will damage performance. Defining more dimensions reduces the number of cells that need...

cbriscoe · 03-03-2024

 OneStream consultants and administrators must make the correct decisions during the design phase of YOUR project. Top on the list: Deciding which one (Dynamic or stored Calculations) to use is a fundamental consideration of a project. Dynamic Calcu...

cbriscoe · 08-07-2023

Report Books LOOPS - A Loop is a sequence of instructions that will continually run a process as many times as is defined in the Loop Definition. For example, a book can be set up to loop through all the base entities under a particular hierarchy and...

cbriscoe

HI Satish P You can delete users and groups using Extender rules. Try this rule below. Have fun :). Imports System Imports System.Data Imports System.Data.Common Imports System.IO Imports System.Collections.Generic Imports System.Globalization Import...

cbriscoe

Hi Krishna. We can also delete users and groups using Extender rules. 

cbriscoe

Hi Joris, can you give us more information on what you are trying to achieve here? These settings work very well. Thanks

cbriscoe

Daniel, Please review the following information. =XFGetMemberProperty(“DimTypeName”,“MemberName or Script”,“PropertyName”, “VaryByCubeTypeName”,“VaryByScenarioTypeName”,“VaryByTimeName”). =XFGetMemberProperty("Time","2015M8","ShortDescription","","",...

cbriscoe

I would remove the relationship, drop the data from the member, and then delete the member. We have several small ways around this problem. You can also create a data manager sequence step to delete the data from respective members.

OneStream Community

User Statistics

User Activity

Cube Properties Best Practices!

Rule Rules - ONLY write rules when necessary.

VB.NET Rules - For Better Performance

Performance Decisions - Dynamic Vs. Stored Calculations

Report Books - Loop, NOT Excel TABs and or Spread sheets!

Re: Is there a way to remove set of users from groups via xml(Load/Extract oprtion)

Re: Is there a way to remove set of users from groups via xml(Load/Extract oprtion)

Re: No suppression options after processing Cube

Re: Filter accounts by Plug Account

Re: Accidentally copied a member and pasted to a new section of the account tree