-
level 200-204 creating the 2nd dataview
Hi, I created the 1st dataview ( for units) in the tab object and am now supposed to create the Sales$ data view in the same tab object it seems, but I cannot drag the dataview onto the first view shown and if I drop it below I get errors saying object has no screen associated? How do I get the 2nd view onto this screen?…
-
level 200- data reader load - discarded items
I ran the data loaders and got 2 disc items under Location. I then ran 'Analyze' under Relationships and found a lot of errors re: missing parents/children…I fixed some manually but now sure how to fix some such as: how do i resolve these missed mappings? Thanks, Andrew
-
Level 200 - Module 203: Board training environment - Blank home page nothing is displayed
Hello, When connecting to the Board training environment for the first time, I did not find any button or link to click on it to start the activities related to Level 200 (please see the screenshot below) Could anyone help me please!
-
Level 200: Building a Planning Solution in Board | Accidentally deleted 'home mask'
Hello Academy community, I accidentally deleted the 'home mask' while in design mode. Is there a way to copy it from another instance? Thanks in advance.
-
Level 200- mod 204 ..unable to map fields
Hi all, I got up to setting the Source path and file but when I go to Mapping I can only drag 'Product' to the Destination filed area…I tried Product Group and Product Category but they don't come over to the Destination column …so I can't map to the source fields? Maybe I am doing something wrong? Any help is appreciated……
-
Level 200 Module 210 why the data won't populate when i select the country UK in exp planning scree?
-
Is there an Excel Add-in Data Entry training manual or video?
Does anyone have a video or training document on how to use the Excel Add In Data entry feature? I'm trying to load budgets to BFC and would prefer to use Excel rather than flat load files.
-
Level 200, module 212: Running the Update P&L Procedure
Dear, My P&L Data view isn't populating when I press the Update P&L button. I checked all the instructions twice and can't seem to find a mistake. I played around a bit with a data view object of the BUD - DF - Profit and Loss Statement GBP cube to find out where the problem lies. It seems like the problem lies with adding…
-
Level 200 Module 205: Issue with final totals.
Hi, I am having issues with my final totals with the sales actual report. The values are away off the from what is shown on the course yet the percentages are an exact match. I have rebuild the procedures and report several times and am still getting the same numbers. After inspecting the cubes after the data is published…
-
Level 200, module 204: All my numbers are double those of the screenshots in the course
Dear, After setting up the Data View configurations for the Sales and Units data, all my numbers are double those of the screenshots in the course? For example The units for the product "Bangle" in Feb 21 are two on my screen while they are one on the screenshot. Is there anyone that has an idea where the problem could…
-
Level 200, Module 210: Expense Planning Screen
The data in the data table disappears after applying the default Screen selection for Country = "UK - United Kingdom." Data will populate when the default Screen selections are set for Year and Currency per the instructions. I've checked the Cube and procedures and they match the instructions in this module. My only…
-
Level 200 Module 211 Functional Test
The labels are not appearing on the Budget Initialization screen during the functional test. I have checked the configuration and do see both the 'Initialize Budget' and 'Budget is Locked' labels. Any idea?
-
Level 200 Module 205 - Can't enter FX Rates
I am trying to enter FX Rates on the FX Rates screen but I see no data entry fields. I did enable 'Data Entry'.
-
Level 200, Module 205: Procedure ACT Sales Data Upload not in the Procedure dropdown option
I created the procedure ACT - Sales Data Upload but it is not in the procedure dropdown when I created the Call DB Procedure. It is grayed out. What did I miss?
-
Level 200 - Training Env not loading
Anyone can help with this issue? My training environment doesn't seem to load today. It was fine until yesterday.
-
Level 200 Module 209 - Timestamp Instructions Incorrect
I ran into issues for both the upload and publish timestamps in the Expense training. The training says: - set expression to "@Date&" at "&@Time&" by "&@User" You need to remove the quote at the beginning and end of the phrase to make it work: - set expression to @Date&" at "&@Time&" by "&@User
-
Level 200; Module 205; final check is not balancing
Upon the final check of data, everything lines up well, except for the GBP Sales Actuals Data screen. I have walked through the module and rebuilt the entire procedure and data view several times, however am getting the same results. The GBP report doesn't appear the same as the LC report in the numerical presentation. The…
-
Level 200 module 212 - 1: Product to GL Account Mapping Cube Empty
Am I missing a data reader where we'd load Product Category & Account through a data reader? I would think it would just pull in the values, matrixed, and let me check yes/no. I'm prepared to feel dumb on this one! But I built the screens and don't see any 'box' to check for that single value cube in step 3.2 Thanks! Matt
-
Module 205 in Level 200 Building a Planning Solution in Board
Has anyone else picked up on this issue below in module 205 of Level 200? In the Academy, module 205 there seems to be a fault. The “ACT – Sales Data Publish” procedure where it calculates ACT – DF – Sales GBP, does not calculate as per the screenshot. In order to make the data flow work properly I needed to split it into…
-
Level 200 Module 204
Was not able see the File While Creating the Date Readers
-
211 Expense Planning - 18 - step 4
Step 4 algorithm has "b=1", but the screenshot image has "A=1" Add an "Algorithm" as data block "c", set the "Column algorithm" to "if(b=1,"Locked","Unlocked")", set the "Heading" to "Status", and change the "Algorithm type" to "Text".
-
Level 200 module 209 - click here if you're stuck!
I wanted to leave a trail of bread crumbs for those of you working through this and having the same issue (that all 3 people on my team experienced) in step 1 of the confirmation exercises. 1.) When you define your relationships for Account etc. make sure you save changes (top left corner) or the relationships will not…
-
Level 200: All CSV File
Hi All, I've finished the level 200 course. in order to better understand the logic behind the model is it possible to have all input CSV? Thank's in advance, Best Regards Edoardo
-
Unable to Create a Cube or Go to the Relationships tab
Hi Team, One of the Partner Consultant had started with the Level 200 Course and he is facing issues while working in the trainingacademy board instance since last evening. He is unable to create any Cube nor go into the Relationships tab - Attached are screen shots received for reference.
-
Level 200 Module 207: Build a Data Model and Capsule Procedure to increase the CY budget by 5%
I might have missed it, but I think the instructions are missing the part where you should multiply py actual * 1.05 to get current year budget with 5% increase. In Level 200 207 shouldn't this have Set Expression to a*1.05? In the "MAIN" group, create a "Data flow" step, in "CONFIGURE LAYOUT" use "ACT - DF - Sales LC" as…
-
Level 200: Module 206 Copy PY Actuals to CY Budget
Hi there, I am having issues with my procedures to load CY Budget from the PY Actuals. The capsule procedure begins successfully, and can see it actions the data model procedure as the timestamp updates. However, the data flow step in the Data Model procedure does not appear to run successfully, and I do not get the…
-
Level 200 training - Is it possible to please resurrect my training environment?
-
Board Academy Level 200 training environment setup error
I am getting the following error when trying to setup the Board Training Environment for the Board Academy Level 200: Selected user account does not exist in tenant 'BOARD' and cannot access the application '93cb9be1-06ac-46e9-8cb6-ef5235d40859' in that tenant. The account needs to be added as an external user in the…
-
Dataflow mode question (206)
hi - I am working through the L200 course. In 206 / Knowledge Check, there is the question: "What is the purpose of the clear cube step of the BUD - Initialise Budget Procedure?". The course's own correct answer is "The mapping mode on the Cube is set to ADD, which will cause the data to increase each time the procedure is…
-
Level 200, Module 205: Sales Planning Procedure
Level 200, Module 205: Sales Planning Procedure ACT - Sales Data Load Data Model Procedure Step: 4 Select "CALCULATION DOMAIN" and in the Extend calculation on new tuple for all members of section, select: "Country" and "Timestamp". Why are we extending the calculation? I am aware that it will open the dense cube dimension…