Level 200 - Module 213 - Expense Data Issue

Mason · 2025-06-03T15:57:24+00:00

There was an error rendering this rich post.

Hello, I am having issues with publishing my expense data with the new procedure updates made in this module. After I load the data in the expense and click publish data, the data does not disappear from the screen and I do not get prompted that the expense data has been published. Also, I do not see any expense data in the downstream data view objects. I have double-checked my procedure steps and cannot locate the issue. Attached is a screenshot of my procedure for the Expense Data Publish in the data model. Note: the procedure works correctly for my Sales Data Upload.

Find more posts tagged with

Board Academy

Level 200: Building a Planning Solution

Accepted answers

Helmut Heimann

@Mason ,

it should be looking like this

Best,
Helmut

All comments

Helmut Heimann

Hi @Mason ,

The screenshot you've provided shows the database procedure used to publish the expenses. However, the label/button in the expenses screen should call the capsule procedure, which would call the depicted database procedure.

The capsule procedure is the one with the messages you expect to see.

Could you please check that?

Best,
Helmut

Mason

Hi Helmut,

Here is my capsule procedure. I don't see any discrepancies between my screenshot and yours.

Mason

@Helmut Heimann

Helmut Heimann

Hi @Mason ,

ok, great to hear that. Assuming your label/button on the screen is connected to this capsule procedure, could you please set a breakpoint at the DB procedure's entry point and check the active selection when running?

I see that you are selecting two years, although you should have selected months dynamically

Furthermore, could you please check that the source cubes of your dataflows contain data according to the current selection?

Best,
Helmut

Helmut Heimann

Hi @Mason,

can you please check that the step 2 "show message" is configured correctly, as well?
It should be like this

Best,
Helmut

Mason

@Helmut Heimann I have two years selected because of the directions posted below. I added the breakpoint to the DB procedure, as seen in the second screenshot. The following screenshot is the screen that popped up once I ran the expense data publish procedure in the expense data upload screen.

Helmut Heimann

Hi @Mason ,

can you verify that the dataflow source cubes contain data for this selection? If so, can you please check the extensions in the calculation domains being set correctly?

Best,
Helmut

Mason

@Helmut Heimann The dataflow source cubes contain data for this selection. I checked the calculation domains and in this procedure I do not have any extensions.

Mason

@Helmut Heimann Step 7 does not allow me to add extensions

Helmut Heimann

@Mason ,

it should be looking like this

Best,
Helmut

Mason

@Helmut Heimann Amazing, this was the issue. I did not have a data block in this configuration. THANK YOU!!!!

Helmut Heimann

Glad to help out ;-) @Mason