The OneStream Community is temporarily frozen until June 29th due to the ongoing maintenance. Please read the blog post here to learn more.
Forum Discussion
Solved
Variable Name in Bi VIewer
Hi All,
For a Bi Viewer Dashboard I use a Cube View which calculates values with a GetDataCell calculation. I display the values in a line chart. The values are displayed correctly, but the calcula...
If I understand correctly, you'd want those records to be marked "COGS %", is that right?
The easiest way to go about that is to create a Calculated Field in Bi Viewer, by right-clicking on the datasource name:
In the Expression Editor that comes up, you just enter the name you want, surrounded by single-quotes:
That will return the value 'My Name' in that field for all records. If you need more complex logic, you can implement it with a more complex expression, like IIF etc. For example, to replace an account name, you'd use Replace([Account], 'MyWrongAccount', 'COGS %')
JackLacava
OneStream Employee
OneStream EmployeeHey Colin,
could you post the CV calculation definition please? And are you using the CV Data Adapter or the CV MD one?
Hi Jack,
this is my CV calculation: GetDataCell(Divide((A#GP - A#Sales), A#Sales)):Name(COGS %)
And I´m using the CV MD Command Type.
- JackLacava
If I understand correctly, you'd want those records to be marked "COGS %", is that right?
The easiest way to go about that is to create a Calculated Field in Bi Viewer, by right-clicking on the datasource name:
In the Expression Editor that comes up, you just enter the name you want, surrounded by single-quotes:
That will return the value 'My Name' in that field for all records. If you need more complex logic, you can implement it with a more complex expression, like IIF etc. For example, to replace an account name, you'd use Replace([Account], 'MyWrongAccount', 'COGS %')
Yes the Replace function solved the problem, thank you Jack!
