Reporting

Is it possible to make an attribute member run a comparison based on the stored text attribute for a specific Time Period ?Ex: - Text8 & 2023M1 =>  FO_SUPM      - Text8 & 2023M6 => FO_HYPMBased on the cell pov, is it possible to make the attribute member adapt to the context's Time Period instead of picking the stored Default Value for the Text 8 ?Thanks. 

Hey guys,   Got the question internaly if there are any way in a cubeview to get rid of the search boxes in the column for the rows. And instead insert text value, like which dimension it is.  Looked around in the cubeview display format but can't find anything. Running OS 7.4. Thanks  

In a quick view, I am using the syntax T#Pov:V#Periodic,T#POV,V#Trailing12MonthTotal in the 'Time' dimension. I have a specific requirement where I need column A to display as "2024M1 (or the short description) Periodic" and column B to display as "2024M1 (or the short description) Trailing12Month Total". I can see there are variables available to pull in the POV description, but I'm wondering if there's a way to get my desired outcome of providing all descriptions for all dimension members in my filter when they are not linked to the POV. 

I've been hunting around for information on the last run date for cubeviews, I may not be looking hard enough but I don't think it's stored anywhere outside of taskactivity? If this information is out there somewhere in an easier to grab format please do point me in the right direction, otherwise is my only option to query this information from the TaskActivity DB myself and hope that it hasn't been cleared in the timeframe I'm looking to query? As a bit of background we have hundreds of cubeviews at this point and I'd like to clear up the estate. Ideally I'd be starting with data on when each cubeview was last run (possibly supplemented with how many times it has been run in the past year), followed by querying with the relevant departments whether the cubeviews are needed  based on this data. 

HI All, Is there a way we can identify which cube views have not been used/opened for say last 6 months to a year?  

Hi, we are in the process of migrating into V8. while testing some of the dashboard we observe that BI Viewer is not rendering charts when it refers to dashboard. when running alone BI Viewer it is working fine.  can you anybody please help me this on priority . is there any option to enable?  working fine on 7.1. Thanks.

Hi Everyone,When trying to access the Spreadsheet section in our application, we were met with this error message that we did not recognize. We were unable to open the Spreadsheet section because of this unless we opened the application in a new window. Has anyone seen this error message before or know what the root cause for it was? 

Hello everyone,I’m working with a flat entity hierarchy and need some help.I have entities like FRA1, FRA2, GBR1, and GBR2. In a cube view, dashboard and/or spreadsheet, I would like to aggregate the amounts by region, such as FRA (summing FRA1 & FRA2) and GBR (summing GBR1 & GBR2). However, I would like to achieve this without creating a new hierarchy.Below is a representation of my goal:Do you know of any ways to proceed with this?Thanks in advance for any help or suggestion!

I am trying to calculate months to date in a cube view column based on a date entered in a text field within Entity Dimension members. The text field would display in one of the columns on the cube view report, and the goal is to effectively subtract the current month from that date's month to derive a total months to date calculation in another column. Any thoughts on how I can do this? 

After upgrading to v8, we seem to have lost the comma formatting that was there on the standard IC Matching Partner Detail report.   Is this something that I can change, and if so will I need to do this anytime there's an upgrade?  I can't find where this setting resides.    

I'm trying to produce a report schedule for Miscellaneous Receivables to show the make up of the Account.  I'm looking at trying to use Cell Details if that will work, but didn't know if anyone had a better idea.  The setup is I have one Miscellaneous Receivables account and I want the users to enter the detail make up of that account.  The lines will change over time to different descriptions that can show up in dynamic report rows.  Like I said similar to cell details, but they don't seem that easy to use in a cubeview.

Maybe I'm missing something easy, but I'm trying to get some rows to group in the Excel import, and I can't get it to work properly. I think the problem may be that the rows are GetDataCells, but I'm not sure. So my question is, will the ExcelOutlineLevel work for GetDataCells, or is it restricted to member trees?To illustrate visually, I'm trying to get a bunch of rows like this: To export into Excel grouped like this:

Hello, I have a dynamic calc UD8 member, where I put small value grater then 0 (0.00001) to be able to display certain rown even when the initial value is 0. This works with FormulaPass, but does not seem to work with dynamic calc. Does anyone know if there could be a problem that dynamic calc values get supressed when all CV supressions are set to "True"? Thank you!

Hello We are trying to build a CV where we need two parameter selections by the user. The first parameter selection needs to be passed into the second parameter. The second parameter is configured as a bound list using Method Type as Business Rule, and the first parameter selection needs to be passed as an argument in the Method Query - but the BR is not able to resolve the parameter value and is only able to read it literally. Following configuration is for the second parameter The BR is reading t1 as "|!TestingPrompt1!|" and not the actual parameter value that was selected by the user. Any ideas on how to solve this are appreciated. Thanks!  

