Reporting

I'm trying to figure out how to build an expression that pulls "Avg Fleet" numbers and plot a bar chat on an existing pane. I've asked a similar question in this post - I was able to make the syntax work. However I still can not isolate just Avg Fleet. I would appreciate any suggestions on what I should fix.    I've been fairly new to Dashboard building that I need help to my bearings. Co

How do I generate reports in a loop for each member (branches) and send it to single excel file? I have a cube view report which I'm trying to run for multiple entities member (100+ locations). Any idea will be appreciated.

Hello!  I received a request to add a maximum and minimum line to a cube view. The cube view shows entities in columns and a variety of accounts in the rows (not together in a hierarchy, so no .base or .children, just a list separated by commas).  Max/min aren't available in the "getdatacell expressions" area so I emailed support to see if it's possible and they directed me to a ranking BR in GS. I loaded the BR, added a row to my CV and updated the pull but still am getting no data. Honestly, I don't think this BR and pull are the solution for what I'm trying to do but I don't know of any other way.  Do any of you have samples of pulling something similar? Were you able to get a max and min in a CV via CV math or some other way?  Appreciate any help I can get - thanks!  Here's the KB article provided for reference:    And the GS CV is in CVs > XFR Member filters (E) Member list using business rule > XFR Member List (C) Ranked Entity Sales.&nbs

As the title mentions - I have these months (Apr, May, Jun) that we haven't reported any numbers. How can I suppress the values within Cube view? I want this to be dynamic that if current reporting month is April 2022, then suppress all the future months from then onwards (show zero or blank).     

Hi, We have a requirement to get the Text fields for 5 columns. So, getting these we have used the "Data Attachment Members in the View Dimension: Annotation, Assumptions, AuditComment, Footnote and VarianceExplanation" and able to get the required text with using Member formulas. Could you please let us know if there are any performance/other impacts with using more cell text options use in Cube views. Thanks, Madesh

I have seen a few posts related to this topic but have yet to find any concrete answers.     We are looking for a way to sum members when going to the base level with a where clause without seeing all base members.  For example, we would like to get a sum of all of our Value Added Products.  Our UD4 dimension lists our products and we stipulate whether they are Value Added or not by putting "VAS" on Text Field 1 of the base member within UD4.  Ideally, we could compare our Total Sales at a top level with our Value Added Sales without seeing each individual products.  We are looking to report on all of our Value Added Products without seeing each base member.  We have tried a few business rules and other suggested avenues but we are not seeing the results we had hoped for.  If anyone has any insights on this that would be greatly appreciated. 

Hey All,I'm trying to add a column (bar) chart on top of this line chart. But I want it to reference and add a dollar based stats account (e.g. Avg Fleet Total) bar chart. I noticed there is a way to add a second axis on the right - so wondering if I can have two charts on the same pane.  Appreciate the help folks. Thank you!  

Hi,We have created one Cube view with using "True (but determine sparse rows using other columns)" option under Allow Sparse Row Suppression in Column level and gave "True" under Allow Sparse Row suppress in Cube View properties level as we have used Nested members in Rows with Parent.Base member combinations in Member filter level. When we run the report, it suppresses the rows as per other column even though formula column is having data also. Ex: Cube view created with 2 columns1st column with Account12nd column with calculation GetDataCell(A#Account2 + A#Account3)Row is getting suppressed if Accout1 doesn’t have data even though Account3 is having data also. If we remove above suppression options report throwing an error as exceeding the rows limit since hierarchies are big. Could you please let me know if there any option we can use to show the data at 2nd column level in above scenario

Hi,  We have created a cube view report with nested dimensions in row. Our requirement is to add header for each dimension. Attached the screenshot for reference. Could you please let us  know how to add the header in this case. Thanks & Regards, Madesh K

Originally posted by Ashok AmreshWe are loading data using SQL connector business rule and it works fine manually. looking for a way to load it automatically using a extender business rule and then calling from DM step. has any one done this? can you share sample code if possible?

I have a report that uses it's own conditions to calculate a value. Is their a way to over-ride the blank/data cell in cube view, and have it run a simple IF conditional calculation? Most of these conditional calculation are for KPI's (basically forecasting for 2023 and on..). One of the condition within excel I'm referencing.      Would appreciate your suggestions. Thank you!   Best, Mustafa    

Is it possible to have a number formatting to show a dash "-" rather than a zero "0"? Thanks

Hi, I am (again) trying to use parameters in a SQL table editor. My parameter is set in order to get a column from an SQL table. When I test the parameter, this is working fine. However, when I add this parameter (which is a bound parameter) to the column of my SQL table editor, I do have the set of value from my parameter, but when I save the selected element, it appears blank. When I check the SQL table itself, I can see the value. This is probably silly, what am I missing ? 😓   Parameter definition : SQL statement : SQL table editor for the selected column : AllowUpdates = True, ColumnName = INDEX_CSR_CAT03, DefaultValue = |!P_CSR_QUESTION_LIST!|, Description = [Question code], ParameterName = P_CSR_QUESTION_LIST   State of the SQL table editor before save ; State after save : SQL table :      

We have cubeviews were we have enabled "Include Cell Attachment Status" and we want all comments printed on the PDF report at the end with reference to the POV, is that possible and if yes how do we do it? We have used Annotation Detail as we what our users to be able to have answers questions in a new Annotation Detail. Any advice highly appreciated! // Katarina

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 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,

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

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)")