-
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…
-
Summary parameter "Last" doesnt reflect at higher levels
Hello All, We have data at Weeks which will roll up to Months and further to Quarter, Half Year and Full Year. We have a requirement to show the "Closing Stock" as the Last value. The Data view has all the periods in Row Axis (Not Flattened). We have tagged the Closing Stock block's Summary as Last. The data shows up…
-
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 =…
-
Level 200, Module 207: Data Entry is not working
I am configuring Sale Planning worksheet within Module 207 task. I am adding a Dataview object for Cube BUD - DE - % Increase, and I put Data Entry option = ON, but after applying and saving the configuration, the fields are not coloured yellow, and Data Entry is not allowed in Play Mode. I would like to know, what…
-
API Integration
We were loading the actual data in our application in BOARD with manual files. Now we want to integrate it with ADW Datalake. Please let me know how we could connect the servers with BOARD to fetch the data instead of loading it with text files.
-
B14 214 - GBP Data View Object - not showing PY
In the module B14 214 during the creation of the "GBP Data View Object" (please note the same happens on the "LC Data View Object"), after step 21 this is the expected resultfrom the training is as such: while in my environment here is the actual result (showing the PY column completely empty): for GBP here for LC: I…
-
Unable to calculate Average, Standard Deviation, and Variance for Derived Lead Time Field
I have a dataset with two date fields: Load Date and Delivery Date. I calculate Lead Time as "Delivery date-load date". Now, I need to compute the following statistical measures for this Lead Time:Average (Mean), Standard Deviation,Variance. However, when I try using formulas like Subtotal (sub function code, x,…
-
How to increase the height of the data view table
I need to increase the height of the table, but i am not able to do it , i am just able to increase the column width. Is there any method. Please give me the solution for this.
-
Unable to calculate Average, Standard Deviation, and Variance for Derived Lead Time Field
I have a dataset with two date fields: Load Date and Delivery Date. I calculate Lead Time as "Delivery date-load date". Now, I need to compute the following statistical measures for this Lead Time: Average (Mean), Standard Deviation,Variance. However, when I try using formulas like Subtotal (sub function code, x, y), AVG,…
-
How to create bar chart in Data View
1. Abstract This article describes a specific use case: visualizing a bar chart in a data view object. 2. Context In some projects, it can be asked to render a bar chart in a data view object, to provide an immediate visual representation of the numerical values directly in line with the data. This allows users to more…
-
B12: module 302_Setting up Actual Reporting Months via Data Entry not possible
Hi, in this run of Level 300, Part 1 I face the issue, that it is not possible for me to set the "Actual Reporting Months" via Data Entry in Data View Object. Even if I enable Data Entry the column does not become yellow and clicking the checkbox does not work at all. Any idea how that could happen?
-
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…
-
I am getting two missimg errors in the relationship part
please help me with this, how can i correct this
-
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…