Hi, has anyone figured out how to add files to Narrative Reporting. In the Admin area I have blanks in the Source File Name column for my documents. I cannot seem to figure out how to add word docs and cube views into the fields. Ideally, I would want the package to populate out a cover page which would be summary of MTD and YTD results followed by a page for both results in Income Statement format with a variance explanation page last. Thanks for any help in advance

Hi I have a form and there is a balance sheet account, total input and validation columns. The condition is to check if the balance sheet account value has a value and total input has no value, if balance sheet account is 0 and total input has a value and total input is greater than balance sheet then validation should be 0. If balance sheet is greater  then total input then validation is 1. This validation is stored in a member formula and I was wondering how can I get the validation column to show 1 or 0 based on the conditionI have tried the SetDataCell() first but found out that on a member formula that does not work, which other function can be used. Your assistance will be greatly appreciatedRegards 

Hey All,We got a recent requirement of implementing a conditional statement inside the cube view columns. The user wants to calculate a certain column on the basis of the value of another column. The design is explained below:If B <> 0 thenD= B+Celse if B = 0 thenD= A+CABCD1010020120 (100+20)200130150 (20+130)0203050 (20+30)I'm currently facing difficulty to implement this solution inside the cube view. My first shot was trying something in the XFBR string but that I couldn't get around the logic to implement the same.Any leads will be appreciated. Thanks!Pragyanshu BansalJackLacava OSAdmin 

Is there a way to drill through the entity hierarchy in a Quickview that shows the total of Top in the Consolidation dimension? I have users asking me if this is possible.   In the example above 87M is the total amount of the child entities including eliminations showing in the second Quickview but no total. The first Quickview is at local before eliminations therefore doesn't addup to the total of 87M. I've tried to use CAD but get the same numbers as local.    

All,  We currently have a combo box (with entities) in a dashboard but we would like to make this list a bit smaller and based on the security rights a users has. I want to solve this with a XFBR which i afterwards attach to a parameter and that parameter in a combo box. Does somebody has an example of this XFBR code which i can look into? Or is there a better way to do this.   Thanks

Hello - I have a cube view that's linked to another to show detail. I have bound parameters set on the time, view and account dimensions. These parameters are all working properly except for the calculated column I have in the main/parent CV - its a column that has a GetDataCell expression. When I right click and select "Navigate to Entity Drill" on a cell in this column, the account and view members are still correct, however the time period its passing through to the linked CV is incorrect. The time member it passes through to the linked CV is the period of the first column in the main CV. So for example, the time period of the first column is 2024M4 while the period for the GetDataCell column is 2024M8 - the linked CV will show 2024M4 even though the Cell POV shows 2024M8. How can I send the correct time period to the linked CV on this GetDataCell column?

Hi, All, I am planning to generate the report for users who are active/inactive, last login date? I am reviewing the Framework audit tables however I couldn't find exact fields. Can you please let me know ? thank you

Hello, I am trying to create a Dashboard with several cubeviews in it. I created a delimited list parameter with different categories of cubeviews. Does anyone know how to assign the cubeviews to the different display items?For examples, I will have a category "Sales" and when the user will select "Sales" in the drop-down menu, I want certain cubeviews to be displayed in my dashboard. thank you!!

Hi all,I have a simple cube view where on the row I have Tree expansions, like the following one:UD5#MemberName.TreeThe reason I am using Tree instead of TreeDescendantsInclusive or others is because I want the rows to collapse on opening  and RowExpansionMode=CollapseAll only works with Tree for the first dimension of the row as far as I now.Now, the issue is that I would like to remove a member from the rows and the Remove does not seem to work on Tree, while it works on TreeDescendantsInclusive and others.U5#MemberName.Tree.Remove(U5#None) returns this (expansion enabled=yes, none removed=no):U5#MemberName.TreeDescendantsInclusive.Remove(U5#None) returns this (expansion enabled=no, none removed=yes):Is there a way for me to have both the ability to expand/collapse the rows and remove members from the hierarchy, or it is just a trade-off with the impossibility of having both at the same time? Thank you 

Hello,There is this grid view property that has been bugging me for a while called 'Show Row Headers'. Using VB.Net, we cannot define 'Headers' for the rows of a DataTable object, so I'm curious to know how to use this property to the fullest ?By switching it to 'False', the only noticeable difference is this little blue arrow that disappears: I assume that we can have a CubeView-like formatting with Row & Column headers using the grid view, but I can't seem to enable it.Thanks for your help.

Hi All,I am trying to use a font in Onestream which seems to be working fine in the cube views and Excel extract, however it it does not work in PDF. May I know the reason why it is not consistent? I have updated application properties, hard coded in business rule, and added the font family in the cube view itself. But does not work on PDF which is the most important one.Any suggestions?