OneStream Community

vcirigiri

Whats the Table name where all the Dimensions are stored ? I need to generate/Automate a report which will give me a list of all Dimensions setup in our system. I can do it using the Extract process...

Ashok · ‎02-02-2023

Hi Experts, i am trying to read the line items from celldetails. I think i get the sytax of BR functions it compiles fine but getting "Object reference not set to an instance of an object." e...

AndreaF

Hi, I am trying to use the XFGetHierarchyProperty Spreadsheet function to return the "Parent member name" property of a member. I tested the function by returning the HasChildren pr...

DamarisE

I am working with a client the requires the first row of each section of their reports to have a dollar sign. No other rows in the section (outside of the total) need a dollar sign. The c...

Jared

Hello All, I am trying to create a cube view or report if necessary to list our active Entities. I've been able to filter by "In Use", but we also need to include the Member Property o...

NidhiMangtani

Hi All, Has anyone built a custom audit data report for their OneStream planning applications which shows which users changed which entities/accounts/scenarios, etc on specific days? Not sure if we...

sdayringer

Hello, How can I call an account's assigned plug account via SQL? I able to get the PlugAcct DecimalValue, but need help with the syntax to return the account member name instead of the ID... SELEC...

sahilp

Hi everyone, do you know if the report run time and page number that is in the cube view report footer can be moved into the report header? I was thinking perhaps via a cube view inline formula?

Sudhakar · ‎02-24-2023

Hi Team, We have a requirement to generate Level 1 member list (Department Member List) based on POV (Entity Dimension) selected so we have developed XFBR script to generate the Level 1 Member List....

MarkusWipp · ‎02-21-2023

Hi all, I'm looking for a possibility to dynamically create a Cell Format via an XFBR Rule. Unfortunately it doesn't seem to work, but also does not give an error message. Could someone please...

OneStream Community

Table Name where Dimension are stored

Line Items in DataCellDetail - using BR

Return the parent member using XFGetHierarchyProperty function

Leading Row Formatting

Create a Cubeview Entity List From "In Use" and Member Property "ReadWriteDataGroup"

Cube Data Audit Report

Extract Account's Assigned Plug Account via SQL

Report Page Number and Time

Generate Level 1 and Level 2 Members on Fly in Cubeview

Using XFBR in CubeView for Cell Format