Reporting

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

Hi, is it possible to give someone access to the FileShare folder in OnePlace, without giving access to the System tab (from where, using File Explorer, it is possible to browse to the FileShare folder)?Thank you 

Hello,I was curious if anyone knows a way to get their Quick View in Excel to breakout the hierarchies on the row dimension so that it would separate the parent and children by column and not just have it indented?Instead of this:I want this: Thank you.  

Hi,The request is that when showing base level members, every other row should have a dashed underline. However, there are two issues why we can't achieve this via the formatting editor:1. The bottom line won't render when it has the condition (is rowNumberEven).2. Don't have the option to select a dashed under line (how you can for the excel formatting settings) Can we achieve this through Cube View Extender Rules?? Thank You.

Hi everyone,I have created a waterfall as below using the advanced chart component. Is there a way to change the font size/color for the data labels within the waterfall bars? I cannot seem to find this option. The request is to make the text more readible.Any help is highly appreciated!BR,Floris 

Is there any way to stipulate the Cube whilst building a Quick View without selecting that Cube on the user's default POV? I've tried typing Cb#CubeName in the cell in Excel but when I create the Quick View it ignores this and uses the default POV Cube. In the example I have tried to create QuickView for RETLWRK cube but POV default of MAINREP has been used to I need to change the Quick View cube in the Context Pane after creating the Quick View.  

Hello Everyone ,We have requirement to keep  the indentation level to specific number using cube view extender rule for Pdf report.It looks like : CV Extender rule  that checks, if Col Header Name StartsWith 'ABC' or 'XYZ' then,Set Row Indent to 'Some number 'Any Answers for the above issue would be of great help .Thank you

Hi dear contributors / members,I am trying to format the Cube View cells to final value divided by 1000.I have setup Scale = 3 for all rows and all columns, however the divided value appears only for the first column.Any suggestions please?    Thanks in advance.Kind regards,Irina

I am creating a cube view to use for a form template. The first column brings in data from a set of account members using A#xxxx.Base as the member filter for the row. On the second column I want to allow input from the user. So, on that same row I am trying to use column overrides to achieve that but having issues:Using A#yyyy.Base as the member filter for the column override doesn't actually allow the cell to be editable. Using the base members in a list for the member filter allows input on each cell, but automatically fills in the rest of the column cells with the same number and upon checking a QV only sends data to the first member in the list. Can modify data is set to "True" for both the column and the row.My question is - do I need to break this out and create a line for each member with the corresponding column override member or is there another way to do this?  

Hey,We have a Pivot in the BI viewer with 3 rows say Row 1,Row 2,Row 3 and we want the sum of Row 1 and Row 2 as Grand total. Today when we try to do this, we get the sum off all 3 Rows.Is it possible to archive this in BI Viewer? 

Hi,Report Title is hidden in CV Extender but can it be collapsed?Using above code it is hiding Report Title, But it is consuming too much space, Is there any way to Remove / Collapse / Eliminate CubeView Report Title using CubeView Extender Rules. Any solutions would be Helpful.Thank you

Hello,We are having this below requirement, where we trying to achieve this using Cube View extender rules.Rule should vary margin depending if it's landscape or portrait.If Landscape, thenRight and Left should be 0.25, Top should be 0.75, and Bottom 0.5Else If Portrait, then Left should be 0.75, Right should be 0.25 with Top and Bottom 0.5  Any help or suggestion will be of great help!Thanks in advance.

Is there a way to move the company logo to the right header side of reports? I have applied a business rule to move the report title on the left but now it is hidden behind the company logo.  TYIA!

Hi , We are trying to achieve the below format of Date ,Time and Time Zone in Cube View report footer 25/08/2023 5:00:00PM CT/IST/ET  Here, time zone should vary according to user's local timing.Any solutions on this are greatly appreciated.Thanks