Recent Discussions
Dimension Descriptions Extract
I need to automate a process of Extracting certain Dimension Descriptions into a Comma Delimited text file for exporting into PowerBI. The application extract puts it into an XML format, and I need it into a comma delimited file. Any suggestions?johnal6714 hours agoContributor8Views0likes1CommentEnvironment Management
Hi All, In your OneStream implementation, how many environments do you have? Dev, UAT and Prod? Or do you also have Pre-Prod environment that is common in ERP systems? Also, in the UAT environment do you also have copy of data so that when testing happens or developers need to test the changes - there is enough sample data to test? Would you consider brininging data from Prod, randomize it and load into UAT env so that UAT env data at all intersections as Prod? Thanks!NS202524 hours agoNew Contributor II5Views0likes0CommentsDatabase space control policies
Hi! We are trying to control the size increase in our production application. We know the growth comes from: Stage tables that allow users to drill down and back onto source data. Data records Audit tables (they can grow a lots if they are recording continuous changes to rules, data for example) Logs which will impact Framework database growth (task activity and error logs, will vary depending on the detail login set in BR, DM and on the system configuration as well as your retention policy) Load transactional data, which will increate your data units and data records unnececarily, which BIBlend should be used for this type of data load instead of loading it to the finance cube. We have analyzed it and we realized the StageAttributeTable and other stage tables has a significant size. Has ayone performed databse maintenance by deleting data from the stage tables? Is it possible to do that while keeping the cube data intact and workflows completed? Any ideas or best practices regarding database maintenance would be very welcome. Regards, XaviXaviC2 days agoNew Contributor III26Views0likes2CommentsHow do I change a parameter value in a dashboard?
Hi everyone, I have a business rules that is triggered through a dashboard. This Business rule is looking at a True/False parameter. How do I add the parameter to the dashboard and with a dropdown list showing the valid values (true/false) that can be used to save the value to the parameter? Thanks in advance,Filip3 days agoNew Contributor II50Views0likes4Comments- KeithBerry4 days agoOneStream Employee661Views0likes3Comments
Cube | Data Access | Data Cell Access Security/Slice Security by U1#Geography
Data Management Access Security Please share your expertise to set up a Cube's Data Cell Access Security / Slice Security to limit data read access as outlined below: Dimension: U1# - Geography Total_Geography = Child 1 + Child 2 = Total / Top North_America = Child 1 / NA International = Child 2 / Int'l Slice Security: Access Level - Read Data by Geography - in a CV and a QV Total_Geo_Data = Read Total data | Read NA data and Read Intl data NA_Data = Read NA data | no data access = International and Total Intl_Data = Read Int'l data | no data access = North America and Total TY for your practical advice - SMEs.Solved228Views1like3CommentsUnable to connect to OneStream Login Error
Hi, I'm seeing this error for a user that has been setup in OneStream. We've attempted to exit out of the application and run it, but the same error message persist. So far no one else is experiencing a similar issue. Has anyone experience this issue? Would it be simply a configuration issue? Thankscarbon11 days agoNew Contributor49Views0likes1CommentSupplied Parameters in Workspaces
Hello, I have a button which is fed from a List Box seen below Upon clicking this button, I would like Users to navigate to another Dashboard where the label component and cube view open with this button selection. Are supplied parameters the way to accomplish this? If so, what are the correct configurations to achieve this. Thanks for your help!JakeSteinberg11 days agoNew Contributor III38Views0likes2CommentsIssue with Excel Data Extraction via Drilldown
Hello everyone, I hope you are doing well! I’m having an issue with an Excel extraction of my data rows through drilldown. I have a French profile and my Excel is set to French, so when I have separators with spaces, it extracts the amounts in a strange format. Have you encountered this problem before? Thank you very much!hoaphan12 days agoNew Contributor III14Views0likes0Comments