Sure. (Courtesy: J Livingston)

/* build (only Once) ============================================================================================================= */

IF EXISTS (

...

Once i pivot the tbl_ItemWeekwise, i get around ~61,000 distinct sku's.

if you can refer my post to anyone with BI know-how that would be faster.

Thanks.

[font="Verdana"]Hi,

If you see the CSV's they dont have a Sale_week column. I am adding it to the query, also the sCountry, sChar (Character language), iYear columns. Each CSV contains 3...

Thanks for the links mate. 🙂

BTW, i am currently looking at this Cube Tutorial. But it doesnt explain how to create and deploy cubes made from a single table. In...

the above queries work fine in sql server now, but donot know how to automate job schedule to scan network folder for csv files and run those queries on the...

Hi,

sure.

Is it possible to send it to you privately to a personal email address?

Thanks J. Livingston 🙂

please let me know if i need to start a separate thread for this or i can state my problem here?

Actually, as a starting point,

1] I needed...

Thanks Sean. 🙂

Right now, going thru the links as per your advice. Also searching for tutorials on learning how to create OLAP Cubes in SSAS and how i can implement...

Yes, but cumulative across weeks i.e. Sale_week columns for each Description (SKU) will result in the same number of Description (SKU) rows. So data will still be huge to handle...

say for example...

sales by brand...week on week comparison?

sales by category this year to date v last year to date?

yadda, yadda -----------

have you considered using a "cube" (SSAS) and linking excel...

Luis,

Thanks a bunch! 🙂

this works perfectly - though now i will need to sit and understand your code.

Also, do i need to add an output variable and OUTPUT keyword at...

I will surely look into crosstabs later.

Right now, can you help me with the sp and dynamic generation of columns as right now i am pulling my hair and not...

hi Sean,

thanks for replying.

if i execute the above query in an sql editor without putting it into a stored proc, it gives me the result i want!

however, i donot want...

no one on this forum knows how to use dynamic sql to generate 1 to 52 numbers in pivot column?

:ermm:

hi,

the data is ~101 mil records. excel pivot doesnt accept that huge amount to transform and also out of memory issues. In transformed form, the description column becomes unique and...