OneStream Platform Forums

Hi All, Can anyone suggest is it possible for Admin to enforce Workflow POV and Cube view POV for users, if so please guide where to do it on OneStream  Thanks in advance.

Hi All,   Currently I have weekly data, if i enter commentary in Week2 it should be in the same week later if I enter commentary in Week3 am getting w2 data in w3, can anyone suggest how to overcome this?     Thanks in advance.

OneStream 7.4.1 (On-Prem)Looking to upgrade to 7.4.2.Has anyone developed a strategy to upgrade OneStream with minimal downtime?  Uninstalling and reinstalling the application takes time, and I would like to avoid as much downtime as possible.I am using 1 server for everything.I was thinking I could install 7.4.2 in another folder, but I believe the install would attempt to create the same IIS app pools that already exist.Any suggestions would be appreciated.

We have several parser rules that are running on our connector to d365. Is there a way to see what the affect on run time is from each of these rules?  Do these rules run on all data that is queried from our connection or just new data?

Hi, there is a way to get the sum of the values of all the members that I filter with the text3? for example text3='Austria'In this case in Row1, I have E#Entity.Base.Where(Text3 = 'Austria'), which identify two entities, and in Row2 GetDataCell(CVR(Row1)):Name(Total Austria), but it doesn't work.  

Originally posted by Andrea Tout 2/7/2020 Has anyone ever had to check what the user's response is to a certification question and not allow them to certify based on that?

HiIs it possible to show a message box in excel?I am currently writing a SpreadsheetFunctionType.SaveTableView rule and I would like to display a message box to the user with any data validation errors when trying to save.I have tried :Throw New XFUserMsgException(si, Nothing, Nothing, "My error message")However, this doesn't seem to work. Regards,Mark

Hi, we are currently in the process of Finalizing a Data integration process (via connector) between some temporary staging tables created in the Onestream application (on cloud), but when i try to perform the final step to load the data, the system always returns me the message that allof the rows i'm importing are NON-NUMERIC. Obviously that's not the case. the source table amount column is a numeric format and the amount field in the source field is being mapped to the Amount field in the data source.  Did Anyone experience this?Thanks

We have a workflow that uses Data Management Export Sequence to load the data. Manually we are loading the data fine but I'm looking for any options to automate this process.I have an example if the workflow uses a connector business rule but not sure on the Data Management Export Sequence. If anyone can help, it would be great...!!!

Hi I'm trying to link this form to an Headcount correction form but when I navigated to this linked form, It shows me in the Group adj column green cells. How can I make them imputable? 

Hi,I have set one Time Profile in one cube from Oct 2018 to Sep 2019 (first fiscal year) and another Time Profile in different cube from Jan 2019 to Dec 2019 (second fiscal year). I need to present Consolidated Report of both periods from beginning of both fiscal years simultaneously in one dashboard. Can anyone help ? 

Hi, Is there any way to get DataManagement step failure email notifications? I have one sequence which use some DM steps to perform Clear and Consolidations. I do not want use a business rule to call in a Custom calculation.Thanks for your help in advance. 

Hi,I want to have a consolidated report from Oct to Sep of any year. In order to achieve this, one time profile is created and attached to a cube and the same cube is used in cube view. What should I write in T# for cube view column ? Thanks in advance.    

Hello, I have a sub folder that is being populated each month with a variety of files, it is different from month to month.  The naming convention of the subfolder is consistent.  It is always the fiscal period.  However when I try to zip the files in the folder I am unable to define a path.  The folder is "Application Database/Documents/Public/" then the fiscal period.  However my code is never able to find it.  I think it is because we are on the cloud.  Any insight on how to define the process for zipping all the files in that folder into one document so it can be sent out through parcel service would be appreciated.Thanks,Tom

Is it possible to add already existing parameters to a report that is being created through the report designer tool in dashboards?On that note, is there any type of user guide for this report designer tool?

