PENTAHO DESIGN STUDIO: CREATING SIMPLE xaction

STEP 1: Open Design Studio

STEP 2: Select NEW->FILE->PROJECT

STEP 3: Select java project-> Next->Give the project name->select create project prom existing source

->select the directory->Next->Click Finish.

STEP 4: Select BI Platform->New Action Sequence->select the container-> give the file name-> Finish

       

                                                                              

Step 5: Select define process. Select get data from->Relational under Process Output

STEP 6:  Give the following details like name, query, output etc.

                                                                                         

STEP 7: under process output select the result set name.

                                                            

    

STEP 8: select TEST->give the user console URL-> click generate URL-> Run

                

                                                                         

STEP 9: END