Application Build

Hello,I am getting this error when I try to extract a transformation rule group. Any ideas on how to resolve? 

Hi all, Does anyone know if the standard OS security audit or application dashboard reports present a way to determine all of the objects within a OneStream application where a particular Security group is used?For example - let's say I have a grp called "E_WF_specialUsers" and I want to better understand where this group is used within my application (i.e. is it attached to the display group of certain user dimensions, or account members, or workflows, cube views, etc.). I can't seem to find anything that does this within OS but want to make sure I'm not missing something here. Thanks in advance, K.

Hi all,it's not clear to me the meaning of the Culture field in User's configuration.I thought that changing the culture (eg: from English to Italian) would change all the "core" labels of OneStream (I mean menu options, labels, etc...).Instead, looks like that everything keep on being presented in English.Is this right or my (local) installation is missing some package/configuration ? Thanks

Hi,through XFString I am able to get a string defined in the same Maintenance Unit (or in another MU of the same WS).Looks like is not possibile to grab the String from another WorkSpace, even if it's marked as "Shared".Am I right or am I missing a clue ? ThanksFabioG

Hi ,Good Day!I'm currently building a dashboard in OneStream that allows users to select all possible points of intersection for dimensions and their members. Once selected, they can click a button to export the data to a file share using a Data Management export sequence. This part is working well, and the dashboard is complete.Now, I want to enhance it by capturing user details (who entered the data) and the timestamp of when the data was entered for each point of intersection. I'm wondering if there's an existing OneStream Marketplace solution or feature that supports this kind of tracking and logging.Has anyone implemented something similar or come across a solution that could help with this?Thanks in advance!

Trying to confirm if the spreadsheet tool in v8.5 is working for anyone in the following manner...Created dashboard with the spreadsheet tool.  The page renders fine...However, when doing something as simple as Save As, the following message is generated.Excel file is defined in the configuration.  One client mentioned this, so I tested this on another client with the same results.Heard this is fixed in v9.0.  Is this correct or am I missing something?Thanks for any input!Ed Puente

Hi Everyone, I know we can use culture settings to show users localized member descriptions, or XFStrings to change text in dashboards, but what defines the display language of the core UI? If I wanted the desktop or browser app's UI to render in another language (e.g. French for certain users), what options do I have? Thanks

Hi All,I am working on a Cash Flow Cube View to show the beginning cash, ending cash, and change in cash (activity) in three separate rows. All the base cash accounts are under the new parents (beginning cash, ending cash, and change in cash) in an alternate account hierarchy for the Cash Flow. We are using the BegBal_Dynamic flow member from the Blueprint app for beginning cash, EndBal for ending cash, and Activity_Calc for the change in cash. Figures are flowing in, but for these accounts the columns have a view member set to Periodic, QTD, and YTD. The problem is that figures are not representative of the View member, that is to say that they are all the same on the ending cash. Below is a screenshot and the Cell POV for each of the members. I am happy provide any other screenshots or additional information to get a resolution on this.Thanks in advance!MTD (Periodic):Cb#Batesville_Cons:E#LE_TOT:P#?:C#Local:S#Actual:T#2025M5:V#Periodic:A#End_Period:F#EndBal:O#Top:I#Top:U1#CC_TOT:U2#P

Hello everyone, I'm just wondering if there's a method or a way to delete ALL Data with a click of a button.I know about data management steps and the use of it along with the finance BR.So my concept and idea is that, I allow the user to select the member (step 1) or list of members (if step 1 is good). Then the user can click one button to delete all data. Why I want to do this is because let say the user want to delete a certain member, it will be easier for the user to do so.I tried to retrieve all the cubes that I have in the application and changing it via the scriptbuilder/databuffer method and setting the cell to 0 but the concept of DataUnit do not allow us to do so. Thus, I am here seeking for guidance and wisdom from the community. :)Thanks! 

