OneStream Platform Forums

Hi, I have a u8#memberformula that I am trying to use for the first time - to format the background color of a cell. I know that setting  BackgroundColor = pink will cause the cell to turn pink. BackgroundColor = u8#memberfomula my u8#memberformula has only one line: Return "pink"  For unknown reason, 1S is not formating my cells pink ??(I assume the text "pink" is returned by u8#formula) I know my formula is executed by 1S because I put a debug statement in there and it is showing in Error Log that my formula is executed .  

Hi allis there a way to disable the "Create Journal" button  (red)and keep the ""Create Journal using selected template" button (green) I would like to force users to select specific templates where the entity selection is limited to the E#Root.WFProfileEntities So that users cannot make mistakes posting a journal on an entity which is not part of the workflow. Thanks in advance for the help.Marcello  

Hi All, I'm hoping someone can help. I'm trying to create a formula for a planning solution that calculates an average over a dynamic number of time periods but for hundreds of intersections. So essentially I somehow need a data buffer covering multiple time periods that I can then use in my over arching planning formula. The main thought was to loop through the time periods, which is fine, but I can't use an api.data.getdatacell because of the volume of intersections I want to calculate the average for. Is it possible to build up a data buffer in a loop? If only i could create a V#TrailingXmonthavg  formula where I can replace the X with a dynamic value. Any thoughts would be greatly appreciated. Many thanks in advance.

You will get this error during the import step. Reason - The load file doesnt have any data after transformation.( ByPass).  The underlying code looks to summarize the data when it finds nothing, it throws an error.

Hi, I have a number of files in my export folder that were created using a Data-Management step. However, even though I have system admin rights , the option to delete any or all files is 'greyed out'. So, how do I delete them when I have finished downloading them. Also, how do I then delete the 'date' folder as well ?   Thanks Mark

Hello everyone,  Hopefully someone might help . i am trying to create a cube view that will display GL Accounts having specific FLOW criteria . on the rows the i have GL and the columns contain the FLOWS. i have multiple flows configured but each GL has one FLOW. how can i display the Flow constraint that is configured on the GL account ? 

Hi All, I'm in this sort of dilemma, where my book prints the report over 2 pages, while my CV pdf print on one page.I'm wondering if there is a way to fit all on one page.  Thanks   

Hi All,How do I extract all the RCM account inventory to an excel csv file? I'm able to export page by page, but wondering if there is a quicker way to export all 10-15 pages. 

I can use Table Views in the Excel Add-In. Question Credit: Noemi Nagy   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

I want to display Asset, Liability and Income statement side by side in cube view report. Can anyone suggest the format to get this kind of formatting  Tried using dashboard by creating three cube views and attaching them to single dashboard but that was not the feasible outcome

Hi all, I have a cube view that is generated entirely by dynamic UD8 members, some retrieving text fields, returning static text/numerical data, parsing descriptions, etc. I would like to export this cube view as a .csv but I am struggling to find the best way to do this. I don't think DM Export Data jobs work with dynamic UD8s, but maybe I'm missing something. Is there a recommended method I should consider?

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?

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,

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. 

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?