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