I have a dashboard that uses a Tree View.  Its in a named workspace.  The only way I can get images to work with it is to upload the images to a Default Workspace.  Is there a way to reference my images in the workspace where the Tree View is?  

When the Flow Processing Type "Is Alternate Input Currency for All Accounts" is enabled on a Flow member (as shown below Data Intersections become invalid for that Flow member and Foreign Currencies (USD, CAD).Entity BU_200 default currency is EUR. Note that when this property is not enabled the foreign currency cells are valid.My understanding is when this setting is enabled the foreign currency data cells should be enabled for data load or input. Appreciate any clarification on this.

 In the world of Enterprise Performance Management (EPM), clean and accurate dimensional mapping is essential for a reliable reporting process. Fortunately, OneStream makes this easier through its robust Transformation Rule framework, which intelligently handles new dimension members automatically.Whether it's a new GL account, cost center, or entity, OneStream’s transformation engine ensures that new data doesn’t derail your process, even before user intervention.🔍 Key BenefitsDynamic Member DetectionWhen a new source member enters the system—say, a newly created account in the ERP—OneStream flags it immediately as “Not Mapped” in the staging area. This provides the user or administrator with a clear indication that attention is required. Mapping can then be quickly added or adjusted to keep data flowing seamlessly.Centralized and Flexible MaintenanceTransformation rules support Wildcard and Dynamic Mapping, making it easy to set default routes for unknown members (e.g., directi

Hi Everyone, Is there any possibility not display Dimension icons in the cube view reporting?   

Hi Experts, I have a dynamic read only cube, source of this cube is a relational table having details like salary band, department, position, benefits %, tax %, etc. I am simulating some calculations in workspace assembly and setting records in the dynamic read only cube. I see expected data at base entity levels. How can I see correct data at the top entity level? Entity structure: I see same data at multiple levels. Asia and AllRegions data should not be same.  Also drill down results are same at multiple levels which is weird. So if we are setting data at base entities in a dynamic cube, how does consolidation work here? JackLacava​ , would you please clarify this?  

Hi all,I'm working on a Data Management to "Export Data", launching it from a Dashboard.Everything works fine, since filters (Cube, Entity, Account, Flow, etc) can be parametrized through Parameters.Is there a way to parametrized also the Options such as "Include Zeros", "Include Member Descriptions", etc ? I see that at UI level I can only choose between True and False, but I'd like to manage them from my dashboard.Thanks in AdvanceFabioG

So we have the GetBaseMembers method (or the GetChildren, or the GetDescendant or event the GetMember) that would return instances of the Member class.What is not clear (at least to me) is how I could filter returned members based on security.I could set Nobody in all the member Security's fields of a specific member, but it keeps on being returned by (for instance) the GetBaseMembers.I'm wondering how I could get only visible members, applying a filter that won't return them from the call.Also, it would be nice to know, given a member, if it can be seen, read or written.Two ways to get the same result, for different scopes.ThanksFabioG

Hi all, We have hundreds of historical (no longer valid) accounts sitting in a cube and we are looking at ways of de-cluttering resulting data retrievals to avoid seeing them.  But additionally, we want to prevent any accidental loading to these accounts from the source system. For reporting, I know we can populate one of the text fields with some text and then combine that with a Where() clause to filter out these old accounts. But, from a data load perspective, just wondering what the risks / benefits are of utilizing either (or both) of the In Use or Allow Input attributes; to prevent accidental loading of data there. We want to be able to continue to see any historical data for these accounts and be able to drilldown from the parent account and see that data. There are no member formulas associated with these - they are all base accounts. We don't care about the Scenario/Time specificity capability If anyone is using these attributes would very much appreciate any recommenda

Hi all,I have a DynamicCalc account where the Text6 property is populated. I also created a UD8 member that dynamically retrieves the POV account and returns its Text6 property. In my Cube View, I set the POV for this UD8 column to Annotation.This works well for all non-DynamicCalc accounts... I can successfully retrieve and display the Text6 property in the Cube View. However, for DynamicCalc accounts, the Text6 property doesn't appear. It seems like OneStream can't resolve the property for DynamicCalc members in this context.Has anyone encountered this behavior? Thanks in advance!UD8 member filter: 

Hi all, Does anyone happen to have the correct syntax for an XML file that modifies a single attribute (member property) and can be uploaded to OneStream without resetting other member properties? A bit of background, I have to add content to the Text7 field of over 3000 members.  I tried one version of a XML that only referred to the Text7 property for a single memberBut when I loaded the xml, some (but not all) of the properties for that member reverted back to original defaults.  On the plus side, it DID update the Text 7 field. I'm clearly not defining my XML properly so if anyone has an example of the syntax I can use to update a property without affecting anything else, I would love to see it. I realize I can extract all 3000 members to an XML, but if the Text7 property is not assigned anything, then that property doesn't get included in the extract (otherwise I could simply do a global search/replace):  in order to fix this I would have to write a script to r

HI, OS has report to verify extensibility. I wanted to know based on exp that what happen when report has an error from technical perspective. We have some ragged hierarchy to full fill our req, but report shows an error so trying to understand if consolidation won't work if that is the case. By they are in UD. 

Hi all,I tried to issue an api.Data:calculate with the following (fake) formula :A#ACCXXX:F:MYFLOW:S#MYSCEN = A#ACC001:F#CHI:S#ACTOf course OS complains because I'm reading from the current Scenario (ACT) but I want to write in a different Scenario that implies a different Data Unit (is it ?)While being in ACT scenario, if I would switch to DataBuffers to write in the destination Scenario (is it?)Could someone point me in the right direction ? I did this, but looks like it doesn't write a **bleep** !Dim _srcDC As DataCell = api.Data.GetDataCell("A#ACC001:F#CHI:S#ACT")Dim _targetDB As New DataBuffer()Dim _dcNew As DataCell = New DataCell(_srcDC)_dcNew.SetScenario(api, "MYSCEN") ' This WON'T CHANGE <===================_dcNew.SetAccount(api, "ACCXXX") ' This Change_dcNew.SetFlow(api, "MYFLOW") ' This Change_targetDB.SetCell(si, _dcNew)api.Data.SetDataBuffer(_targetDB, _destinationInfo)In the end, works fine... just doesn't change the Scenario... :-/ What am I doing wrong ? &n

Hello,Do you know how many groups I can create in each of the following sections: Data Cell Access Security, Data Cell Conditional, and Data Management Access Security?Thank you!Hoa 

Hi all,I'm hoping someone can see what I'm doing wrong here.First a question:     Is Scenario access cube specific?  Let's say I have 4 cubes.  Currently all 4 cubes give a user access to all Scenarios.  If I restrict access to a specific scenario for that user in one cube, does that restriction apply across all cubes?  I would assume No - am I wrong? I've been trying to set up restricted scenario access to a group of users in a certain cube.  I don't want to touch overall security for the Scenario because there are multiple regions that need access.  I've tried to set this up via Slice security (Data Access directly on the Cube) by using a Where clause in the Scenario definition for every group identified in the Data Access (i.e. Planning.Base.Where(Name DoesNotContain X).  This doesn't appear to be working.The User themself, has access to multiple cubes and there is no restriction to that scenario in those other cubes.So is it all or

Hello,Working with a client and implementing a marketplace solution that potentially requires us to go to a year that is before the start year of the application. Is there any harm in changing the start year to an earlier year? Those years will not be used for their normal operations nor feed data to the cube, so not sure if there would be an issue changing this. Any thoughts?Thanks,AJ

We are looking for some help in direction to build dynamic member addition to a dimension using extensible business rule in version 9.0 We have tried to use the code that is used in earlier versions which uses declaration like "Dim newMember As New Member" but it does not work anymore in version 9 as it gives error when assigning values to newMember.Name property and some search suggests that we now need to use "Dim newMember As New MemberEx" Using this declaration results in error compiling the business rule. We are looking for some help/direction on this.