OneStream Platform Forums

How to get timeDim ie months in reverse starting with curr month followed by prev months? in columns

I am trying to get the Text1 field value using a Business Rule and put this value in a cube view that is being used as Form. Does anyone have done this before? Is it possible to get the Text1 value from the Workflow Profile using BRApi? Thanks for the help.  

Hello,I am building a Quick View with the columns Account, Flow and UD5 - for UD5 I want "TG304" for all rows other than when the flow is "MVTCALC".  Is it possible to have this level of variance in the QV?Thank you!

Hi all, Is it possible to format the top row of an expansion different from the expansion details in a cube view if they are the same line on the CV set up? For example, I would like the formatting to have the Total Product line bold with the details under it not bold and with only one expansion at Total Product. It seems the only way I can do that is to have one row in the CV set up for Total Product formatted one way and a separate line below for the details formatted another way (result in screenshot above). The problem is then my expansion isn't really where it should be and the first detail line (Branded Pharm) will always show.I can't figure out a way to do this but if it's possible, please let me know!  

Hi - Is there an BRAPI to get the current form name from WF Profile ? I was able to get the list of Forms using the below code but I looking for when a user select the form it should return. Let me know if there any BRAPI functions  Thanks  Dim objBRApiForms As XFFormsForWorkflow = BRApi.Forms.Metadata.GetForms(si,si.WorkflowClusterPk) 'Get the List of Required Forms Dim listfrm As List (Of XFFormSummaryInfo) = objBRApiForms.OptionalForms 

Has anyone gained experience with the 'org-by-period' consolidation in a multi-cube application?We are currently addressing changes in organizational structure. Specifically, we need to consolidate one of the entities within a single cube up to month 10 and in a different cube thereafter. We have a primary cube and several segment cubes that roll up into it, utilizing the extended Entity dimension.The initial challenge I'm encountering is related to adding the entity to a different cube hierarchy. Does anyone have insight into how to resolve this?Once the entity is added to the second hierarchy, I plan to update the Consolidation Algorithm to 'Org-By-Period Elimination,' set 'Percent consolidation' in both hierarchies, and change the consolidation view to 'Periodic.' I would greatly appreciate any insights on how to resolve the existing error and what to expect or pay attention to in the next steps.

Hello,Is there a way to give access to a user to modify a specific member on the metadata (specific scenario) without assigning them to the group of manage metadata ?thanks,

All of a sudden today all our users are not able to select scenario (Main Scenario) in the Quick View report and it shows only Target Scenario which is not relevant, need help here please.

How are parameters organized within a DMU? I refuse to believe they're placed in a random order once created. They're not sorted in alphabetical order or by Parameter Type—then how?

Hello,I want to create a QuickView which shows all BS accounts which have a FlowConstraint which isn't "MVT_GEN" but can't figure out how to set it up. I have used the following:A#BS.Base:Name(XFMemberProperty(DimType=Account, Member=|MFAccount|, Property=FlowConstraint)And this returns the whole BS but with the flow constraint instead of the name, but this is not what I'm after!Thanks a lot

Hello Team,I am trying to extract Dashboard specific items using the ExtractDashboardsXml.I can only make it work when I use the Options ExtractAllItems = True.I am running OS 7.4.2I can not find any information on this formula. I would like to have an example on how we should the extractItems. Can you please provide an example? Especially on what is expected in the extractItems. ExtractDashboardsXml(_ ByVal si As SessionInfo, _ ByVal isSystemLevel As Boolean, _ ByVal options As XmlExtractOptions, _ ByVal extractItems As Dictionary(Of XmlExtractItemPk, Boolean) _ )   Thanks!

In the application I'm building, I have a need to make several insert/update/deletes for different custom tables, but the database call for those changes should happen within a transaction. Are there any OneStream API functions that will include the ability to run the database call as a transaction? I could just use the .NET Framework approach (SqlCommand), but then I'm a bit off the track.Cheers, Frank

Is there a setting on the component or even a business rule that allows you to uncheck/unselect/reset a combo box to its original state? I would like it to reset and check the top member or a default member. I don't want all parameters on my dashboard reset just a specific combo box with the click of a button.

