-
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…
-
Is there a way to change the default path for files exported from Board?
Each file (pdf, excel) exported from Board go into a user's downloads folder. I would like to configure the export path to a different folder which I can then build trust center policies around. This would support our ops team that has to download dozens of reports during ME close and has to enable editing on all exported…
-
How to use "Export data view to file" function in to export data view layout on server.
Hi Guys, I am using "Export data view to file" to export the layout on server but getting error. Can you please help me to solve the issue.
-
Level 300 Module 306 Functional Test 2
Hi, I’m currently facing an issue with Level 300 – Module 306 Functional Test 2. I have completed and verified all the requirements; however, the system is still not accepting my results. Could someone please assist me in identifying what might be going wrong? Thank you for your support.
-
Level 300, Module 303: Functional Test Question 2
Hello Everyonce can anybody help as I am unable to find answer of this as whenever I am trying to run Apply 5 % increase action ,I am not able to see any message on screen.what will be the root cause.? And what is the correct answer.?
-
Level 300, Module 309: The Approve button doesn't trigger anything #Level309: Workflow
Hello, I try to Approve during the QA of Workflow. When I double click, nothing appears, no trigger. But when I refreh the page, I see that it worked. I am supposed to see a message and confirm or not the approval. i checked my procedures and don't know what is wrong. Anyone encounters this issue during developing ? Thank…
-
P&L - Hierarchy of P&L Group, P&L Position and Account
Hello,m I’m working with a rule on the “P&L Group” entity and want to show the full account hierarchy in a Data View. Setup / requirement Entities / hierarchy for account: Account → P&L Position → P&L Group In the Data View I can pull in the cube and activate the rule on P&L Group. With only the P&L Group level in the…
-
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.
-
Level 200, Module 204: Initialize Budget button does not work ? #Level 200: Building a Plannin
Hello, I built an Initialize Budget procedures for sales and it works. I Then updated the same procedures in order to initialize Sales and expenses budget, but when I click on the button, it only initialize Sales Budget data view. To Initialize Expenses budget, I had to create a new Initialize budget button in Expenses…
-
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…
-
Call Procedure- Unable to open capsule procedure
Hi Team, we have call procedure step in open trigger procedure. while running this procedure we have faced issue it is showing error "Cannot load the procedure try to open the procedure with the editor and save it again" and when we try to open procedure it is continuously loading. Not only this procedure few other…
-
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 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…
-
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,…
-
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…