OneStream Community

Ashok · 02-10-2023

Hello All, Looking for a way to supress rows where there is 0s (drilldown has some +/- which nets to zeor for the row in CV). I have supression on and it works for the rows where there is no data and 0 as expcted. now in my below screnshot you can se...

Ashok · 02-06-2023

Hey Experts, I am trying to read the Datacelldetail line items. thought of using Method query but not able to filter it based on UD filter criteris. does anyone know if it is possible? whats the systax to make it work. In below example I am trying to...

Ashok · 02-02-2023

Hi Experts, i am trying to read the line items from celldetails. I think i get the sytax of BR functions it compiles fine but getting "Object reference not set to an instance of an object." error so something is wrong with script? I am able to read C...

Ashok · 01-31-2023

Hi All, I am facing an interesting issue (or a bug). Requirement: Capturing comments using a text box (linked with a literal parameter) and save it as annotation text so that it can be pulled in CV reports as well. Using literal parameter as I set it...

Ashok · 12-17-2021

Hi All, I have a requirement to open a web URL(it is a field in the table) in users default web browser. Current solution: I could do it using the "web content" component in the dashboard. I am capturing the field in a literal parameter and then usin...

Ashok · 03-20-2023

I am able to do it like below in a BR.Execute the Method query to get the data setCopy data set into a datable use the data table to read the rows Example code: Dim MyDataSet As DataSetUsing dbConnApp As DbConnInfo = BRApi.Database.CreateApplicationD...

Ashok · 02-10-2023

Tankhs will try. Will that suppress numbers below zero ?

Ashok · 02-10-2023

Row settings:Column settings: 

Ashok · 02-06-2023

Thanks Berry. my bad. even then it was giving all rows so tried to use the last field as below and it worked.{AUM}{E#RevAccComments}{RevAccRecon}{T#2022Q3}{}{}{}{}{}{}{}{}{}{}{}{UD4='DL014'}

Ashok · 02-03-2023

Here is the screenshot: user input cell details using this featureBelow screenshow the lineitems when you select "Celldetail" option. I am trying read this detail and add to the report. hopefully this helps understand the requirement.

OneStream Community

User Statistics

User Activity

Custom row suppression in a CV ?

DataCellDetail method query - how to filter on UD members

Line Items in DataCellDetail - using BR

Literal parameter : issue with unbalanced [ or ] in the text being input

How to open a web url in default browser using the BR

Re: Line Items in DataCellDetail - using BR

Re: Custom row suppression in a CV ?

Re: Custom row suppression in a CV ?

Re: DataCellDetail method query - how to filter on UD members

Re: Line Items in DataCellDetail - using BR