Reporting

Hi,Has anyone else encountered an issue where external links are appearing in user files? A few users claim that the original file did not contain any of these links. The users break the links and save the file only to have the links show up again when the file is opened again. These links also only appear for OneStream connect Excel files. Normal excel files do not seem to have this issue.Thanks!OneStream version 7.2.4 

Hello,I'm trying to create a 5 quarter bar chart trend in BI Viewer, but I can't get the time dimension to properly display the columns in the correct time order, it keeps defaulting to alphabetical (ie Q4 2022, Q3 2022, Q2 2023, Q2 2022, Q1 2023).  Does anyone know how to fix or adjust for this?Thank you!

Hello Experts,I am trying to pass cube bound parameters to a BR to do something with it. I can read all parameter except Cube Name. For some reason it is blank. Anyone came across this issue?  Cube Definition:Reading in BR as below:Dim CubeName As String = args.NameValuePairs("DrilledCube")brapi.ErrorLog.LogMessage(si, "DrilledCube:- "+CubeName)

Dear Community, I have a requirement to apply conditional formatting for a parent member which has it's children members underneath it (eg., A#Cash.ChildrenInclusive). So, when I apply formatting, it automatically applies for it's children member too. Here, I have applied "ExcelTopBorder" cell formatting for the parent member and it got applied to all the children members too. 

I am using powerpoint xfdoc to pull CV using alt text. This cube view had 3 parameters, each with 2 or 3 values. The ask is to pull each combination of those parameter on a different slide of the ppt. Is there a way to achieve that outside of report books loop feature where I can only export it as pdf?

Hi,We are trying to Display User Time when we export the report to excel on Excel Header. We tried using this code, but it is giving us the UTC Time.If args.FunctionName.XFEqualsIgnoreCase("DateandTime") ThenDim localTime As DateTime = DateTime.UtcNowDim timeZone As TimeZone = TimeZone.CurrentTimeZonelocalTime = timeZone.ToLocalTime(localTime)Dim formattedTime As String = localTime.ToString("yyyy-MM-dd HH:mm:ss")Return formattedTime End If Is there any way to display the User specific Time?Thank you  

Hi, sorry I always get a bit confused on how to use parameters in data management sequences/steps.I have a dashboard with: a combo-box that let users select an Entity member; a cube-view which Pov is based on the combo-box selection; a button which runs a data management sequence.The combo-box bound parameter uses a member list.The data management sequence contains only one step, which is a custom calculate.I would like the data management step to run on the selected Entity member (the one selected in the combo-box). How do I link the Entity of the data management step to the selected Entity member?With the current Entity filter setup in the data management step:- I can run the step from Application/Data management page and I am prompted to select an Entity. No issue in this case.- I receive an error if running the data management sequence from the dashboard (Summary: Error processing Data Management Step 'Plan_Growth_Adjs'. Invalid parameter. Entity Filter, |!prm_plan_bu_entity!|.)&nb

Hello Team!I am trying to save a spreadsheet file using the native "Save As Application Dashboard File" button.    I am running OS 7.4.2 but also tried on 7.4.1.It seems that it is only possible to save in a DEFAULT workspace on both OS version. Could someone confirm that? Now, if you save in a DEFAULT workspace under a specific Dashboard, I would like to know where is this file saved. I tried to extract the dashboard where I saved the file but nothing shows in the XML. So how do we extract it and where is it saved? I can see it in the Database under DashboardFileResource, but not under this Dashboard Files. Thanks  

Guys, there is a requirement where we have to use a single template for all the 5 forms in  a workflow and depending on which form the user selects the rows and columns should generate dynamically . Is there any way we can get the Selected Form name in a BR. Or Is there any other solution for this Problem?  Thanks a Lot.

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

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!  

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

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.  

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?

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

The Formula for Calculation Drill Down will impact consolidation performance. Question Credit: Jack Lacava Is this statement fact or fiction? Comment your best guess below! Answers will be revealed in two weeks. * This question is applicable to Platform 7.3.0 and may not be relevant to future releases

I have a Dashboard with 2 Cube views that have the same columns and when they are on set to a grid on  a dashboard, you have to scroll on them separately to go see data on the right. When I put them in a vertical stack panel, they have one scroll bar but when you scroll to right you lose the row names. When trying to put them in one Cube View, if you scroll down you lose the top part which is basically the totals summary. Is there any way to freeze pane data explorer in  a cube view or freeze pane on a vertical stack panel so when you scroll right the row names stay on the page?

How to sort members from smallest to largest and vice versa based on amount using business rules??

can cube view display with dash (-) instead of empty for No data cells in Excel

We recently upgraded to version 7.3.3 and did a push for the Excel Addin upgrade.  Does anyone know if there is a report to show which users have installed the upgrade (outside of our IT Department).