Dynamic Member Filter
A#Trade_Receivables_Net:Name(Accounts receivable, net of allowances for credit losses of $36 on April 30, 2022 and $107 on April 30, 2021)
I am hard-coding the line/name : Accounts re...
Forum Discussion
Hello,
There are two steps to pull the dollar values into the hardcoded name:
1) Create a form input for these amounts, if they are not already captured in OneStream. If these amounts already exist in the cube, move on to step two.
To create a form, start by creating a cube view of the intersection where you would like to enter this data. The intersection will have to be at the base member of all dimensions. The Origin member should be set to Forms. Ensure the Can Modify Data restriction on the Cube View Properties tab is set to True. When you run the cube view, your cells should have a white background, meaning they are editable. From here, you can enter the amounts directly into the cube view or set up a form template.
2) Add the intersection via an XFCell into the Name.
In your input cube view, right click on the cell that includes the number you would like to populate. Select Cell POV Information. Copy the XFCell reference (third option). In the cube view shown above (your presentation cube view), paste the XFCell reference in the section of the Name function that you would like to replace with the number. In the example above, you would take out "$36" and paste the XFCell reference. You can add variables into the XFCell reference so you don't have to change the time member every year.
I hope this helps!
Molly