Application Build

Originally posted by James Kirkby I have a question. I'd like to give a select couple of users from a systems admin team access to specific data management jobs that export OS data for CSV purposes so they can cross-validate between systems. I've set up and assigned a role granting them access to the data management admin page; then set the security for maintenance group on all jobs to admin so they couldn't edit any jobs. I wanted to add their jobs to a profile so they could find them easier for organization purposes, but couldn't really tell what the point of the profiles was? When I assign a group to a profile and click on that profile or group, it seems to just let me edit security settings and that's it. I can't run any of the jobs from a profile. Am I missing something? The admin guide is vague here.   Thanks!

Even a simple globals.getObject("_ex") throws a object reference not found error. Is the use of the globals object prohibited inside a spreadsheet rule? The code: Error log when this spreadsheet rule is used: But if I comment out line number 24, the error log becomes:     

Hello, has anyone seen an error like this before? I'm loading information from our PreProd to Prod environment and am getting the following error: "Summary: Error processing XML file type 'DataSources'. There is an unclosed literal string. Line 11771, position 4968693." From what I can tell there isn't anything particularly special about this line of code. It also appears that the remainder of the datasource file was loaded even though this error was received. Any help in this matter would be appreciated.

Hi I am trying to extract a dashboards  from an application and load into another application, would any one be able to share the XML template that is used for Project Extract & Load? or would appreciate any other helpful suggestions and guidance.    thanks - Kumar 

Scenario: I have a Sql Editor component, with a couple of date-columns. If the value in the belonging custom-table is value NULL, then the value in the editor will always be the minimum value of the sql datetime type. I just want to show a blank value instead of "1/1/1900". Anybody solved this?   Cheers Frank

Hi experts. I have a query with regards to drill-down feature to locate the journals from 'AdjConsolidated' member. The entity hierarchy of the client has multiple levels and they post journals at each of this level (i.e at parents as well as base entities). When we drill down by origin from a top member and want to further analyze the balances under 'AdjConsolidated' member, we understand that drilling to entities won't give the desired results as the jnls were posted against Adjinput members.    Hence, they have to start the drill down by entities from Origin 'Adjustments' Member and keep checking for each sub-structure below it to see if the jnl comes from an Adjinput / Adjconsolidated member. Is there a better way to directly drill down to the actual jnls that were posted. Regards, SC      

Hello,   I have a question about multiple applications.  I know typically people think of OneStream as having everything within one application seperated by cubes.  Thinking of an application where Planning activities are quite different than existing consolidation activities and I am a bit weary of trying to jam it all into the existing Consolidation application.  I am wondering if it would be easier to organize in a seperate application altogether so there would be a planning application and a consolidation application and the planning data would eventually be loaded into the Consolidation Application after it's approved.  There are a number of reasons that lead me to entertain this idea one of which is performance and that we may only ever want to 'Aggregate/C#Aggregated' the data in Planning and 'Consolidate/C#Local' the data in the Consolidation application and we don't want it to get confusing with what data to use for the users.  Other reasons relat

Has anyone used Git or another version control / source control system with OneStream?  Currently, we keep a lot of commented out code in our OneStream system.   It would be a lot nicer to be able to only have to keep the latest in production, and have a version control system track the changes.    By default ( not that I know how to change it) the OneStream app does  only 1 XML document per type, so the changes aren't tracked at the individual object level, and you'll get a lot of changes to search through.  Has anyone made it work, or are you aware of a best practices document or other doc for this?

Is it possible to use the where clause for the member expansion ".Tree", specifically filtering on the AccountDim.  There is a top-level reporting cube and a few merged cubes sitting beneath (using entity extensibility). There are also a number of  extensible Account Dimensions utilized... i.e., Level 1 (Highest - Forecast Accounts)                     Level 2 (Consolidated Accounts)                            Level 3 - #1 (Lowest - linked to lower-level reporting subsidiary cubes using base GL Accounts - the account dimension names for these cubes always include 'Base')                            Level 3 - #2 (base GL Accounts)                            Level 3 - #3 (base GL Accounts)         &

Statement: You can move data or metadata between applications Question Credit: Peter Fugere   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   Want more Fact or Fiction? OneStream Press Authors are subject matter experts... but do they know about the 80's, sports, movies, or other pop culture trivia? Are you able to tell if their knowledge is fact or fiction? If so, come for the crown, stay for the fun, and emerge the new Fact or Fiction Champion at Splash San Antonio. Prizes will be awarded! You can volunteer to participate or you’re welcome to attend. Secure you spot today by contacting Press@OneStreamSoftware.com. We hope to see you there!

Hi everyone, Is it possible to set a search/filter option in the combo box where user can type in the value and it will be picked up from the underlying list?  Alternatively, another component that can do it? I have tried using the tree view with search and filter option but it does not display anything if I use member list as bound parameter. Any other parameter type should be used specifically for tree view to work?

