Reporting

Does anyone know how to format the object lookup cell in the cubeview? We currently have formatting on the cube view as follows.    If(IsRowNumberEven = True) Then BackgroundColor = #FFFFFFFF, *white* ExcelBackgroundColor = #FFFFFFFF, Else BackgroundColor = #FFCFF0FC, *blue* ExcelBackgroundColor = #FFCFF0FC, End If If (RowName contains 'NoZebra') or (IsColHeader = true) then BackgroundColor = #FFFFFFFF, *white* ExcelBackgroundColor = #FFFFFFFF, end if   In some of our reports we use IsRowNumberEven = False, but in this case I need the odd rows to be blue, but since it counts the column headers I don't know how to get around this.   

Whats the Table name where all the Dimensions are stored ? I need to generate/Automate a report which will give me a list of all Dimensions setup in our system. I can do it using the Extract process But I need to write a business rule to SFTP the output of the dimensions data

Hi all, I'm still new to Cube Views and how dynamic they can be.  We currently have 3 separate Cube Views, call them Canada_Results, US_Results, and UK_Results that are run independently by different users. These each have their own unique Account and UD intersections in each row. Our corporate group would have their own Cube View, call it Global_Results which displays the total results.  Is there a way to build our rows in Global_Results to simply "grab" the row results from these existing Cube Views using a function like GetDataCell? We'd like to avoid creating calculated accounts or re-entering our Account/UD intersections as a formula for each row in Global_Results as that would get tedious for us to maintain.  Thanks!

