Reporting

Why doesn’t the report list the by month activity for entities 44, 87, & 55 from Feb to Sep? It does so for #77. YTD ties because Sept is the catchup month.Parent Entity 56 (Children Entities: 44, 55, 77, & 87) Child Entity #77 Only Child Entity #44

Hi Team.We have a dashboard filled with cube views and also labels inside it where we are retrieving some values fromthe SQL table. Is there any option to get a printout in pdf format of the dashboard using extender rules ?   

Hi Team,I'm wondering if it's possible to create a dashboard with a list of all entities to select specific entities to certify.I would need there a tick marks ("Allow Multiselect" from Grid View settings might work) and make 2 nice buttons for "Certify" and "Revert Certification", would you think this might work?Thanks!  

Hi Everyone, I am creating an input form in CV and needs to pull IC entities which the entities are in use and have a specific name in Text 1. When I tried to use I#ICEntities.base, I got all entities including the ones that are no longer in use. When I tried to use I#ICEntities.base.Where((InUse = True) and (Text1 = SalesEntity)), no entity found for the query. Please let me know how to make this work.  Thanks!

I have a cube view that I have a spacer columns in. I would like to keep these columns but need their width narrowed when I export it the CV to a report.Here is what it currently looks like when I run the cube view:The spacers here are perfect.But here is what it looks like when I export to a report:The spacers revert back to full width. Is there a way to get them not to do this? Additionally, is there a way to get rid of the dashes in the title rows? It is set to an intersection that will never have data so I could have a clean title row in the CV, but shows the dashes like this when I export it as a report. Really looking for how best I can control/adjust the formatting of any CV I generate into a report. TIA!

Hello All,I have a reporting requirement, where I need to introduce an empty row between two Sub-Business units. These business hierarchies are displayed using .Tree expansion. In between the Tree hierarchies is it possible to introduce “Blank Rows”. Please let me know. Thank you.

Hey All,Looking into a case to get None entity member to appear for IC Matching. Are there any way to get None in IC Dimension to be listed under ICEntities? 

Hello everyone,  We have a few dashboard chart questions.  1. Waterfall chart Does anyone know if there are ways to change the data label text and background color? For example, change all the data labels to black text and remove all the red, green, and blue background colors. 2. Bar/Stacked Bar chart  Is there a way to make the data label within the bar more readable? For example, have the data label in text color black with a white background.    Any tips or advice are much appreciated!  

Hello, I would like to use the text 8 attributes that vary by time and scenario to show that an entity can move from a group A to a group B. I am using the UD8 dimension to do this, where all data are set in "None". This is working fine for base member entity. However, in my report nothing happens for parents : As soon as I look for the parent, all data are invariably reported on the "None" member, even though both parent and child entities are set with the same Text8 attribute. Am I missing something ?   Regards,

Hi, I have a CubeView with UD1 on column and account on rows.I have a setting for columns "Use to determine Row suppression". I cant find this option on Rows.I want column to expand if there is data in Row 1-2, but for Row3 I only want to show data IF there is data in Row 1-2. Row 3 will always have data for all UD1 members (column) but I only want to show it if there is data in Row1-2. So column suppression/expansion should only be based on Row 1-2. Is this possible to do in OneStream? 

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 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  

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  

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

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.

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

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?

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