OneStream Community

MarioGV

hi Team; I've a cube view showing accounts than need to highligh in red when overlap a number dependig the FxRate, I created an Finance BRule searching for a specific rate and multiply be a number where is more than this is highlighted in red. My pro...

MarioGV · 03-14-2024

hello, good day; I created a new finance rule calculating the cash flow accounts using as source the balance sheet accounts, the hierarchy is not part of the balance sheet, it's at the same level; when I consolidate or translate the cash flow account...

MarioGV · 02-20-2024

Hi everyone; we have an application using standard elimination, we have been used eliminations between balance account and P&L accounts, I created a new account in Balance sheet accounts with plug account as Assets, create another P&L account (Revenu...

MarioGV · 05-18-2023

hello Team; I was using Reporting Studio for a 6.X version, now our environment was upgraded and download the client version (7.3.3) the Reporting studio is not in the package, I searched in OnePlace for the software but can't find it; does anyone kn...

MarioGV · 04-27-2023

Hello; Im crating a cube view with 2 rows (maybe more) that one of them is a result of a complex function: "A#INCOME_STATEMENT.Base.Where(Text1 Startswith On-Campus)" and shows several rows qualified as Text1, now I want to sum those Accounts but don...

MarioGV

I created an XFBR using the funcion GetLiteralParamenterValue and the way to call the function in a cube view is: If (CellAmount > XFBR(LCI_XFBR_GetParam, GetVarianceValue)) or (CellAmount < -XFBR(LCI_XFBR_GetParam, GetVarianceValue)) Then Background...

MarioGV · 05-06-2024

Hi Ritesh; this XFBR is on the sample app GolfStream, but have a little issue that is not working properly; so I modified and use it for sorting the expenses, it also run for max, min, X tops; I hope this lines could help you: In the cube view, the r...

MarioGV · 08-11-2023

Do anyone knows if it is possible to do it on Cloud app?RegardsMario

MarioGV · 06-07-2023

Hi Koemets; could you please share the XFBR rule? I've the same issue but don't know the brapi to select the amount and sort it.Kind regards.Mario GV

MarioGV · 05-18-2023

thank Jack for your quick respnse; I'll review the Dashboards and Report Designer.Have a great day.Mario

OneStream Community

User Statistics

User Activity

cell format in CV using parameter

when consolidate and translate all CF were deleted

Eliminations between Balance & P&L accounts

Reporting studio on new versions

Cube view using complex function Account

Re: cell format in CV using parameter

Re: sort by ascending order of values NR in column B in Cubeview?

Re: Would like to reduce the amount of times they have to log into the Excel Add-In. Where does this

Re: sort by ascending order of values NR in column B in Cubeview?

Re: Reporting studio on new versions