Application Build

I am trying figure out how to make a dashboard page show up by default when a user signs into their application. Does anyone know how to accomplish this?

Hi, I've had a dig around, but I can't seem to find it.  Anyone know where I can see the disk space utilisation?We've set up a number of new apps in our environment recently, and I'm concerned we might be running out of space.

Can someone provide any  documentation and use case for different Source Type in dimension properties section?    

Hello,I would like to align vertically and horizontally the text on my column header (in Cube Views and Reports).It seems there is no option to do that in the format parameters (only in Excel).I have tried to use an inline Formula, at least for the Report format, but it is not working. I keep having errors messages.Do you know a solution to get a more consistent presentation ?Thank you in advance,Morgane

So we have a UD2 mapping set up in the List section. What I want is to be able to set up a Complex Expression in the UD2 Composite section so that for certain accounts it does nothing and so moves on to the List section, but for everything else we have a hard coded UD2 (e.g. None). I have no problem with setting the criteria in the Complex Expression, but I don't know if it is even possible to write some code that forces it to skip on out and look at the List mappings? I realise this is maybe a bit back to front compared to how the Composite mappings work, but we have a very tight list of accounts where we need to do the List UD2 mapping,  and everything else (which can be any other account) should just go to None.

Is there a maximum number of source id values that can be loaded to one workflow? Is there a maximum number of source id values that can be loaded for an entire application?

Hello OneStream Community, A few days ago a colleague of mine wanted to know the meaning of the various PropertyId constants present in one of the Application Database Audit Tables.I was unable to find any OneStream specific documentation on this PropertyId code and its meaning, so I created a business rule to complete the puzzle and get what we needed for the metadata audit at a very granular level.  For any one else experiencing an issue similar like this here is a table of the Member property Id's and their meaning.Dimension | PropertyID | PropertyDescription Entity PropertyID | 100 | Currency Scenario PropertyID | 100 | ScenarioType Account PropertyID | 100 | AccountType Entity PropertyID | 150 | IsConsolidated Entity PropertyID | 200 | IsIC Scenario PropertyID | 200 | InputFrequency Account PropertyID | 200 | FormulaType Flow PropertyID | 200 | FormulaType UDx PropertyID | 200 | FormulaType Scenario PropertyID | 300 | DefaultView Account PropertyID | 300 | AllowInput Flo

Hi all, How to download the table contents from the System --> database --> Tables or Views, when I tried to download, it is allowing to download the 50 rows only - I'm not sure where is a restriction like this and how would I avoid these issues? Thanks  

Dear Community Members,Found several great posts about creating account members from a rule.  I am trying to clone a scenario member (Forecast with Range defined). I have to admit that i am running into a knowledge gap when it comes to how to create some of the properties.I am reading the properties of my source scenario and naively thought i can just use SetStoredValue with the property of the source scenario.  Got stuck at InputFrequency.Any pointers to documentation, Golfstream, Community posts, or samples would be greatly appreciated.

Hi,  at the moment we are migrating OS from v6 to v8. The logon procedure in V6 and V8 is SSO, while login in V6 on there is a small pop-up window to choose an account for OS. This pop-up automatically closes after the choice. In V8 the button External provider sign in is not there, instead via logon it opens a full window that does not close automatically.  is there are solution to get this full web-page closed in v8?   thanks,

Is there an easy way to bulk delete members in OneStream?

This was originally a question.It took a while to figure out, so to save someone else the hours of trial and error, here is the process I use in detail, start to finish, to run a Workspace-based Data Management step in a Workspace Assembly business rule.Here's a How-to step by step:List of abbreviations used below:DM: Data ManagementWS: WorkspaceMU: Maintenance UnitBR: Business RuleAS: Assembly1. Workspace:Set the NameSpace Prefix - this is what gets filled in at runtime for __WSNameSpacePrefix2. Assemblies: Note these properties 3. Create the Assembly Business Rule:Create an "Extender" business rule, this is done by right clicking files and selecting "Extensibility Rules"Add some test code, to verify correct configuration, such as BRApi.ErrorLog.LogMessage(si, "Hello from the new extender!"then code the way you would any other extender4. Create The Data Management Group: Create a DataManagement Group in the same workspace that the Assembly that has your business rule is in 5

