OneStream Community

db_pdx · 03-16-2023

Hi all: I would like to reference the Cube View name in a Business Rule as part of the Cube View structure. My current assessment is that this is not possible but thought I would check with the community to see if I've missed anything. The goal is to...

db_pdx · 12-03-2021

Hello: Looking for guidance on how to implement an enhanced conditional formatting check. It's quite simple, apply some formatting based on the account type. Consider the example of a single row CubeView with one account as the member filter: A#A8799...

db_pdx · 12-01-2021

Hi all: Looking for advice on how to implement multiple parameters in a report book. The standard loop functionality does not meet current needs. Our reporting requires a user to specify 3 UD's to report out their area of responsibility. Each user wi...

db_pdx

Hi Ranvir06: is this pulling a member by going down the hierarchy a certain level or up the hierarchy a certain level? As well, is the goal to simple display the parent based on the account you select (which I would recommend a custom member list for...

db_pdx

Two things come to mind: check that the entity is not inadvertently set to In Use = False for this scenario type. As well, check the Data Cell Access to see if there are any rules that would prevent you from entering data for this intersection (Appli...

db_pdx

Glad to hear you got it working. And good to know regarding column headers. One potential clarification for others if they read this thread.I went back through the Design and Reference Guide. At least per the print materials the single-colon is a Sta...

db_pdx

Hi ethanmgomes: I know there is a format for default values when loading from Excel files with NamedRanges, I wonder if it also works for the BR method?The format looks like: xfText#:[FieldHeader]::[DefaultValue]Maybe give that a shot and see if it w...

db_pdx · 08-31-2023

Hi Jones: are you using the Import, Validate, Load because you need to retransform the data? If not, it will likely be significantly easier to manage the data copy with a FinanceBR-CustomCalculate that does an api.Data.Calculate to copy data between ...

OneStream Community

User Statistics

User Activity

Referencing the Cube View Name in a BR as part of the Cube View Structure?

How to pass standard formatting conditionals to an XFBR rule?

How to run multiple parameters per Loop in a Report Book?

Re: Pulling level 2 parent while writing UD8 dynamic calc

Re: Read Only for a specific entity/scenario

Re: Hardcode value in column when loading CSV

Re: Hardcode value in column when loading CSV

Re: Move data between scenarios - Slice data files on UD in export job