DTP running at the same time with different selections

[Former Member]

Hi gurus,

I have a single source( write optimized DSO) and a targets(cube).

I have three date ranges as selections and some exclusion values in the dtp filer say 1) 4/16/2014 to 5/16/2014- full load

                                                                                                                                        2) 5/17/2014 to 7/16/2014

                                                                                                                                        3) 07/17/2014 till date

can I create one dtp  and run the same dtp by changing the selection simultaneously. All the loads are full.

Regards,

Rajesh.

[RamanKorrapati]

Hi,

Yes, You can run one dtp and keep on change the filters.

If you need then create 3 dtps and enter those filters.

Thanks

[Former Member]

Hi Rama,

We can create 1 dtp and change the selections one after the other, that's fine. My question is can we run the dtp with 1st selection and while it is running, can we change the selections of the same filter and start running with the second selection?

Regards,

Rajesh.

[RamanKorrapati]

No, After finishing dtp execution then only we can change and run it.

But you can try to change while running with first selections.

it will allow. Any way its full load, so no issues, just try it.

[karthik_vasudevan]

Hi Rajesh

Yes, you can run the same DTP to do such full loads. But instead of doing this, create a small process chain with three different DTPs with individual selections.

It would be automated and you don't want to change the selections once its done.

Once the process chain is successful, delete the DTPs if you think you don't want to see them or leave it as such.

DTPs wont do anything bad even if it exists the system

Regards

Karthik

[Former Member]

Hi Karthik,

We can create 1 dtp and change the selections one after the other, that's fine. My question is can we run the dtp with 1st selection and while it is running, can we change the selections of the same filter and start running with the second selection?

Regards,

Rajesh.

[karthik_vasudevan]

No Rajesh. You cant edit a DTP when its in process.

Regards

Karthik