OneStream Platform Forums

Hi ! I came accross the "State Indicator" dashboard component, but I can't seem to find any information about how it's used and how to configure it, either in the online help and on the community. Could you please let me know if someone has already used it and what's the purpose of it ?   Many thanks ! Regads,

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

How do I view the POV of the datacell executing BusinessRule.DashboardStringFunction XFBR business rule?I think I can run this statement:Dim viewMember As ViewMember = ViewMember.GetItem(api.Pov.View.MemberPk.MemberId) BRapi.ErrorLog.LogMessage(si, "view = "  & viewMember.tostring) Is there a faster way to view all 10 dimesions in POV of the datacell ? These do not work: Dim POV As POV = ViewMember.GetItem(api.Pov.MemberPk.MemberId) BRapi.ErrorLog.LogMessage(si, "view = "  & POV.tostring)    

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 ? 

Happy Labor Day for USA. Happy gas shortages, high electric bills and soon coming freezing winters for many of us around the world.I renamed my Cubeview from CV1  to CV2_deleteVersion08302022. Why did my workflows  automatically change its configuration to use new name CV2_deleteVersion08302022? Should it not remain as CV1 ?  I'll try to give a screen shot

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   

Happy Labor Day!!How can I use BusinessRule.DashboardStringFunction, i.e. XFBR string business rules to extract text out of a datacell in cubeview that has users' text stored in V#Annotations?We have successfully used XFBR string business rules to extract amounts from datacell in cubeview. However, when I tried similar lines of XFBR code in my cubeview – I am not able to pull users’ text.It is returning zero. Users are putting text into CV cell that has this combination - A#Explaination:U8#Comment:V#Annotations . Here are a few lines the don’t seem to work1)Dim Explain As DataCell Explain = BRApi.Finance.Data.GetDataCellUsingMemberScript(si, cube,"A#Explaination:U8#Comment:V#Annotations" ).DataCellEx.DataCell2) I tried the next line:Explain = BRApi.Finance.Data.GetDataCellUsingMemberScript(si,"A#Explaination:U8#Comment:V#Annotations" ).DataCellAnnotationbut I get the error message : " Does not recognize .DataCellAnnotation. 1) Error at line 71: 'DataCellAnnotation' is not a member of '

Hello,   I have a Cube View that prompts the user to select the month for the report when it is run.It would be great if it could select the current year's first month by default. I have tried some different things in the Default Value such as WFYear, T#WFyear, |T#WFyear| and others but cannot get the default I need. Does anyone know what the syntax that I am looking for is? Thank you very much for your time and involvement!      

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?

Hello Team I created a Nested member expansion under a cube view. It works fine with grouping of the nested dimensions as in picture#1.  But by default it always have the list grouped. Is there an option to have them all ungrouped by default (pic#2)? Thanks!!

Hello All, It might sound like a simple question but I could not find the code in snippet or elsewhere of how to grab in a rule a list of all groups a user is part of. Could someone share how to do that ? Thank you Matthieu

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?