OneStream Platform Forums

Originally posted by Matt Brown Is it possible to add number formatting to data in cubeviews depending on the scaling selected from a delimited list? I've tried adding the number formatting to the delimited list e.g. "3, NumberFormat = 0.00" but the system won't recognize the exact formatting. Although it does recognize other formatting such as Bold or Italics.

Originally posted by Charlotte Mikes We see it in the data import but it goes to none when it get validated.   The IC code has been set up in the IC dimension. I don't know where to go look to find out why the IC code load but during transformation/validation it go to none

Originally posted by Nick Bolinger10/16/2019 Customer has users who will only be working with Quick Views in Spreadsheet and not the Excel add-in. Can they set custom cell styling like they can in Excel? In 5.1 and 5.2 there's the same cell styles toolbar and it says you can set your own... but where?

Originally posted by Rahat Fatma Hi,  I am using bound list parameters which query the table to bring the year, but default value remains blank even though I have set it to be a particular year. Is there was way to make the default value for bound parameters to actually work    

Originally posted by Debbie Hinds Hi all, We are a new customer to OneStream and in the process of implementing the application.  We are wondering if anyone has a set of general test cases that you used for testing during UAT and willing to share with us.  Thanks, Debbie Hinds PRA Health Sciences

Originally posted by Christopher AyotteI'm building a report in studio and have a need to create a parameter that will capture the User Name of who is running the report. I know I can do this IN the report using Page Info control box. But I need to capture it as a parameter so that I can use the parameter as means to filter a SQL dataset query.   I've done this many time using SSRS, but I can't seem to find a way to do this in OneStream Studio Designer. Any suggestions?

Originally posted by Oussama Bourakkadi Hello, how can we delete multi selected members from a dimension?

Originally posted by Kyle KohneOver the past 2 year ends we have struggled in January close with certain data pulling forward correctly.  These issues stem from our set up of rules for pulling beginning balances related to Retained Earnings and some within our NCI .  Has anyone created a quality methodology for testing future periods.  What I'm thinking is if we only have data in January and maybe February to push that data all the way through December to see how the beginning balances will roll in January.  

Originally posted by Ramanathan Ganapathy Hello All, Currently, we are loading the exchange rate source currency as "USD".  We want to change the same from "USD" to "GBP".  Currently we have the default currency as "USD" in the Cube.  Question: 1) Is it possible to change the source currency from "USD" to "GBP" 2) What impact we should consider when do this change? Thanks & Regards, Ramanathan          

Originally posted by Kimberly Reasoner We have SG&A monthly Performance Reports set up in Books, All emails and packages are set up .  opening the PDFs under documents / Books they look great.   When I run the package and email the group of PDF's I have a distorted document and all you see is the LOGO on the report.  Is this a setting in OS somewhere.

Originally posted by Paul BerryI'm trying to run some code when a user saves a table using the SQL table editor.   However I'm not able to see anything happen. My setup is as shown in the attached.    

Originally posted by Robert Wang I get this error message when trying to load metadata, it has worked on other applications so not sure why this one isn't working?

Originally posted by Fredrik Erlandsson Hi all, Does anyone know how to easily overview changes in the EntityDim in terms of Percent Consolidation and Percent Owenership between periods and years? Can this be extracted or built in a cube view? For example if i would like to get a snapshot of one hiearchy in the EntityDim including percent ownership for period 2020M10? Thanks, Fredrik

Originally posted by Darpan Bhansali Hi Team, i was looking for the Audit Log for Workflow profile re-name or workflow profile movement from one parent to another, almost similar to what we have for Metadata logs. Any hints for the same ? Regards and Thanks Darpan Bhansali

Originally posted by Mark Houghton Hi, I am trying to build a cubeview which will have one row of data which is the movement between two parameter driven periods. At present I have fixed it for testing purposes to be S#Actual:WF and S#Actual:T#WFPRIOR12. The syntax for the 'movement' I have used is GetDataCell(BWDiff(S#Actual,S#Actual:T#WFPRIOR12)):Name("B/W Diff on Yr values") Most of my columns reference single account codes. These ALL give me the correct result. However, where I have used a formula to calculate the sum of a range of account codes then it will not return the movement value. If I make it a 3 row cubeview, one each for current yr, prior yr and movement, then my values for the 'sum of range of accounts' is returning the correct values for current and prior year but returns blank for the movement. What is wrong with my syntax ? I tried switching rows and columns but that did not give me a different result either.  Can someone suggest a better method OTHER than

Originally posted by Leyton de LangeHi All, I am using view member "VarianceExplanation" in a cube view for comments, and I have a question around how many characters can be used in the cell and also if there is a way to wrap text.  The plan is to use this cube view in a dashboard. Thanks in advance          

Originally posted by Ted AitasIs there any documentation on Data Sources - Data Mgmt Export Sequences?

Originally posted by Clarke Hair Looking to start using the View txt fields (Annotation, Assumptions…) and understand that there is no natural way to have that information aggregated/consolidated up. I am told that a BR is needed to do this. Just checking to see if this is correct and if anybody has had success in this getting it to work. Ideal use would be for our regional leaders to be able to see summary comments on specific line items that we report on.

Originally posted by Jeff BorycI have cube views in an Excel document. When I am trying to create formulas to certain sections of the spreadsheet, it references table names. This makes it extremely cumbersome to build anything out because each cell needs to be setup individually. Turning off Excel references to tables does not fix the issue. I can delete the name references, but that makes the cube view un-refreshable. This pretty much makes cube views in Excel a non usable function. How do I fix this???

Originally posted by Heather Upton6/4/2019 is there way to create a report to show which users have modified Dimensions including when members have been moved?

Originally posted by Hans van der Kemp10/1/2019 We have a dashboard for seeding all required data from source to target scenario for a given range of periods. The "Select seeding process" cbx represents separate DM sequences, each with its own BR attached. The available source/target scenarios should ideally be based on the selected DM process. For example, if user wants to seed Actuals PxQ to FC, then the source should be only S#ActualMan and the target should be 1 of the 12 Forecast scenarios (S#Forecast_M9 etc). Currently they can select any source to seed to any target, independent of the selected DM process.

Originally posted by George Waddell6/13/2019 Client doesn't like the effort of 3 clicks (First world problem indeed)...They are a former Hyperion Planning user and are looking at the equivalent of "Run on Save"

Originally posted by Geoffroy des Dorides2/27/2020 I am using the market place Intercompany dashboard.

Originally posted by Evgeniy Galanzovskyi3/11/2020 Example, make the Button not visible if WFPeriod is Jan.

Originally posted by Dominic Arblaster12/4/2019 Also to change the column text name. Column 1 is always Actual at current rates at the pov time period.Column 2 starts as Actual at current rates Prior12 (Reconsolidated with CY rate)The user selects Budget, or a forecast for Column 2 The T#Period for Col2 changes to the same period as Column 1