Reporting

Hi there. Currently my client does not generate their financial statements from OneStream, however, is looking at using OneStream as a tool to possibly import, edit and publish into an adobe design template or word document for their Annual Financial Statements so that they can update comments and numbers and then export from OneStream again (basically trying to remove the back and forth to type setters') does that functionality exist in OneStream? Thank you.

Hello! A user has requested a CV/report that starts with imported data and layers on journal entry details by each specific JE. High level it would look something like this with the pink highlights representing the detailed balances of each individual journal entry:                 Have any of you built something similar? Is there an easy way to get the journal entry name details into a CV? I’m guessing I can get them from the JournalHeader and JournalLineItem database tables but wondering if you’ve ever worked on a request like this. I've also submitted a support ticket so we'll see.  Thanks!

Hey guys!   I have been testing the BI and got to a point where I need your help.   I made a cubeview:   Added it to the data adapter         Made my grid and card, but it is showing different numbers.       I mean the SUM works but those are not my numbers.   I did tried with one of the calculated fields putting all the detail but it shows as 0.         I must be forgetting something basic but not sure what.   Hope you can help me.     Thanks!

Hello!Is it possible to create an Excel Book that uses different cube views per tab?  Please share steps.  Thanks!Marisol

Hi,   I have a saved report setup with XFGets. One of the dimensions on the report points to the member "Top." Is there a way to have the XFGet show Top of the dimension and exclude a base member? Thanks.

Is there a setting or option wherein users don’t have to refresh the XFSetCell based excel reports every time the file is opened?

Hey guys! Happy new year. Do you know if there is a way to use more than one dim in the lif section for a calculated field in BI Viewer?  Thanks a lot!

Hi - Is it possible to drill back to the Analytic Blend tables from the cube data? I have an CV MD adapter which pulls the data from CV, and I created a Map & Bar chart and I want to create a Drill Back to the Analytic Blend tables because it has SKU & Customer level data which is not present in Cube. I am able to create the separate but not able to integrate. Do I need to create any Connector Rule? Any thoughts on this topic would be appreciated?   Thanks 

Hi everyone, We have a form using the Insert Suppressed Member functionality and have two questions related to this functionality. When selecting the dimension that is suppressed to insert, is there a way to not show the dimensions that already appear in the rows of the form/cube view?  Currently it allows users to pick all members in the member filter - suppressed or unsuppressed. We noticed if the cube view has columns that are doing cube view math - the Insert Suppressed Member screen it will show the logic of the first row in the form - which could be misleading to users.  See screenshot below for example.  Items marked in red/#2 refence the first entity in the form/cube view - not the entity being added/inserted.   Thanks

When trying to format the report and create a space between sections users are seeing random numbers pulled from the formula. The XFGetCell is referencing blank cells, but somehow is still pulling in a number when trying to drag down formulas. This causes users to have clear out the formulas when copying down the xfgetcell. I would expect this to give an error, but not a number. Anyone else see this and know of a way to get around it? Added a screen shot below for reference.    

Hello  I have a requirement where i need to join the framework database and application database in the same dashboard . We have created data adapter individually one for framework and one for Application databases but that is not solving our purpose.  

Hi,  I have an cube view that is used by many entities. There is one row/account in this CV where we would like data to be shown only if the user is in a specific workflow entity. If not in that entity the row should be blank.  I know I can build a new cube view only for this specific entity but would rather use the overwrite function for this specific row.   

is it possible to get column E to show YTD values? if i change the view to YTD everything else changes to YTD. i tried using the getcelldata(#2022M1+2022M2 ......#2022M12) it works if i stop at #2022M6 but when i add the future months everything goes blank.is it possibly to get YTD and MTD numbers in a QV?   

Hi all, very new to OS and am having some issues using the XFGetCellUsingScript() function and UsingScript functions generally. Specifically, the GetCellUsingScript function can't seem to handle more than 2 POV changes to an original POV but using the XFGetCellUsingScriptEx() which has 16 POV arguments doesn't seem to work at all, it just returns #VALUEs. The XFGetCell function is comically long and inflexible (doesn't work with any arrays or text joining functions that I've tried) so [...]UsingScript[...] functions seem like a much cleaner way to go but I'm having serious difficulty learning to use any of them because the documentation for the add-in functions isn't very good. The descriptions of the functions under the Retrieve Functions section is not complete and it doesn't define the function arguments or give examples. Any thoughts, best practices or helpful blog posts you could share would be much appreciated.   

Is there a way to retrieve an alternate description for an account using XFGetMemberInfo (or another function)?  Regardless of what culture the user is assigned, the formula pulls back the default description, and I'm trying to figure out how users could toggle back and forth if that's possible.  Thank you!

SOURCE: ONESTREAM CHAMPIONSHi gang,Does anyone out here use Choropleth maps in BI Viewer and was able to figure out how to create new Shapefiles? Bi Viewer includes a bunch of default maps (8 in all - World, Europe, Asia, NA, SA, USA, Canada, Africa) but I’m looking for SHP files by states (i.e. California, Texas, etc.).Has anyone built different SHP files for BI-Viewer? If yes, please explain how?

When building a Cube View its helpful and best practice to build a report dynamically so that less maintenance is needed.  There is a Member Expansion Function "First" and "Last" but nothing in between (i.e., second, third etc.) For example, if you use X#MyMember.Children.First.Children it will display all the children of your member as well as the grandchildren of the first child.  Last will do the same but give you the grandchildren of the last child instead.  It would be helpful to be able to reference different positions other than first and last in a hierarchy so that the member that you need grandchildren of doesn't need to specifically be called out in the member filter. This would help my client tremendously with being able to have the most dynamic report possible in the event that members are added to the dimension hierarchy.

Ok, we have a cube view configured with a parameter for the following dimensions highlighted below in the POV tab of the CV   Now, I explained to our testers that we wouldn’t need to select the members under the CUBE POV because it is parameterized in the CV for selection. Three of the five users were able to see and select the view members.  I was able to replicate the issue with a test account. I created a test account to replicate the issue I selected the CUBE POV and asked why is it that I can select parameterized members for dimensions: Cons, Time, Scenario, Division, Entity, and not from the View dimension? Notice the only members that are populated in the Cube POV are Time, View, Flow, and origin (see below) Just for kicks, I select the view dimension,  select member SV (scenario view ), OK, and Close Can you believe the View members are now populating in the parameter?  Does anyone know why?     

Why is our UD8 Level1 formula called multiple times by cubeview- for over 25 mins? this member is the first column in our small report with other column being a month.We needed to display Level1 member to Level8 (our .base member) of our accounts dimension in a cubeview.It runs withing 1 min when there are only a few hundred rows of accounts to report.However, when we tried to change that report to include base members of our product dimension, it is taking over 25 mins to run –for  just for one entity.  The problem seems to be in our UD8 formula called level1.We logged the calls to UD8 member Level1. It seems to be looping through this level1 multiple times.We may expect less than 1,000 rows for one entity and for one account, using suppress zero.To limit the minutes it takes to run, we had to set “Max Unsuppressed Rows per page “ and Max Seconds to process” to 6 mins in our cubeview.

Is it possible to use conditional suppression in CubeViews? For example, I would like to suppress row/columns when a value is greater than zero.

Hi Team i have created a Bi Viewer report by fetching the People Planning Plan Data tab using SQL Data Adaptor and getting this error while opening the report from Workflow. My assumption is this error is popping up because of large dataset in the people planning data tab, as this is opening with lesser amount of data records, is there any way to make it work or to increase the no of rows for a bi- Viewer report?

Hi All,For some reason, we are getting errors (#Error) when we use the XFMemberProperty function in Excel with Account for the following 3 Member Properties; Input View for Adjustments, No Data Zero View for Adjustments, and No Data Zero View for Non-Adjustments.  Every other property returns a value or a blank cell which is what we want.  Any idea why these properties cannot just return a blank cell as opposed to showing an error? Thx,Mike

Originally posted by Hubert Gao Hello, In CubeView, is there any setting to show Zero for No Data cell instead of showing empty cell? Thank you!

Data generated by dynamic CubeView calculations can be imported into other Cubes or Scenarios” Question Credit: Jack Lacava 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

I am using the below formulae to fetch members in a cube view. Account -> A#Root.CustomMemberList(BRName= abc,Param1=value1) The results from BR defaults the indentation to 0 instead of the indentation that is mentioned in the formatting tab.   Do you know how we can change the indent level to 3 after the members get returned from BR.     JackLacava