OneStream Community

Nitishkrish16 · 01-23-2024

Hey folks, We have a requirement to define range of rows in a GetDataCell. For example: GetDataCell(CVR(Row1) + CVR(Row2) + CVR(Row3)..... CVR(Row100))Instead of defining it manually till Row100, Is there any way to give a range like this GetDataCell...

Nitishkrish16 · 01-22-2024

Hey folks, Just wondering if we can automate IIS reset in the task scheduler. I don't see any Snippets or related BRApis in the Extensibility Business Rules. Surfed through various Community posts but, didn't help much. Any guidance here will be help...

Nitishkrish16 · 08-25-2023

Dear community, I'm using a getdatacell formula to sum few range of rows. The formula is correct and I'm getting the correct/desired output in the data explorer. But, when I try rendering it in the report and excel. It throws an error with "#ERROR'ro...

Nitishkrish16 · 08-04-2023

Dear Community, We have a requirement to calculate the sums of two rows total for every month we run. We have a time parameter that is helping us to select the desired month. We used GetDataCell formula to calculate it for the particular month.for an...

Nitishkrish16 · 05-26-2023

Dear Community, In the above image "Results Table Name" located in the Data Adapter for a SQL Query is accessible? The Data Adapter still runs even though if we aren't giving any table name in the alias. Is it only for the naming convention? Or wheth...

Nitishkrish16 · 01-24-2024

Hi Paul, Thanks a ton for your input. This is what exactly I have been looking for. I hope XFBR rule can solve this. Also, creating an alternate hierarchy would be much more easier way of dealing with this. Thanks a lot for your insights in this. 

Nitishkrish16 · 01-24-2024

Hi @BenThompson , This is such an amazing idea!! But, few accounts used here are dynamic. So it would create complexities if the alternate hierarchy is created. Thanks a lot for your input 

Nitishkrish16 · 01-23-2024

Hi @rchaturvedi27 , As of my knowledge we don't have any options to hide/delete the deprecated option from the workflow profile.You can also post this enhancement request in IdeaStream. This community post might help you to understand better. https:/...

Nitishkrish16 · 01-22-2024

Thank you Marcus   

Nitishkrish16 · 08-07-2023

Thanks a lot  Wrote a XFBR rule and it worked!! 

OneStream Community

User Statistics

User Activity

Can we define a column/row range in a GetDataCell?

Automation for IIS Reset

Values are correct in Data Explorer and throwing error in report and excel.

How can we make the calculation dynamic upon selecting the months in a parameter?

Is the "Result Table Name" in the Data Adapter while running a SQL query accessible?

Re: Can we define a column/row range in a GetDataCell?

Re: Can we define a column/row range in a GetDataCell?

Re: How to remove " Deprecated " Option from my workflow profile?

Re: Automation for IIS Reset

Re: How can we make the calculation dynamic upon selecting the months in a parameter?