level 200 - module 203 - Build a Screen to visualize the loaded actuals data

Michael Adeyemi · 2025-06-30T13:37:48+00:00

There was an error rendering this rich post.

Hello,

I am having a challenge with previewing data after completing the steps below

My preview returns empty. with just product in the first row and total in the second. No other data is present.

I suspect that I may have missed a step in the set up of the temp cube, but I struggling to find what it is based on the instructions.

Find more posts tagged with

Capsules

Data Modeling

Capsule

Cube

Accepted answers

John Williams

Hi @Michael Adeyemi

Could you please try the following steps to resolve the issue:

Change the mode of the #Salesperson field to ‘Add New Item’.
Once you've saved the changes in the Data Reader, please clear the Data Reader, as well as the cubes:
- TEMP-ACT-DR-Sales LC
- TEMP-ACT-DR-Units
After that, run the Data Reader again and check if the layout preview is now displaying correctly.

Let me know how it goes — happy to help further if needed!

All comments

Nial

Hello @Michael Adeyemi,

I understand you’re getting only header rows in your preview — no data appears — and you think the issue might be with the temp cube setup, but you can’t pinpoint what step is missing.

I assume that there may be an issue with the TEMP - ACT - DR – Units cube, which could be why the data isn’t populating correctly. Could you please share a screenshot of the TEMP - ACT - DR – Units cube configuration, along with a screenshot of the layout editor for the screen you’re previewing? This will help us investigate further.

Awaiting a response from you.

Regards,
Nial Smith

Michael Adeyemi

Hi Nial,

Thanks for your response, I have attached the two screens as requested. I also made an assumption that "data block: a" as referred to in the instructions just meant the first data view I added, as opposed to one specifically called "data block: a".

John Williams

@Michael Adeyemi

Thank you for your response and for providing the screenshots.

Could you please share a screenshot of the 'ACT - Units and Sales' data reader mapping section? This part can be a bit tricky, and we’d like to ensure everything is set up correctly.

Please check that the following settings are in place:

Map your file’s columns to the correct cubes: Units and Sales LC.
Only add the cubes TEMP - ACT - DR - Sales LC and TEMP - ACT - DR - Units in the mapping screen. This will ensure the correct cube versions are included automatically.
Set the mapping mode as follows:
- #Salesperson – set to READ (add it separately)
- Cubes – set to Add
- All other fields – set to Discard New Items

Let us know once done or if anything is unclear.

Michael Adeyemi

Hi John,

I've updated the set up as below

but my preview on the layout editor still looks empty as per below

John Williams

Hi @Michael Adeyemi

Could you please try the following steps to resolve the issue:

Change the mode of the #Salesperson field to ‘Add New Item’.
Once you've saved the changes in the Data Reader, please clear the Data Reader, as well as the cubes:
- TEMP-ACT-DR-Sales LC
- TEMP-ACT-DR-Units
After that, run the Data Reader again and check if the layout preview is now displaying correctly.

Let me know how it goes — happy to help further if needed!

Michael Adeyemi

Thanks John,

It looks to be working now.

I initially did the clearing but didn't get see a difference. I then repeated the process again, but this time it looks like ETL is selected, I can then see data in the preview.

John Williams

Hi @Michael Adeyemi,

Great to hear it's working now!

Thanks for the update — sounds like selecting ETL made the difference the second time around. Glad the data preview is showing up properly now.

Michael Adeyemi

Thanks John,

I found another issue with the instructions following on from setting up the data view.

I am being asked to rename the Tab, but my screen doesn't have an option to name as shown on the course.

View from the course is below,

My view, without the option to add a name is below.

I have since moved on to the next steps, but would be good to understand the cause, I also don't seem to be able to drop my data view screen object into the tab. It just overlays on top of it as per the image above.

Many thanks again for your help so far with this.

Regaards,

Michael

Michael Adeyemi

Morning,

Just wanted to flag, a fellow new joiner has helped with the issue I encountered above relating to naming of tabs.

Many thanks again,

Michael