Recent Discussions
Referencing business rule in data management step
I'm struggling with something elementary here. I can't seem to properly reference a business rule in my data managment step. I've tried a couple of options - explicit workspace name and 'Current' which should both work, but I consistently get the error: Error processing Data Management Step 'MyDMStep'. Business Rule 'Workspace.MyWorkspace.MyAssy.MyBR' is invalid. or Error processing Data Management Step 'MyDMStep'. Business Rule 'Workspace.Current.MyAssy.MyBR' is invalid. Using that name as a reference, this is how my App Workspace Heirarchy looks: Anyt input would be greatly appreciated!eVoid21 hours agoNew Contributor7Views0likes0CommentsShrink & reindex, and elastic pool usage
Hi, I have recently reduced a PROD data table by several million rows but the Allocated table size has remained largely unchanged, as the reduction in the Used portion has just shifted to an increase in the Unused portion and the elastic pool usage has also remained unchanged. I'm assuming that if I run an app copy of PROD into DEV then OS will try to copy over the entire elastic pool size rather than differentiating between what is Used and Unused and only copying over the Used portion. A shrink and reindex has been suggested as a solution to reduce the Unused portions but I have been advised that running a shrink is a risky move as it can cause performance issues. I therefore wanted to check whether a shrink and reindex in the PROD environment, at least during monthly maintenance, is widely used and generally benefits the environment rather than being detrimental to it?IL3 days agoNew Contributor II36Views1like4CommentsREST API Execute LogonAndReturnCookie
I am trying to determine if we are using any REST APIs. We were instructed to run a logonandreturncookie via Postman. https://documentation.onestream.com/1384528/Content/PDFs/REST_API_Implementation_Guide.pdf I followed the instructions in page 26 and ran into this error message: Error: Invalid character in header content ["Authorization"] I entered "{{webapi_access_token}}", similar to the screenshot in page 27. I hovered over the token and saw a message stating it's not defined. Where should I set up this variable or is there an issue with my params/body?bjornliow7 days agoNew Contributor III19Views0likes0CommentsCannot access the file because it is being used by another process
I'm trying to export data via a Data Management step. I am running into frequent errors stating: Error processing Data Management Step '[DM STEP NAME]'. Unable to create or open file '[FILE PATH]'. The process cannot access the file '[FILE PATH]' because it is being used by another process. My servers were unoccupied as no tasks were running in the background in the task activity log. I've also tried via DM sequence and selecting my own server which did not help.bjornliow8 days agoNew Contributor III86Views0likes6CommentsCan ERP transactional data be loaded into OS?
Hi, my company's OS data integration with the ERP system has been set-up to load monthly TB's into OS and for transactional tables to sit outside of OS but with the ability for OS to query and drill-back to view transactions. The transactional drill-back function is limited in that a drill-down first needs to be performed to get to the detailed dimensional intersections at the lowest UD level before a drill-back to view transactions (at that precise lowest level set of dimensional intersections) can be run. It is therefore easier to use a stand-alone BI viewer outside of OS to view transactions. Am wondering - is it possible to load ERP transactional tables into OS (this may contain millions of rows spanning multiple years) and for OS to then display transactional level detail across higher-level roll-ups (e.g. viewing transactions across a cost centre parent rather than only at an individual cost centre level), or even display transactional detail in quick views, essentially making OS have similar functionality to a BI viewer?IL10 days agoNew Contributor II109Views0likes8CommentsDecrypting files in integration
Hi All, There are two files. I can decrypt one file but unable to decrypt the second file during the integration stage, getting this error: Session details have been confirmed. No changes there. Any thoughts how I can troubleshoot this?Solvedjaideepk13 days agoNew Contributor II51Views0likes5CommentsCube root workflow profile "cube" tab
Hi, while reviewing the Workflow status view in the Cube root profile, I noticed a second tab called Cube that I hadn't previously paid much attention to. The tab appears to be empty. Does anyone know if this tab can be customized, for example by adding reports? What is the purpose of this page?AndreaF15 days agoContributor III10Views0likes0CommentsError Message: A column named 'AccountType' already belongs to this DataTable.
Has anyone seen the above error message or have thoughts on what it might pertain to. I am trying to load a delimited file to a BI Blend table. My test file only has 5 records. When I import the data it gets to 12% Complete - Translating Cache step. The only place I can find a reference to this field is on the file suffixed with '_RS'. BI Blend definition Error Msg:SolvedRandyThompson16 days agoNew Contributor III17Views0likes1CommentLoading Annotations Only via a Workflow
Is it possible to create a data source to load annotations only from a flat file. I am tagging the annotations in the flat file with the View dimension. It seems like the data source always wants an "Amount". Is this case I have no amount so when I Ioad the data file, I get an error that "No Valid Data Keys in File". It seems that this should be possible. Maybe I should do this via Excel loads.SolvedGreg_S18 days agoNew Contributor II3.7KViews1like10Comments