Reporting

Hi, Is there a way to set up dependant parameters, ie. Paramater value that depend on another parameter?The idea is that the user select a value  among a list in parameter A (which is not a dimension element), then the list in parameter B will be filtered based on what has been selected in Parameter A ( not dimension elements as well). Regards,

I'm working on a cube view that does a variance analysis between 2 difference scenarios. The scenarios will always vary based on the scenario member selected by the user. Some of the rows use the formula "GetDataCell" or a dynamic calc in the member filter. I've found that if I use GetDataCell then Col 4 does not calculate the variance correctly. I started using dynamic calcs to work around this issue. Unfortunately, I have also experienced this issue using dynamic calcs as well. Has anyone else had this issue and what were some of the things they did to resolve this?   My columns are setup like so: Col 1                     Col 2                   Col 3                           Col 4                           Scenario#1    &nbsp

Dear community, Using the SQL table editor, it is possible to define the "allowupdates" as true for each column. Right now I have a requirement which is to have a cell with a column which should be editable depending on another row: on a specific row, if column 2 is set as "true", then column 3 should be editable.   What would be the most apprioriate way to achieve that ?   Regards,

Hi,Does anybody know what is the "ColumnDisplayType" parameter under the Column Format, part of the SQL Table Editor ?I am keen to know how to use it, as I can't find any information on this.Screenshot of the mentioned field below : Regards, 

Hello,I would like to know if it is possible to format only one word or part of a word in a dashboard label :- How can we make only one word in bold in a label, and not just the complete sentence ?- Could we use conditional formating in order to format only a specific word (for instance, a user login) ? Many thanks,

Hi all, EDIT : I was able to sort this out with some more SQL 🙂I wanted to confirm one point regarding data adapter using SQL statement.Right now, I am using a data adapter with SQL command type, which is using a "join" statement to 2 other tables. When I test this data adapter, it is working as expected and I can see the columns coming from the other tables.However, when I use this data adapter in a Grid View components, then the columns that are supposed to be from the joined tables do not appear. Are there any SQL restrictions when it comes to using SQL commande data adapter in gris view components ? Many thanks,

Wondering if anyone has encountered the issue? It's a simple PDF report book with straight forward column set, but there are slight misalignments between numbers. Ideally, looking for right side justification. Thank you

Dear community,   EDIT: seems like the column name "SEL" was messing up the behiavor of the column. I changed it to another specific column name and now the drop-down list saves saved & reported accordingly.   I am using a SQL table editor in order for a user to provide some informations. In one of the columns, I want  the user to select yes or no based on a drop down list. I was able to achieve this using a delimited list parameter type, which has been defined as a parameter in the expected column : However, when I save it, the "is selected" appears blank. When I look in the SQL table itself, the value is there.   Table after I save it:   SQL table in SQL server:   Colum configuration:   So what is the configuration so that I can see in the columns what the user have been selecting ? Am I missing something?   Regards,

Good morning,I have a pdf report that varies in page length, however my department requires it to be all on one page. I was successful in getting everything one page using CV Extender function. But since the font size is static, it minimizes the text regardless of pages.  Wondering if there is way to write a rule that can switch between font sizes. For e.g. IF Page Number > 1, then font size 9. Else, run font size 12.  Any idea will be appreciated. 

Has anyone experienced Excel taking a long time to open when the onestream plug-in is installed?  Our users see a 10-30 second delay opening excel when the plug-in is enabled.

Existing customer is using Guided Reporting and has multiple Drop Down Boxes.They would like to select the first Dimension's Drop Down Box (Entity) and only See valid choices for the second one. In their example, if they choose a Philadelphia Entity they only want to see the Departments (Ud2) that are valid for Philadelphia.Is there tagging or another method where this can be done dynamically? Or worst case scenario, a hard coded list of what are valid combinations? Thanks very much. 

I want to create a button on my excel spreadsheet that will execute a BR or a DM is this possible?  I see that there are OS functions called XFGetCellUsingScript and also a XFPut but I can not find any documentation on all for any function except the basic XFGet, XFPut and GetMemberPropertyetc.   Is there documentation somewhere that I am missing?

