OneStream Community

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 · 05-25-2023

Dear Community, Can we export a hierarchy/hierarchies into a relational table? For an instance if I want to export the complete hierarchy of any Dimension into a table view format whether it will be possible? I could see we have a Load/Extract to ext...

Nitishkrish16 · 05-24-2023

Dear Community, We have a requirement to make all the headers in report as well as in excel to make it bold and to increase the size. Here, I wrote a Business Rule function in Cube View Extender to make the change. But, I see it's getting reflected f...

Nitishkrish16 · 08-07-2023

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

Nitishkrish16 · 05-29-2023

Thank you so much for your response.  

Nitishkrish16 · 05-26-2023

Thank you so much! 

Nitishkrish16 · 05-25-2023

Thanks a lot for your response. 

Nitishkrish16 · 05-24-2023

Thanks a ton!!! This has been solved! Thanks again, good day to you! 

OneStream Community

User Statistics

User Activity

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?

Can we export a hierarchy/hierarchies into a table?

How can we make header as bold and increase the header size in both report & excel?

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

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

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

Re: Can we export a hierarchy/hierarchies into a table?

Re: How can we make header as bold and increase the header size in both report & excel?