-
Missing alignment of the legend in the cartesian chart
Hi Team, Initially, I have cartesian chart with single data block. Then the alignment is fine. Now due to requirement change I have to add another block despite it is hidden. The alignment of the names is not matching with the icons in the legend. Could anyone please help me to fix this issue. Thanks & Regards, Vanam Pavan…
-
Dynamic File Name based on Entity Member.
Hi Guys, I am exporting a layout to the server, and I need the output file name to be dynamic based on the selected entity member in the procedure. For example: If the Data Category is Entity and the selected member is Actuals, The generated file name should be: Actuals_Report.csv Could anyone guide me on how to achieve…
-
Chart preview behaviour in layout editor
Hi everyone, We are observing a behavior in the layout editor where the automatic update does not take effect in the chart preview. This occurs when changes are made in the data block or under “Filter and Sort,” and can be reproduced in various configurations and screens. Is this behavior already known, or is there a…
-
Is Row Number/Counter Possible in Export DataSet
i am trying to export a report and i want a row number, or else it would be helpful if i can insert the row number/counter values through data reader in etl
-
Quarter to date with detail by, but having one block referencing full quarter.
Hi! The intent of this screen would have been to see what QTD actuals are as of month 2 (february) close. Compare february QTD actuals to february QTD forecast Detail #1 by month Compare full quarter forecast to QTD actuals to then calculate remaining forecast to spend I believe I can do #1 by having two pagers, one for…
-
Need help with Report building, particularly Total By
Hi, I would like to ask for some tips about the best practices with regards to building an archive report. We have an archive cube with the following 6 entities: Month, Reporting Year, Version, Business Area, Currency, PnL. PnL is the biggest one with <200 members, all of the others are <20 members. I have a screen…
-
Introduction to Board: Analysis and Reporting OnDemand
In Module 1 Quick Layout option is not available
-
Unexpected Behaviour: Data Entry with Pattern Base Allocation
Good day everybody! I’m experiencing an unexpected behavior with Pattern Based Allocation (PBA) in a Data View. I’m using PBA to enter a value at an aggregated level into a target cube (initially empty) and allocate it down to a more granular level using another cube with the same structure (driver cube). The issue is that…
-
Unbalanced Heirachy - Loading data into Parent without data in child entity members
Hi Team, We have Unbalanced hierarchy and we want to load the data into parent without data in child. eg: Here we have to load the data into Member 1.3 without data in child members 1.31 and 1.32. Member 1 Member 1.2 Member 1.3 1.31 1.32 Member 1.4 we have tried different ways but if we disabled the unbalanced hierarchy we…
-
Override security when displaying data in a bar graph
Hello, Is there a different way of overriding security other than the "Refer to"? We are trying to display all Business Units in a bar graph which means we need to override the security for all users. This allows them to compare their values to other Business units. Using "Refer to" to show all BUs in a bar graph means…
-
Drill Down layout configuration.
Dear Peers, I hope you all are well. I am working on the Board 14.5 bugs right now. I want to configure the layout which opens when I drill down on a column in data view. There are multiple entities in Axes, I want to make it flatten group to make the view easy to work with. Please help as I am unable to find this option.…
-
Dynamic Header on Dataview
My client using Board 14.2. Is there any possibility to do some Dynamic Header on Data view. Such as, if cube a<30,"XXX","YYY". I tried to put the formula on Header, but the visibility of the Header on Play Mode still the formula itself.
-
Drill Down / Anywhere Configuration Best Practice (Code + Description)
We have a Profit Statement Report that has Reporting Account by row (1st screenshot). It is currently configured to only show Description for this entity, and we do not want to change it to Code + Description for internal reasons. However, we want to give users the ability to drill down / anywhere into the following three…
-
B14: Where to configure which options will be available in the contextual menu in Play mode?
In B12 it was possible to configure which options will be available in the contextual menu in Play mode, but I can't find where its possible to do in B14. See the picture how it used to look like in B12.
-
Report design Ideas to have 2 nested entities on rows with outer entity have calculted measures
I have a question about a report structure and would appreciate any ideas to achieve it. There are 2 entities - Measures & Channel Measures have the following members - The last 2 AOV members are calculated using formulae achieved through rules Weight Volume Revenue AvgOrderVal/Order = Revenue/Vol AvgOrderVal/kg =…
-
Use Entity in Algorithm - Entity showing the count of members not the value
Hello, How can I get the value of Custom A Entity so I can use it in my Algorithm? Currently, I am adding it as a data block in the layout but it's showing the total members not the value. The by row has 4 Entities - Reporting Unit, Custom A, Group Account, and Comment. I need Custom A for my algorithm but when I add it as…
-
Board taking so much time for export text cubes and large size mdb cubes , is there any way ?
Board 14.4 is taking almost 2 hrs for extracting a text or large size mdb cube . Is there any way that i can make extract faster. I have tried using extract cube and dataset both , i didnot found a solution yet.
-
Exporting Quick Layout charts or showing the Chart Data
Hi, is there a none issue exporting charts with an adjusted Layout - through quick layout? It gives me always the dimensions of the original setup. I changed the chart axis from months to quarter however the Data chart is still considered with the setup axis - month Br,MAik
-
Flex Grid
Hi, When I hide block D and E i am receiving the issue message: I didn't configure anything by column. I am not sure what it actually means. Any thoughts? Btw. Is there a way to add Tags? I can imagine it is beneficial for others when searching for Flexgrid in the community - but it doesn't exists. Thanks, Maik