Hi, Is it possible to have headers for the Dimensions inside the cubeview ( Row Member expansion)?   Thanks & Regards, Madesh K

Hi All,   I'm trying to display prior 6 months in my cube view. For e.g. if my WF time is 2021, I want the CV to show last six months in 2020 (Jun - Dec) and so on. I tried using half year member filter, but it didn't work as it should. Any suggestions will be appreciated.   Thank you, Mustafa

I've been creating cube views and have sometimes found that I may forget to update a row that is part of a reporting segment. This results in the sum of the rows not equaling the total row for the reporting segment. Does anyone have any suggestions on how I can create a row in the cube view that validates that the rows of a reporting segment equal the total row? I would want this row to be invisible and to have a condition that it would only display if there was a variance. I'd be looking for something like this: Row 1: $100 Row 2: $100 Row 3: Total = 200 Variance = 0  

Is there a way to use multi-line expressions in the definition of my cubeview rows? I would like to break down some of my expressions that are growing too long.  But my fear is that when I use multi-line expressions (assuming that is possible), then other onestream developers won't know about that - since the cubeview doesn't give any visual cue to show that multiple lines are being used.  Here is an example of a really long expression that I'd like to break apart.   E#AllBranches.Base:Name("{BranchCode = XFMemberProperty(DimType=Entity,Member=|MFEntity|,Property=Name)},{BranchCurrency = XFMemberProperty(DimType=Entity, Member=|MFEntity|, Property=Currency)},{BranchText2 = XFMemberProperty(DimType=Entity, Member=|MFEntity|, Property=Text2)},{BranchText6 = XFMemberProperty(DimType=Entity, Member=|MFEntity|, Property=Text6)}, XFMemberProperty(DimType=Entity,Member=|MFEntity|,Property=Description)")

is there a way in Onestream to prevent S.C# as a valid scenario on XFD form uploads?We are attempting to prevent users from using an older XFD upload form that have been set up with the scenario as S.C#. We can then control future form submissions with transformation rules.Thanks  

Is there a formula (for use in Excel/Spreadsheet) to retrieve the Global Time setting from Application Properties?

Is it possible to use data from attributes and attribute values in a cube view row or column filter?

Is there a way to use functions as parameters in an XFGetCell formula? I want to retrieve values for the previous month to compare to the actual month.  It would be nice to use something like T#MonthPrior1([actual month]) instead of using some excel functionality to calculate 2022M1 and use that.     

Happy Monday Y'all, How do I call a cube view extender BR in a cube view. I'm using it to increase the report sub-header font. I'm using a code that was described in OneStream XF manual.  \ Here is the code: Select Case args.FunctionType Case Is = CVExtenderFunctionType.FormatReportUIItem Dim uiItem As CVExtenderReportUIItem = args.Report.CurrentUIItem If uiItem.UIItemType = XFReportUIItemType.PageHeaderLabelCenter1 Then uiItem.FontSize = 14 uiItem.Bold = True End If End Select Thank you, Mustafa A

How do I set up drill down for relational sources in BI Viewer?

Good morning All, How do I make build this dynamic calculation for my Monthly Rate KPI CV?  It takes the new month and divides it by the previous trailing month (e.g. Jan-21/Dec-20, Feb-21/Jan-21....)   Here is the code I wrote: Dim RentalRevenue As Decimal = api.Data.GetDataCell("A#NetIncome:U4#[Rental Revenue]").CellAmount Dim RentalRevenueTrailing1Mo As Decimal = api.Data.GetDataCell("A#NetIncome:U4#[Rental Revenue].Prior1").CellAmount Return RentalRevenue/RentalRevenueTrailing1Mo   Any ideas will be appreciated. Thank you.   Best, Mustafa A  

Hi All, Is there a way to visually see in a Cube View that a cell has a document attached to it? The purpose is to attached supporting documents to some Cube Views. Thanks  

Hi All,I'm creating this report which uses a custom formula, that takes SUM/AVG of past six months, and calculates the Pct value. I tried using Rolling6MonthTotal and Rolling6MonthAvg  view dimension in Denominator/Numerator, but it doesn't work as it should. Any ideas on how I can make SUM/AVG the prior 6 month, and run this calculation (highlighted). Thank you for your help.Best, Mustafa A