Is it feasible to implement extensibility to an account dimension with data loaded?Currently, all base and parent accounts sit in the same TopAccounts dimension. No extensibility was configured initially, so the idea is to keep the base members in the same dimension while separating all parent level accounts into an intermediary dimension (AccountSummary) between Root and TopAccounts.Before:After:We were able to separate them out via XML manipulation, and the extensibility looks good within the hierarchy:  It also seems to be correct based on the Extensibility solution:Additionally, since the base accounts are unchanged, we did not edit the primary cube dimensions.However, the data isn't as expected. For example, in our test QuickView, if you call a parent-level member in a member formula and do a .base expansion, it doesn't display the base members under the parent member.If you call out specific base members , data populates as expected. If you call out parent mem

Is it possible to pass a bound/delimited list parameter or an XFBR through a dynamic calc? I know you can pass a literal parameter through the calc but was wondering if anyone has passed through another kind of parameter?

Hi We are creating a book that loops over an excel export item to create multiple tabs (see below):Is there any way to add a named range around each exported cube view?Thanks,Mark

A client is asking to format the Report title header. They are making use of the "Export to Excel" button within a CV.  The title via "Export to Excel" button in Excel is always the middle. Is it possible to format this for instance make it bold, left right etc? I have tried to format this via Cv Extender etc. Also via pageCaption etc. no luck there either.Of course you can go via de "Show Report" button and Preview - Export xls. But the client wants it formatted by the "Export to Excel" button.  

Does anybody know if there is a dashboard that shows the Workflow Statuses for all workflows. Like the right click on workflow Status & Assigned Entities.

HiIs it possible to treat a dash/hyphen as a zero during a data import from a file?Thanks,Mark

Is there a way to make a column smaller then 1? I have a blank column to separate days out as like a border for data explorer but this seems to be to wide. I know another option is to highlight the last column in that section but we have hidden cells that may appear and I was trying to avoid writing a code for what should be simple formatting issue  

Is it possible to suppress/hide rows based on the cell amount? I have tried to use the isrowvisible on the cell format on the row but it doesn't seem to work. It looks like you can only hide rows/columns based on header format?

Hello,Struggling today with a simple input form. For any entity I can write data, but not for 1 exception. I tried in workflow, or separate cubeview with varying dimensions which all worked before.Also for the same entity in other scenarios with a different scenario type I can write data.Authorization seems not the issue, after changing to Everyone it still shows as read only.Could something block the entity for input in a scenario?Thanks in advance for your any help! 

Good afternoonI'm writing an extender rule to move some files within the application database file system and am using the following line of codeDim xffProcessData As New XFFile(xfiTargetDataInfo, String.Empty, xfeSource.XFFile.ContentFileBytes)I've highlighted the parameter that I am querying - if I hover over XFFile it says it is "xmldata As String". The process works fine in the example given, but I am curious what could be used in that xmldata parameter - what is it?Thank you!Craig

Hello all, My client recently upgraded to the most recent version of OneStream. Previously when loading data, the first line on the Load tab would show the total of bypassed records. We've noticed since the update, this no longer shows. Is it possible to turn this back on?Before:After:  

Hi all,I am trying to find a way to set up a member filter where the member's text 1 field contains the name of an entity.My CV row setup is as follows:E#MyParent.base     U1#MyU1Parent.base.where(Text1 contains xxxxxxx)in the above example, xxxxxxx should be the name of the current entity.So basically this CV should go through all the base entities and for each Entity, the U1 member(s) that display should only be those whose Text1 field contains the name of the particular entity.There must be a way to do this.  The concept is simple.  We use a lot of where() clauses here in our CVs but no matter what I try (i.e. where(Text1 contains |MFEntity|), where(Text1 contains |CVEntity|)); nothing seems to give that result.  It either completely ignores the where clause and just returns all of the U1 member regardless or it defaults to the total U1 parent.This CV works perfectly if I select a single entity and ask for all of the U1 base members whose text1 field co