The Question Text Column scroll bar in my Certification Questionnaire is not working. I have a long question text which does not fit the default cell size. The scroll bar is not clickable/draggable, so my reviewers aren't able to view the entire question during certification. The workaround I have is just to expand the column size so that the text fits into the cell. I am wondering if anyone has the same user experience or has a solution to get it to work? My current software version is 7.1.3.  

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

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?  

Hi All,Does anybody have experience working with books which has dashboards as a pdf.In books, I have Report and inside it has dashboard report as a type. Why we cannot add dashboards there. It is only showing components list. Also, I am adding component like data adapter, grid, embedded dashboard but it is not working. In preview section it is not showing any report or output.   

Hello,I am encountering an error when assigning a BI Viewer to a dashboard in version 8.5.  The BI Viewer is sourced from a Cube View MD data adapter. When I run the dashboard to which the BI Viewer is directly assigned, it renders fine. However, when I run the main dashboard attached to my workflow, I receive the following error message. I have done the same processHas anyone encountered something similar before - and if so, was there a fix? I am perplexed, because I've been able to use BI Viewers in child/dependent dashboards without issue.  

in our initial design we have a local Admin user - OS_Admin that runs all our DM and Scheduler jobs. This was a local Admin user that pwd never changed (IT requires all AD users to change pwd's and we have too many embedded scripts with pwd for this to work).  When we migrated to V8 and the new SSO security structure was applied, we found that keeping the option for manual user sign-in created more issues for our SSO users than we could justify so we have stopped being able to sign in as this user. Issue:  We have logic that is pointing to the Global and this user's settings that drive most of our activity.  In the short-term I have changed the User based settings to point to my user but I need to get away from that. Need: I need to be able to sign-in as the local user to set the POV for WF (Scenario, Time, WF) OR is there a way I can change that from my Admin user.  Don't care either way, just need the result to be that the OS_Admin user's POV is updated. 

Hi All, Anyone has encountered OS-CAT-0021 error while performing copy application by using cloud administration tool? what's the solution to sort out this. 

hi All, I need to upload data into the new scenario Plan with 5 years and would like to load data in parent membaers (Entity, Account and UD1), I'm using the scenario property "Allow input into Aggegated Consolidation member" but I think that this property is for another purpose. I'm coming from EPM Planning where it could be possible and many people told me that uploading data at any level is possible but cannot find any example. Could somebody help me? Thanks in advance and best Regards. Mario Guerrero

Hi everyone, My employer recently migrated from v7.4 to v8.5, and one of the new 'features' is the ability to rename journals before submission.  Due to internal processes we'd like to restrict users from making any changes to journals names (regardless of their status) as they must follow a predefined naming convention.  Based on your experience, does anyone know if this is possible?  Thanks, SERGIO

Hello everyone!I require some assistance regarding the following objectives that I have in mind for this cube view.Showing the monthly data input cells (which I have done), along with the total sum of all the months in the year.Getting a percentage by using the monthly data / current year.Currently, the Amount 227.00 under actuals - 2025 column is a member filter under rows/columns whereby i use getDataCell(CVC(Col, 1) + CVC(Col, 2) .... CVC(Col, 12)) which I know it isn't the best idea. But I want the column under 'Total' to show this amount and with this amount, I will calculate the percentage in the next table.For example, on the 2nd table (green cells), on row ACTYPE001, when the user click calculate, the answer should be 1/227 x 100 = 0.44% at Jan 2025, 2/227 x 100 = 0.88% at Feb 2025.Please advice on how I should approach these issues or any improvement or suggestion I should be doing.  

Having the option to disable the "Load" button and only show "Load and Process" on the WF step would help when we add a rule in the process step that needs to be run every time the user uploads a file. This would reduce the risk of a user clicking Load and not Process, which is important for our operational planning teams to avoid data being missed or incorrect because a calculation or rule was not completed.

    Close

hi all, I just want to confirm the tool's approach: If I have a foreign entity (defined as EUR), can I post a journal entry directly to USD (Translated), and it won't be overwritten by the built-in currency translation? (in other words, it won't just overwrite translated with whatever is in local?) Or is there something else I have to do to accomplish a USD journal in a non-USD entity?