OneStream Platform Forums

You cannot use OneStream to directly report on SAP data 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

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?

Hi    I want to read a text value from dashboard in finance business rule. I tried attaching a parameter to text box component and then read that parameter in the code but that is not working.   Thanks, Omkareshwar    

I would like ask about culture settings and how it influence casting from text value to decimal number. We have an automated import from external system using delimited files and pre-stage table in application database. From the file the data is loaded as a string and from the string it is translated to the decimal value in connector. We use the query here (see that there is explicitlely specified a culture to be used for a casting): selectIFRS_account, ledger_id, currency, pairing_code, ICS_code, Partner_description, PARSE (local_ccy_amount as decimal(26,5) using 'en-US') as local_ccy_amount, PARSE (transaction_ccy_amount as decimal(26,5) using 'en-US') as transaction_ccy_amountfrom [dbo].[MyExternalTable]where importGUID = '{import_GUID}'and _tbValid = 'Y'and coalesce(ICS_code, '') = '' During the testing we found that culture settings for user have an influence on the results. How is that possible? I thought this is a job for a server side and there should be no effect of client app

Hi all, In our OneStream environment, we have few hundred users and few thousand groups to which these users are assigned to for granular access. Want to check these with OneStream admin Gurus:1) Currently the semi-annual user re-certification exercise is done manually by extracting the OneStream user/group access reports and asking the approvers to re-certify. This is proving to be cumbersome exercise. How do you all do this in your environment?  Are there any best practices about this?2) Have you used or seen/heard about a third-party tool like SailPoint being used to manage OneStream user / group access and resulting re-certification activities? How difficult it was to build integration between a tool like SailPoint and OneStream?I would love to hear your experiences.Thanks in advance for any experience sharing.

I am modifying a business rule that uses the entity name to search a similarly named (Entity_Acct_Description) table and return a value.  I want to verify that the table exists before attempting the TransformText to prevent errors in the case of new entities or name changes.  Is there a way to verify the named object exists before executing the code?   ElseDim LookupTable As String = TEntity & "_Acct_Description" ''''IF Lookuptable exists do this''''SAccountDesc = BRApi.Utilities.TransformText(si, SAccount, LookupTable, True)

Hi, Is there an easy way to get MemberScript from the DataCellPk? I can see a method called 'GetMemberScript' (what a surprise) on DataCellPk object, but it doesn't work (or I cannot figure out how it works) in Extensibility Rule. The goal is to take the details of one DataCell, replace one of the members and process (validate) such created reference to another DataCell. Any tips? Best, Karol

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.

Hello team,has anyone implemented the drillback functionnality in onestream ?I need help to build it ? Is there a pre-build module ? Or what are the steps to put it in place ?Thanks in advance !!

Hi, I'm currently using a FDX query to create an automated Journal. Works basically fine but when the FDX query is completely empty it throws an exception error message. Not a very big deal but the users experience this as a failure of the system. Does someone know a way to avoid this throw or to customize the exception error message in case of an empty datatable? FYI a check on the datatable (f (Not dt Is Nothing) And (dt.Rows.count > 0) Then) still gives the throw.   Thanks!  

Hello,I am wondering if it is possible to open the Data Attachments box by clicking a button on a dashboard instead of right clicking on the cell and selecting Data Attachments for Selected Cell and then clicking the Create Data Attachment button?Thanks!

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?     

Hello, I am looking to connect with folks who have implemented specialty cubes to manage data for sales, HR, Projects, Treasury, etc. We are exploring the capability of building a digital transformation roadmap using a cube approach, similar to how Essbase can be used. We are considering using the register to utilize larger data sets and other functionalities. Would love to hear your experiences. Thanks! Regards, Ronnie

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.

You cannot change BiBlend configuration if a Workflow “Blend” step has already been executed 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

Hi Everyone, I hope all are well.   I am trying to use the GetICMemberFilter function in a business rule but I don't know how to get the VarybyCubeTypeId.   Does anyone would know how to obtain the VarybyCubeTypeId using a XFBR?   Thank you for all the help.

Hi All, I am trying to find the best way to load my budget day. I currently have 22 departments, 207 accounts and 100 facilities that I need to load too. Do either of you have any suggestions on what's the most effective way to get my data loaded in OneStream that will take the least amount of time? I greatly appreciate your input.   

Hi community, refering to the solved request in the link: Solved: Show 0.0 in Cube View Data Cell instead of blank cell - OneStream Community (onestreamsoftware.com) Is it also possible to get a drill down here? That doesn´t work with the described UD8 anymore. Thanks.

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!

Hi all,In our use case, users are uploading data through files into OneStream. Is there a possibility to check if the file have 1000-seperators in the file and block the upload if this is the case? Reason is that within one workflow the 1000 seperators could differ between users and we want to avoid issues in this instance. Ideally we have a parser rule that checks the amount column.With kind regards,Tim Vierhout

Hi,I wonder what's the difference between IsConsolidated member property and Aggregation Weight which is relationship property? When one's usually set IsConsolidated to False? I can imagine that it make sense for non-additive values (like KPI's), but I'd rather use for that Aggregation Weight, so not sure what for is that differentiation. Any tips, example use-cases?