OneStream Platform Forums

Hello,   I have this Cube View that I created in which I have to move the half year (H1) column to be in between Q2 and Q3 in order to match the formatting of the report that I was given as the model. I have attempted to make some changes to accomplish this but I have not been able to do so. I am displaying the quarters as Time:T#WFYear.Quarters       How can I accomplish this formatting goal? Furthermore what is the synthax that would allow me to display a single quarter of my choosing?    Thank you in advance for your time and cooperation!

Hi All, Does anyone know of nice reporting on the metadata and the properties of each member?  Basically, I am looking for something like the Dimension Library Grid View to be displayed in a user-friendly report.  Before we start building something I wanted to make sure someone doesn't have an easy solution for this.  Would want something that users could easily access perhaps via Cubeview or Dashboard content. An example would be a report that shows all of the accounts with their metadata properties (ie. description, AllowInput, AcctType, Text1-8, etc.).  I checked the Application Reports (RPTA) that is in MarketPlace but it doesn't have anything.   Thx, Mike

Hi,   We're trying to combine our detailed sales data housed in BIBlend with the member table in the application database. The reason for this is so we can join the client name assigned to our UD3 dimension to the detailed sales data. However, as the BIBlend is an external database & the metadata is an application database, I can't call both of these in one data adapter. Is there a way to combine metadata & BIBlend tables in a SQL data adapter? Thanks,  

I am attempting to edit a report in studio and I cannot figure out how to make the grid size bigger so I can edit all the items.  The initial report was formatted to shrink to page width if that helps.  The preview looks fine but the designer tab  is cropped.      

Hello All,   I'd like to know if there is a way to have/combine somehow in a Cube View the fact to have the collapse/expand function that the .Tree expansion provides while still applying a filter on the member we want to render below the top member. Something like this in essence : TopMember.Tree.Where (text1 = 2). Seems we cannot apply a where clause on .Tree expansion, and I would anyway expect that the collapse/expand option is not active anymore when we start to filter with a where clause but I'm trying to explore options that would allow to meet this kind of requirement Thank you in advance for your feedback Matthieu

Hi,This is probably not something I can do. But I was wondering if it's possible to automatically lable a tab in excel witht he name of the cube view I download? It would be a great time saver when I'm dowloading multiple cube vews or creating a book. I haven't been able to find anuthing in the Academy site on that. Thanks in advance

Hi Team, We are creating a template in the input form to enter data. Is there any way to suppress the rows with no value while extracting the same form into the spreadsheet? Also can anybody suggest how to retain the spreadsheet format with multiple refresh?

Hi all, How can I run a batch file from a Workflow within OneStream?

We have added a new dimension and associated transformation rules. Previously this dimension we set to 'None' through a static value text definer from the Data Source.I have removed this and now added the respective transformation rules needed, however when retransforming the data, this new UD is still defaulting and sitting as 'None' Any ideas? Or do we need to remove all the data files themselves and reupload to update the mappings? 

  I can change accounts and entities by scenario, just using scenario views Question Credit: Peter Fugere   Is this statement fact or fiction? Comment your best guess below! Answers will be revealed in one week. * This question is applicable to Platform 7.3.0 and may not be relevant to future releases

Hello,   I have this cube view that I made, in which I am having issues in the secon to last column. I am trying to see what the difference between each quarter is between the forecast and budget scenarios.When I run my cube view, I get a single difference between Q1 forecast and Q1budget only, and Q2 trough Q4 are nowhere to be found. I was expecting that what I typed would give me the difference between each quarter, not just the first.       Can you share what your thoughts on what I am doing wrong please?Your time and input is appreciated in advance!

Is there any way to edit Transformation Rules in Bulk?When I try loading a trx file or xml code into the system it doesn't overwrite the rules which causes issues in someplace.Is there a way or a template where with direct upload I can delete that transformation group and create a new one with the same name. (Example- Dimension delete template where uploading a certain xml file directly deletes some dimension members)Thanks.

Can we use an aggregated UD1 with a dynamic calc member in the Flow dimension across two cubes?  We have dynamically calculated members called ‘AggDetail’ in Flow Dimension with a rule on member formulas which aggregate base UD1 by entity dynamically.  All our base cost centers (UD1) are in the Financial Detail cube in the dimension library and this ‘FinancialDetail’ cube is called out in the dynamic calc rule. However, we have recently added a new sub parent in flow dimension under the “Financial” cube and it seems like this dynamically calculated flow member “AggDetail” is not aggregating the result for this new sub parent from the Financial cube. This is kind of close critical and see if anyone knows how to solve this in OneStream. If you know the solution, please reply to me here as quickly as possible. Thank you

Hi Experts, I am new to OS, I am looking for the format settings, where it should not show the +sign beside the rows. can any one advise - please Thanks in advace,Shivani Y 

Team Am trying to create a dashboard which will have inputs from 3 cube views, of which 2 are Forms. How can i have all the 3 cubes in one page under a dashboard with the flexibility of moving around, resizing the views.  Tried "Grid", "Canvas" and "Uniform", but none had an option to move and resize. Attaching a screenshot as reference.  

Hi ! I'm trying to harmonize the reporting in OneStream with one single font that we use as a standard within all the BU of the company. I can change the font in buttons, label, radio button, text fields ... but I can't find anywhere the possibility to change the font in all graphs / tables that are created in BI Viewer components. --> Is there a way to change the font used in tables/graphs created with BI Viewer ?   Many thanks,

Hi All, Is there a way to integrate OneStream with Hyperion to extract data from Hyperion without user intervention? 

Is it possible to have Superscripts updated on the CubeView Rows, usually used on Statutory Reports ? eg below: "th"

Hello!Is it possible to sort location members in a loop (in a book)  by alphabetical order?  If so, how?  Thanks   Marisol

Originally posted by David Dowling 12/10/2018 Changing existing application to a weekly time profile? Post implementation

Hello,  How Can I have rows that have no data for a time period to display 0 instead of blank in OneStream as well as when exported to Excel. 

A user must upgrade to the latest software version in order to continue using Onestream Question Credit: Nick Hymes   Is this statement fact or fiction? Comment your best guess below! Answers will be revealed in one week. * This question is applicable to Platform 7.3.0 and may not be relevant to future releases

Hello Team, We have IE and Edge browser on the system. Once opened the OneStream application when we do Windows shortcut as per below screenshot it is creating the Windows short cut on the desktop. And, then when we open the OneStream application using the shortcut , it is opening on IE browser. How to create a shortcut for Edge and the application should open on Edge Browser when we use the shortcut. Thank you, Praveen

I am knew to the OneStream Software. Is there a way to load data outside of a form, and not through workflow? Meaning, is there an xf formula that can be used in excel that will write to a specific data intersection?

Hello, Following a recent OneStream reporting course I've discovered the benefits of pivot grids within the BI Viewer component. Is there a way to automatically adjust the width of the first column based on the text in the rows? I can't see anything obvious in the BI Viewer: I was thinking a business rule could work although I can't see much content using these with pivot grids. Any ideas? Many thanks, Oliver