Skip to Content
avatar image
Former Member

DTP Routine to Get dynamic Data load for Cal Month Ranges!!

Hi Guys

I have a Requirement to load data from 1 Data Source to 10 Cubes based on Cal month.

Client having a contraint to not use any hardcoded value in any DTP.

Our Cubes are Designed in such a way to get 6 months data on first cube & second six month data on second cube & then third 6 months data on third cube & so on till 10th cube. same sequence we need to load 20 years of data in future. Means 1st cube will have Jan - June 18, second cube July - dec 18. like wise till 20 years.

So basically 1 cube will have data ranges as Jan - june 18, 23, 28 & 33.

like wise all cubes.

Now the problem is they need to run all DTP ' 10 & they want only current month/ year dtp to be loaded in to respective cube through DTP routine.

I tried to put a logic to get current month in dtp routine but i am not able to figure it out that how it will load to specific cube only at a time & not all cubes.

Only thing which bothers me as our Client dont want to use harcoded values then how to load only one cube from same source for same dtp routine logic.

Please through some lights on this, thanks.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

0 Answers