OneStream Community

Sridhar_M

Hi everyone, We have a cube view with three rows structured as follows: Row1: E#Parent1.Children:U1#Member1 Row2: E#Parent1.Children:U1#Member2 Row3: Variance between two columns. To handle this, I created an XFBR that dynamically generates a string ...

Sridhar_M · 12-18-2023

Hi All, We are using FdxExecuteDataUnit to export data to SQL tables for consumption by downstream systems. Is it safe to run FDX queries while consolidation/Data Loads is in progress ? Regards Sridhar

Sridhar_M · 10-09-2023

Hi All, We are using XFGetCell's all the time in excel and one of the user reinstalled MS Office recently and he started facing issues XFGetCell. Please see screenshot below. XFGetCell function is defaulting to OneStreamExcelAddIn.XFFunctions.XFGetCe...

Sridhar_M · 09-29-2023

Hi All, We have 100's of Cube Views that have been created, and we're looking for a way to efficiently delete many of them. Is there a method to delete multiple cube views simultaneously through BR or any other simple approach? Thank you and apprecia...

Sridhar_M · 09-15-2023

Hi All, I create a spreadsheet business rule to refresh the data from external table using Table Views, now our users wants to drop these files into OneStream file share on daily basis so external systems can consume. Is it possible to use parcel ser...

Sridhar_M

Hi @TheJonG, I attempted your BR reference approach, but I'm running into the same issue we encountered with GetDataCell, since we need to use GetDataCell to reference BR.

Sridhar_M

Hi @TheJonG Here’s a screenshot of the Member filter for the text column, where UD8 is a dynamic member that retrieves the Entity group from the text property based on the Entity point of view. I already attempted to add a U8 Member to replicate the ...

Sridhar_M

Hi @TheJonG Thank you for the feedback. Below is a sample export of the cube view, and yes, I'm using V#Annotation to retrieve the string. The sections highlighted in green should display the same Entity Groups as in Actual and Forecast.

Sridhar_M

Hi @JackLacava Thank you for your response. Yes, I need to return a string, which is why I'm using row overrides to avoid passing the GetDataCell function that's being fetched from the XFBR.

Sridhar_M · 08-07-2024

Do we still need to use PowerShell to call DM Jobs in version 8.2.2, or has this process been simplified? Thanks Sridhar

OneStream Community

User Statistics

User Activity

Is it possible to return a string with CubeView GetDataCell Function

Is it safe to export data from cube using FDX queries (FdxExecuteDataUnit) during consolidation ?

Excel XFGetCell refresh is not working and data cells showing #NAME?

Is there any easy way to delete multiple cube views ?

Is it possible to use spreadsheet component (Table View in it) in the Book ?

Re: Is it possible to return a string with CubeView GetDataCell Function

Re: Is it possible to return a string with CubeView GetDataCell Function

Re: Is it possible to return a string with CubeView GetDataCell Function

Re: Is it possible to return a string with CubeView GetDataCell Function

Re: DM Job calling through API