I have a process that builds a data buffer using Data Buffer Cell Loop logic. I need to check the cell status on each record and perform certain actions based on the status. Specifically, I want to make sure all 12 Account-Type dimensions are referencing a base member and correct them if they aren't.However, I'm not getting the correct Cell Status when the cell is in a data buffer. For example this code creates two data cells and logs their status. (In this case, I'm looking at DataCells, but the behavior is identical on DataBufferCell objects). Metadata is from GolfStream.: Dim baseMemberFilter As String = "A#50200:O#Import:U2#None:U8#Test" Dim cellPk As DataCellPk = api.Data.ParseDataCellScript(baseMemberFilter) Dim cell As DataCell = api.Data.CreateDataCellObject(cellPk, True, 100, False, False) api.LogMessage("Base UD2 GetMemberScript: " & cell.DataCellPk.GetMemberScript(api)) api.LogMessage("Base UD2 CellStatus.UD2HasChildren: " & cell.CellStatus.UD2HasChildren) Dim

Hello All,I found two very instructive discussion on the forum:Extender: Export Metadata via Extender - OneStream Community (onestreamsoftware.com)Solved: Automatic back up of security - OneStream Community (onestreamsoftware.com)But still, if I export all dimensions in one file, the file is very heavy and hard to use. Can anyone tell me how can I make it with business rule?KeithBerry kudos for great solution you provided in another topicKind regardsJarek

Hello OneStream Community, I hope this message finds you well. I am reaching out to tap into the collective expertise of the community regarding metadata extraction from OneStream. Your insights and experiences on this topic would be invaluable. Process and Tools: What process and tools have you found effective for extracting metadata from OneStream? Are there any specific approaches, techniques, or best practices that have yielded successful results in your organization?Alation Software Integration: Has anyone in the community utilized Alation Software for metadata extraction from OneStream? If so, we would greatly appreciate hearing about your experience with integrating Alation and extracting metadata from OneStream. How well did Alation cater to your organization's requirements and enhance your metadata extraction capabilities?Connectors, APIs, and Custom Solutions: Can you provide specific details on any available connectors, APIs, or custom solutions that enable metadat

Hi All,I am using  FdxExecuteDataUnitTimePivot to export data from onestream cube, everything working as expected except one issue. i.e., I am using consolidation member C#Aggregated beacuse i want to export data for C#aggregated, but FdxExecuteDataUnitTimePivot is exporting data from C#CAD. All our users input data at C#CAD, also default currency on entity is CAD. Just want to know is this the known issue, or FDX designed to export only base currency? Is there any way to pull only C#aggregated with FdxExecuteDataUnitTimePivot.  

Originally posted by Katarina Sterley We have 4 extensions to our main cube and now we have a problem with the standard intercompany matching reports. The end users do not see the transactions on the lowest level from another cube. They only see the IC transactions within their own cube. If they look at the main account they see the transactions but that is not displayed in the standard intercompany matching report within the workflow. Like this from quickview: From Workflow report: Any suggestion on how we should solve this? Kind regards Katarina

Hi Team, can we run or test the business rules or code snippets outside OneStream environment? Do we have any SDK's to setup and test locally?ThanksManju

Hi,  As an admin user I can add and delete rows from a SQL table editor. However a non-admin user does not have access to do so. They can view the data but the add/delete row button on the toolbar are greyed out. Can someone tell me how to give them access to add/delete rows? Thank you Mark

Hello experts,What is the impact of changing assigned entities from one workflow profile to another workflow profile (both being (base input type).Will there be any impact on prior data loads? Are there any other areas we should be careful with this change?Example:Entity A,B and C are assigned to a single workflow profile - WF1 and loaded via WF1.Import. Now, we'd like to divide them further for future loads by creating new smaller workflow profiles such that: WF1 will be stripped of all assigned entities & WF1.Import can be changed to a Central Import type for Entity A, B and C.Entity A is assigned to & loaded by WF2 (new WF created)Entity B is assigned to & loaded by WF3 (new WF created)Entity C is assigned to & loaded by WF4 (new WF created) Thanks,  

Are there any resources for building an external library?  I'm looking to build a dll and getting an ambiguous namespace issue for DbConnInfo.  It appears to be an issue between the OneStream.ClientWindowsBRApi.dll and OneStream.SharedDatabaseTables.dll.  

Hi,Are there any suggestions regarding best practices to store encryption key passphrases and SFTP passwords in OneStream, for usage by integrations ? How should those be stored ? We are using cloud version of OneStream.BR,Avijit