Recent Discussions
Prompts for Power BI
Dear community, My company has just switched over to v8 and we are in the works of switching over from a current rest API to the Power BI connector. Is there any guide or thread that goes through how to set the prompts for the connector? I get a little bit confused as to what needs to be filled in. For example, the prompt asks me to fill in "Entity" and many other dimension parameters - however, our business consists of many, many entities and I would not like to create one data connection for each one of them. Same goes for "Account" and many other fields, none of which I am able to leave blank. Any advice? Rasmus
Security Access Error | Get Parent Workflow Status
Hi, I've got a business rule where I use BRApi.Workflow.Metadata.GetParent(si, si.WorkflowClusterPk) to look at the status of the parent workflow profile. However, if a user does not have access to the parent workflow profile, then they get an error "Security Access Error. User is not authorized to access workflow profile". So it seems that the function BRApi.Workflow.Metadata.GetParent(si, si.WorkflowClusterPk) is not very useful and it is a bit bizarre that it refers to user security. Is there a way to run this business rule as administrator perhaps or something else I can do?
Cleaning Data Tables of old data
I recently discovered that data from deleted Scenarios is not removed from many of the application data tables (XFW_PLP_Plan, XFW_PLP_Register, ...) Does anyone know why it remains and is it safe to remove as the scenario no longer exists. I would think removing the old data would improve performance and reduce db size. Or am I unaware of the tools to perform such maintenance?
NetSuite to OneStream Integration
Hello all, I need to verify and confirm the method of choice to set up an NS to OS 8.5 integration WITHOUT the SIC in play. Here is what I have uncovered thus far.... A SuiteAnalytics Connect is being considered via ODBC so OS can pull data from NS. I read a few things about this. One is that a BR would be set up in OS to call on a SuiteScript in NS initiate the data pull. Now, the missing piece is how to set up the connection in OS if there is no ODBC installed. Another thing is that SIC would not be needed. I also perused a blog that stated that Support can set up s direct connection to NS from OS, provided they have the NS info. Can anyone please confirm this approach? Rest API could be leveraged but looking for an alternative. Any input would be greatly appreciated. Thanks, Ed P
External Connection for OS App in Same Environment?
Hi there everyone, Anyone ever created a connection between apps in the same OS environment? Working on some data movement and I have the connector set up, but struggling a bit with the connection string for the external database connection I'm setting up to reference the app I'm pulling data from. Is it the same syntax as the BI Blend connection, or are there other keywords that need to be in there? Thanks!
Member Dimension correction
I created a detail account dimension without creating a summary account dimension first. When I attempt to create a summary account dimension now, I get an error message indicating the member already exists. I tried to delete the detailed dimension and start over but there is already data saved. How can I correct this?Validation Error: No security access to data cell being cleared
Hi Team, We have a client that upload excel templates using xfdrange into OneStream. They have different files per Business Unit (UD2). Two of the files run into the following intersection error during the validation step: All the other files are correct, however, when they upload these two files, all data intersections (from all other files) are suddenly also invalid intersections. For examples, the line listed here is not from either of the two files but from a seperate file that has no errors when uploaded individually). When you would navigate to "Intersection" instead of "invalid Intersection (1)" all data intersections from all files are there. Only the local users get this validation intersection, when I (administrator) would run "Validate" from this screenshot, the error dissapears. Strange thing is: they have uploaded data on this intersection before in previous Forecast Scenarios without errors Security has not changed for either the application, user, workflow profile, entity etc. these two files both have an account that is only used there but is set up in the same way as all the other accounts (and previously could be loaded in other scenarios). Could just be a coincidence. Application Security: ModifyData is set to Everyone One thing to note is that this is a new forecast scenario we recently created for them, however, setup is the same way as the other forecast scenarios in terms of security. I am also having a hard time understanding the error and why it is refering to "clearing data" in the validate step. Anyone that can help me a little bit more in understanding the error or knows what could cause this? Thanks in advance!
