Reporting

Kinda of a silly question  I was building a cubeview and was trying to adjust the expansion on the layout.  It was set to default view, which got me to wondering where are these default selections set.  I first looked through the documentation, then remembered this is OneStream and this wouldn't be in any documentation.    I know we can set all this up in templates but are these defaults stored someplace else that we can set them?   Oh and I am not talking about the ones in the Application Properties.

I would truly appreciate any help you can provide in eliminating the blank rows in this pdf version below. These blank rows appear after my header, after all the current asset accounts, and again after total assets. Thank you. 

Hi all, I am building a dashboard that will be used by the Statutory Reporting team with 4 high level Group Balance Sheet checks (including BS = $0.00, IC = $0.00 etc etc). The users want to see a snapshot of the checks on the main dashboard . I have created these (Screenshot 1 with placeholders in there) using Cards in BI viewer and leveraging off the Cube View MD data adapter. They also want to be able to drill into the card to bring up the cube view to further review any balances. I was hoping the Card could be used as a button to open the cube view, but I can't seem to find a way to do that. Is it possible? If not, what are the best options to show checks like below with one specific number so that it shows as button?My second query, is in relation to showing the filtering the data in the BI viewer. The cards above link to a cube view which has rows as E#TotGroup.base and columns as C#Local,AUD,EUR,USD,NZD. The card itself only needs to show E#TotGroup and C#Local. How ca

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?