-
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…
-
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…
-
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.
-
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…
-
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…
-
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
-
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
-
Selection by a cube
Hi, I have a screen selection by a cube. When I do another selection on the same hierarchy / relationship it removes the cube selection. Hotel is part of a country I select through a cube all active hotels. When I now select only some countries it shows inactive and active hotels because the cube selection has been…
-
Advanced Smart Import
1. ABSTRACT The Smart Import object facilitates the upload of data (master data, transactional data) to Board. Before, Dataviews with line number entities or CSV blob cubes with export/import procedures were required to upload the data. In addition, a complex check logic (if implemented at all) was required to detect wrong…
-
Level 200 part 204
Hello, when I go to Select the "Initialize Budget" label in play mode on the "Sales Planning" Screen to run the Procedure to initialize the budget, the Variance and Variance % columns are not valued in 0 and I don't understand why. I attach the "Sales Planning" screen, the related Selectors and procedure . Thankyou for…
-
Level300_Module304: Functional test, Question no 3, Values fall apart starting Aug '23
There was an error rendering this rich post.
-
In RTF cubes table boarder not working
Hi team, We’re facing an issue with extracting specific RTF data in table format — the table borders aren’t being captured, even when we paste the content. Will the latest version include support for extracting tables (with borders) from RTF cubes? or any workaround?
-
dataview algorithm block: how to set summary mode to 'no total'?
Hello, I am wondering how to hide the total value in a dataview for a block of type algorithm. This is actually possible for a block of type cube: but i don't see it for a block of type algorithm: Do i oversee some options in the block settings within the layout window ? as a workaround, i play with foreground and…
-
Level 200: Module 216: I am not able to scroll down and view the net income, total expenses
I have got all the functional test right but at the end I am not able to view the Net income, Total Expenses and other details. Is there any wrong in my P and L rules, I have attached my P and L rule also