Dataview

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…

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

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.

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…

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…

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.

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 =…

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…

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.

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…

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,…

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,…

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…

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?

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…

please help me with this, how can i correct this

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…

We were very happy that Board 14.4 finally introduced the dynamic heading feature... But why is this feature only available for DataViews? It also dosen't work on DataViews aligned horizontaly?? i expected here to see the current selected year: even if set to alignment horizontal its not showing the year…