OneStream Community

prash4030

hi Experts, i've a member formula (stored calc) to calculate %. My scenario type is periodic. i'm calculating % for various P&L accounts. M1,M2 and M3 %s is correct but for quarter, system is adding M1%, m2% and m3% which is not right. i want to writ...

prash4030 · 02-06-2024

Hello, We've a requirement where based on certain condition, data source record needs to go to two or more targets. For example, we've expense amount in source data that needs to be go to different SG&A Category (like R&D, Marketing, etc) based on pe...

prash4030 · 07-06-2023

Hello,Is it possible to refresh XFGETCELL (excel report) automatically through OneStream and save report as offline? i was trying to achieve this by uploading excel report as .xfdoc.xlsx but i want the output as paste special values. thank you

prash4030 · 02-09-2024

yes, i was able to understand this concept. thanks a lot!

prash4030 · 09-24-2023

Hi Eric,In our implementation, Actuals scenario type and No Data Zero View For Adjustments both are YTD. if i change No Data Zero View For Adjustments to periodic, will this have any impact on historical JVs or any other impact actuals (which we will...

prash4030 · 07-13-2023

hi, thanks for your reply. Yes, we've used cube views in extensible document but i'm specifically trying XFGETCELL to work.

prash4030 · 07-13-2023

Double check your SQL connection string. may be there is any syntax error.

OneStream Community

User Statistics

User Activity

Monthly and Quarterly percentage

Transformation rule

Refresh XFGETCELL excel sheet

Re: Transformation rule

Re: Recurring Journals

Re: Refresh XFGETCELL excel sheet

Re: Create View using Extender rule