I have five cube views attached within a dashboard that utilizes the tabular layout. The content dashboard where the cube views sit is redrawn when a combo box is changed. However, the dashboard always redirects to the first tab. Only the content dashboard is set to redraw when the combo box is modified, and embedded dashboards are utilized to build up to the main dashboard. The goal is to change the combo box without redirecting the dashboard to the first tabbed report. Has anyone else seen this behavior and has a solution to redraw the dashboard with the new combo box selection while maintaining the current tabbed report displayed?

Hi, let's say I have a dimension with Member001 to Member020 being siblings. In a cube view I want to have rows with all members from Member001 to Member012. Using cube view designer, what's the syntax to specify the range, without having lo list all the 12 members? Thank you

Good morning, We're configurating IC matching permissions. When entity A sells to entity B and there's a difference in amount, user X must conciliate and match transactions. X belongs to seller entity A, and he has permissions in A, but not in B. That’s why he can’t see any IC transactions, unless we give him permissions in B. My question is: what are the minimum permissions in OS to give X the ability to do IC matching between A and B, but no more.   Thanks in advance,     Ramon Odriozola

Happy inflation and food shortages <Not!!>Quick question. I have over 15 years experience in Essbase and find it confusing that we have multiple 1Stream cubes in one 1Stream application - but they all share the same outline!! I think I understand 1S extensibility.Is there an article that explains the differences of Essbase vs 1Stream? I would like to suggest to 1Stream developers to show cube name somewhere when I open a workflow. I don't see a way to tell if that workflow is for which cube!! very confusing.  

Hi everyone, Can someone explain how the UD Member property "Is attribute member" works? I would like to assign to my UD5 members some attributes and be able to create CubeView base on the attributes. As an example, my UD5 could be Customers and the attribute I would like to assign to each Customer is the type of Customer (Retail, non-retail etc).  I thought I would use the "Text 1" property of my Customer members to input the type of costumers. I would then create a separate UD5 dimension "CustomerAttributes" and list all the attributes. Finally, enable the "Is attribute memeber" property of my "CustomerAttributes" dimension members and do a comparison between the value in the Text 1 of my Customer members and the value in the "Comparison Text 1"  of my attribute members.

Quickviews are not showing in task activity . Is this a bug ? Or is there any other ways to monitor the quickviews launched by users

What is the best way to design and implement constant fx rate analysis?  We want to apply a budget rate to all months for actual/fc/budget.  Entities are loaded in local currency and I thought it would be simple to use an entity hierarchy in which I'd put the custom rates at the parent level so during consolidation it would use the set fx rates.  Unfortunately this is not working as I had hoped, I'm not seeing a difference at the parent level between the "real" hierarchy and the constant rate hierarchy. Thank you.

Happy "end of forced masking" everyone!    Why can't we log in as user administrator recently? We get message "invalid user or password" Maybe Our user administrator is locked out due to too many attempts to login with invalid password. How do I unlock ? (ps. I read OS Design and Reference guide about enabling users - I see that user Administrator is enabled. 

Hi to all, Im looking for any idea on how to inactivate users automatically. Let me know your thoughts.

Often global companies may report a metric like units sold or volumes in a stat account.  But that unit of measure may vary by region or country.  Below is one option for handling the conversion of stat accounts like units sold or volumes.   For example: Metric Ton to US Ton Kilograms to Pounds Liters to Gallons Etc   Here are some high level ways to tackle this in an application.    Considerations: Entities are tagged with currency already Normal Revenue/Expense account types will naturally get “AverageRate” table PVA method (all else equal) Normal Assets/Liability account types will naturally get “ClosingRate” table VAL method (all else equal) You need to identify which accounts (aka UNITSSOLD) need a translation rate table that differs You need to identify which entities are sending which volumes to drive translation to use different rate table   Your conversion rates do not vary over time so you really just need to store these

Hi  We have set up a line of business attribute in our UD3 dimension based on cost centres. It has become clear that in several reports we need to aggregate some of these members. I think the easiest way to do this would be if we could introduce a new layer between the current parent and children. My questions are a) is it possible to do this and if so how? and b) how would this impact reports that are already in circulation? I have tried to illustrate what I'd like to do in the picture below. Thanks

Hi all,   We've recently implemented RCM and I have one issue I'm trying to figure out. Certain accounting teams want to do reconciliations (for SOX controls) on certain accounts that have always had 0$ balances in the account month ends. I'm currently lost on how to get these into discovery - since it seems there has to be a balance at least one time for it to be populated there.   Is the a manual way to add a couple of all-time 0$ balance accounts that way there will be a reconciliation option for it?

Originally posted by Chul Smith 1/11/2018 Is a re-implementation necessary to change their calendar in their app? or can they just change it? They're on monthly, would like to stay on monthly, but change from calendar month to 4-4-5 month

Is there a way to customize the charts in TM dashboard to show category 2 values as X axis?