Level 205 Build a Data Model and Capsule Procedure to load actuals

Fabrizio Gilardi

Hi

I created a new procedure in the Data Model and named it ACT - Sales Data Load

Then I created the Clear cubes and the text file data reader and I saved it

But then I have to create a new procedure with the same name as before ACT - Sales Data Load, so I cannot create another procedure with the same name

The next step is to create a new group and name it Call DB Procedure

If I try to create the new group in the previous procedure when I try to create an execution flow: call procedure and I set the Level 2 Demo I cannot set the procedure to ACT - Sales Data

I do not know if I am missing something, I did the process many times but I cannot not find the solution

Thanks

Fabrizio

Brian Walker

Hi Fabrizio,

In chapter 205 the instructions are given to create a procedure in a capsule and data model with the same name.

You will need to create one procedure in the data model and another in the capsule with the same name "ACT - Sales Data Load".

Once you create the capsule procedure you will get an option to set the call procedure from the database.

Please try this once and let us know if you face any issues.

PFA-