My Cube view has entities in rows. One of the rows is a sum of several entities ( E#A1+E#A2+E#A3). In the 4 columns I have Actual, Budget, Variance and Variance%. Variance and Variance % being calculated from the two first columns. Works fine except for the row that is a sum of several entities. For this row I believe the variance-columns displays the variance for the first entity (E#A1). How can I solve this? Can I set calc order anywhere?

How do I combine XFMemberProperty with Dynamic expansion in a cube view?  E.g. I want to expand Entity and account on Rows. Row1: E1 =E#Total.Base, E2=A#FinancialAssets.Base in columns I have transaction and ledger amounts (UD5) and then I want to add one column with entity currency and one with Text8 which we are using for region. Based on the entity on each row. So the XFGetMembers should reference to Row1 Expanion 1. Col1E1: U5#DS_Trans_CCY Col2E1: U5#DS_Ledger_CCY Col3E1: XFMemberProperty: Currency Col4E1: XFMemberProperty: Text8   Entity.Base Account.Base Trans CCY (UD5) Ledger CCY (UD5) Currency Text8 Entity A Account 1 10 100 EUR Germany   Account 2 15 150 EUR Germany Entity B Account 1 23 56 DKK Sweden Entity C Account 1 78 78 SEK Sweden  

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 Cellamount just fine using the Member Script. Requirement is to get the cell detail in the report along with amount.    Below is the line from the code: LineItem = BRapi.Finance.Data.GetDataCellUsingMemberScript(si,"AUM","Cb#AUM:E#RevAccComments:C#USD:S#RevAccRecon:T#"+ FYQ +": A#MGMTFEES:F#CQ_MGMT_FEE_REV:O#Top:I#None:U1#None:U2#None:U3#None:U4#"+ Product.Member.Name +":U5#None:U6#None:U7#None:U8#None").DataCellEx.DataCellDetail.LineItems.LineItems.Item(0).Classification   any ideas on why this is not working? 

I am working with a client the requires the first row of each section of their reports to have a dollar sign.  No other rows in the section (outside of the total) need a dollar sign.  The cube view also has row supression on which means the row can and will change depending on the account, time and entity. Has any one encountered this before?  

Hello All,    I am trying to create a cube view or report if necessary to list our active Entities. I've been able to filter by "In Use", but we also need to include the Member Property of "ReadWriteDataGroup" where its set to "Administrator".  Is that even possible or would a Business Rule Member List contain the arguments necessary? Thanks for any suggestions!

Hello, We are in the process of building workflows . During the demo of required workflow forms, there are some check reports built for users to verify their data and add comments. When the user switches between report tabs in the workflow, the refresh takes approximately 20 seconds to a full minute depending on the report. Our implementation partner suggested reducing the number of columns. We do have several columns of data, however this is needed for a proper review, and would like to review alternatives before reducing the reporting content. Is there anything else we can do to increase report refresh speed when there's multiple columns? Thanks, Will

Hi All, Has anyone built a custom audit data report for their OneStream planning applications which shows which users changed which entities/accounts/scenarios, etc on specific days? Not sure if we have a marketplace solution for this. Any leads will be helpful. Thanks, Nidhi Mangtani

Hello, How can I call an account's assigned plug account via SQL? I able to get the PlugAcct DecimalValue, but need help with the syntax to return the account member name instead of the ID... SELECT     (CASE WHEN D.DimTypeId = 0 THEN 'Entity' WHEN D.DimTypeId = 2 THEN 'Scenario'      WHEN D.DimTypeId = 5 THEN 'Account' WHEN D.DimTypeId = 6 THEN 'Flow'      WHEN D.DimTypeId = 9 THEN 'UD1' WHEN D.DimTypeId = 10 THEN 'UD2'      WHEN D.DimTypeId = 11 THEN 'UD3' WHEN D.DimTypeId = 12 THEN 'UD4'      WHEN D.DimTypeId = 13 THEN 'UD5' WHEN D.DimTypeId = 14 THEN 'UD6'      WHEN D.DimTypeId = 15 THEN 'UD7' WHEN D.DimTypeId = 16 THEN 'UD8'      ELSE 'Unknown'      END)AS 'DimTypeName',     M.NameAS 'MemberName',     M.DescriptionAS 'MemberDesc',     (SELECT TOP 1 MP.TextValue     FROM MemberProperty MP    &nb

Hi everyone, do you know if the report run time and page number that is in the cube view report footer can be moved into the report header? I was thinking perhaps via a cube view inline formula?

Hi Team, We have a requirement to generate Level 1 member list (Department Member List) based on POV (Entity Dimension) selected so we have developed XFBR script to generate the Level 1 Member List. Now we have to generate Level 2 Member List (Product Dimension Member List) based on Level 1 (Department). I am not sure how to reference or Pass Level 1 information as a parameter to XFBR script?   POV Entity=>Level 1 Member List: XFBR(POV Entity) =>Level 2 Member List: XFBR(Level 1). Not Sure how to refer or Pass Level 1 information as a parameter to XFBR script. Thanks, Sudhakar S

Hi all,  I'm looking for a possibility to dynamically create a Cell Format via an XFBR Rule. Unfortunately it doesn't seem to work, but also does not give an error message. Could someone please let me know, whether and how it is possible? The script is e.g. returning something like "|!MyFormatParameter!|" in the easiest case.   Thanks in advance Markus

If the workflow time is 2020M3 and you used the time function T#YearPrior1(|WFTime|)PeriodNext1(|WFTime|) it would return 2019M2. Question Credit: Andrea Tout Is this statement fact or fiction? Comment your best guess below! Answers will be revealed in one week. * This question is applicable to Platform 7.3.0 and may not be relevant to future releases

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 filter and get all the rows for UD1 DL014. when I run the query it gives me erything for that Entity,Scenario and Time. Appreciate the help.    

Which CV format section or POV setting will allow me display account number and account description together?  Currently only the account description is being displayed.   Need to see: 10000 - Cash Current settings: Cash   Thank you,

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 to stored comment using the BR when click on a cell in CV. I have a save button to save the comment if they want to change it and save it. when they save reading this text input in the textbox. so same textbox is used to display and write. I am passing this text as [|!Param!|] to rule. whole setup work great but found an issue when there is a unbalanced "[" or "]" then it throws this error.  Error: Invalid comma separated values. Unmatched brackets wondering if anyone seen this or have a workaround to handle this? appreciate any help.    

Hi All- Can someone share how to hide the Instructions dashboard and show the TieOut Report dashboard when the Run Report button is pressed?  

Does anyone know the order that XFSetCells load in a spreadsheet?  I have duplicate metadata key infomation, and I'm trying to handle it by doing some accumulating with some more generic formulas.  I assumed it loaded top down, so the lower cell would be the last value loaded to overwrite preceding ones.  Doesn't seem to be playing out in every case that it's submitting top to bottom.

I want to be able to drill to HR details in BIBlend from any users cube view, so I set up a linked Dashboard using Default NavLink parameters, and a SQL data adapter using these default parameters.  It is working perfectly except for Account.  The cube account mapping logic is concatenating 3 columns in the detail file to map to a headcount account (ex Full-Time - Exempt -  Associate).  I assume I will need to set up separate BRs to apply this logic.  I am wondering if there is a better way to do this?  

I have a cube view that I need to modify so that in the second column we are getting data that is driven by the selection that the user makes for the first column. For example if the user selects a forecast for February to be in the first column, then the second column of the cube view would have to be the previous month’s forecast. Do you have any suggestions on how to achieve this view? Thank you in advance for any help and suggestions! I am going to attach some views of what I have in here so far (The second column reads OP plan as I have copied this view from another similar Cube View).          

Hello,I hope you're all doing well, this is my first time posting in the forum.I recently built a cubeview that contains one Row, I was wondering if there is a way to automatically generate blanks after each member - in my case after each Entity of the hierarchy - and considering that i have multiple member expansions.In order to clarify my request, please find below an overall of how do blanks should be automatically generated (1st Screenshot), you will also find a screenshot of the members used in my cubeview.Thanks in advance, wishing you all a blessed day

In looking at the dashboards page, the first item that needs to be created is the dashboard maintenance unit. Question Credit: Andrea Tout Is this statement fact or fiction? Comment your best guess below! Answers will be revealed in one week. * This question is applicable to Platform 7.3.0 and may not be relevant to future releases

Hello all, This one is a bit of a doozy, so bear with me. In this specific instance of an application, we have multiple cubes that share identical hierarchies, except one cube uses the Entity dimension, and one uses the UD2 dimension. Ex. below: Cube 1 = E#10001 Cube 2 = U2#10001 Our goal is to have a cube view that compares the actuals from Cube 1 to the Forecast of Cube 2. We have tried many ways to work around this, resulting in our most recent endeavor of using UD8 dynamic calculations to return a data cell value from a member script in Cube 2. Our issue is that while the UD8 shows the proper data, it does not allow end users to properly drill down from the data cell. It also does not allow a user to see the proper cell POV of the data being presented. Is there a better approach to this? Essentially, the goal is to have the row dynamically switch between the dimensions, UD2 and Entity, based on each column. Other constraints to note are that this cube view needs to be created using