SmartDukaan – /trunk/pentaho/schema/

Rev 7890 – Adding source to Pentaho

anupam.singh — Thu, 01 Aug 2013 15:29:02 +0530

anupam.singh – 2 file(s) modified
Adding source to Pentaho

~ /trunk/pentaho/data-integration/transformations/ordersLoader.ktr
~ /trunk/pentaho/schema/SalesSchema.xml

Rev 7203 – Added NLC, OTG, Insurer in pentaho

anupam.singh — Mon, 29 Apr 2013 17:01:08 +0530

anupam.singh – 4 file(s) modified
Added NLC, OTG, Insurer in pentaho

~ /trunk/pentaho/data-integration/transformations/ordersLoader.ktr
~ /trunk/pentaho/data-integration/transformations/RepeatSaleAnalysis.ktr
~ /trunk/pentaho/schema/CommonOrdersSchema.xml
~ /trunk/pentaho/schema/SalesSchema.xml

Rev 6554 – Changes in itemLoader script, added commonorders schema

anupam.singh — Fri, 28 Dec 2012 20:59:41 +0530

anupam.singh – 4 file(s) modified
Changes in itemLoader script, added commonorders schema

~ /trunk/pentaho/data-integration/transformations/itemLoader.ktr
~ /trunk/pentaho/data-integration/transformations/RepeatSaleAnalysis.ktr
+ /trunk/pentaho/schema/CommonOrdersSchema.xml
+ /trunk/pentaho/scripts/temp.py

Rev 5905 – Added two dimensions Days to Second Order and averageValue.

anupam.singh — Tue, 28 Aug 2012 18:45:07 +0530

anupam.singh – 2 file(s) modified
Added two dimensions Days to Second Order and averageValue.

~ /trunk/pentaho/data-integration/transformations/repeatLoader.ktr
~ /trunk/pentaho/schema/RepeatSalesSchema.xml

Rev 5896 – ETL and Cube schema for repeat sale analysis cube.

anupam.singh — Mon, 27 Aug 2012 19:39:25 +0530

anupam.singh – 3 file(s) modified
ETL and Cube schema for repeat sale analysis cube.

+ /trunk/pentaho/data-integration/transformations/repeatLoader.ktr
+ /trunk/pentaho/schema/RepeatSalesSchema.xml
~ /trunk/pentaho/schema/SalesSchema.xml

Rev 5799 – Trac#1550 Added pickupType dimension in salesCube

anupam.singh — Wed, 15 Aug 2012 23:38:05 +0530

anupam.singh – 1 file(s) modified
Trac#1550

Added pickupType dimension in salesCube

~ /trunk/pentaho/schema/SalesSchema.xml

Rev 5710 – Adding key expression to sales cube for productName heirarchy

anupam.singh — Wed, 01 Aug 2012 15:00:24 +0530

anupam.singh – 1 file(s) modified
Adding key expression to sales cube for productName heirarchy

~ /trunk/pentaho/schema/SalesSchema.xml

Rev 5709 – Including newsletter in the productactivity cube

anupam.singh — Wed, 01 Aug 2012 14:58:03 +0530

anupam.singh – 1 file(s) modified
Including newsletter in the productactivity cube

~ /trunk/pentaho/schema/ProductActivitySchema.xml

Rev 5466 – Added support for tracking newsletter as a source Trac ...

anupam.singh — Thu, 21 Jun 2012 12:50:40 +0530

anupam.singh – 2 file(s) modified
Added support for tracking newsletter as a source

Trac #838
Reviewer : Amar Kumar

~ /trunk/pentaho/schema/ProductActivitySchema.xml
~ /trunk/Website/src/main/java/in/shop2020/serving/interceptors/TrackingInterceptor.java

Rev 5417 – Trac #1374 Reviewer : Mandeep Dhir Cleaned CRMResponse cube.

anupam.singh — Thu, 14 Jun 2012 01:35:33 +0530

anupam.singh – 3 file(s) modified
Trac #1374
Reviewer : Mandeep Dhir

Cleaned CRMResponse cube.

~ /trunk/pentaho/data-integration/transformations/crmLoader.ktr
~ /trunk/pentaho/schema/CRMResponseReport.xml
~ /trunk/pentaho/schema/SalesSchema.xml

Rev 5391 – Changed number display format from ##,### to ###,###

anupam.singh — Fri, 08 Jun 2012 17:35:27 +0530

anupam.singh – 1 file(s) modified
Changed number display format from ##,### to ###,###

~ /trunk/pentaho/schema/SalesSchema.xml

Rev 5200 – Separating bookingCube and salesCube

anupam.singh — Thu, 17 May 2012 14:25:41 +0530

anupam.singh – 1 file(s) modified
Separating bookingCube and salesCube

~ /trunk/pentaho/schema/SalesSchema.xml

Rev 5161 – trac# 1145, 1198 Added another heirarchy in OrderStatus - ...

anupam.singh — Mon, 14 May 2012 04:23:20 +0530

anupam.singh – 1 file(s) modified
trac# 1145, 1198

Added another heirarchy in OrderStatus - isValid. Also introduced booking date.

~ /trunk/pentaho/schema/SalesSchema.xml

Rev 5157 – Trac # 1180, 1266 Added Measures for tracking new logistic ...

anupam.singh — Mon, 14 May 2012 02:28:34 +0530

anupam.singh – 2 file(s) modified
Trac # 1180, 1266
Added Measures for tracking new logistic states. Added statusGroup and statusSubGroup in this cube.

~ /trunk/pentaho/data-integration/transformations/orderFulfilmentLoader.ktr
~ /trunk/pentaho/schema/FulfilmentReport.xml

Rev 5156 – Trac#1055 Introduced price-range column in productActivity cube.

anupam.singh — Mon, 14 May 2012 01:24:00 +0530

anupam.singh – 2 file(s) modified
Trac#1055

Introduced price-range column in productActivity cube.

~ /trunk/pentaho/data-integration/transformations/itemLoader.ktr
~ /trunk/pentaho/schema/ProductActivitySchema.xml

Rev 4166 – Fix a bug in actual_estimate_diff dimension.

vikas — Thu, 01 Dec 2011 16:22:20 +0530

vikas – 1 file(s) modified
Fix a bug in actual_estimate_diff dimension.

~ /trunk/pentaho/schema/FulfilmentReport.xml

Rev 4033 – fix the type of the price range level.

vikas — Fri, 11 Nov 2011 19:35:36 +0530

vikas – 1 file(s) modified
fix the type of the price range level.

~ /trunk/pentaho/schema/SalesSchema.xml

Rev 4030 – Add measures for average time taken to close a ticket, ...

vikas — Fri, 11 Nov 2011 15:06:56 +0530

vikas – 2 file(s) modified
Add measures for average time taken to close a ticket, how many times tickets are reopened

~ /trunk/pentaho/data-integration/transformations/crmLoader.ktr
~ /trunk/pentaho/schema/CRMResponseReport.xml

Rev 4029 – Add another hierarchy for product with two levels(brand and model_number ...

vikas — Fri, 11 Nov 2011 15:05:13 +0530

vikas – 1 file(s) modified
Add another hierarchy for product with two levels(brand and model_number with color). Change transfer price measure to be product of quantity and transfer price.

~ /trunk/pentaho/schema/SalesSchema.xml

Rev 3839 – CRM response report.

vikas — Fri, 21 Oct 2011 12:27:57 +0530

vikas – 1 file(s) modified
CRM response report.

+ /trunk/pentaho/schema/CRMResponseReport.xml

Rev 3838 – Reorganised the first source and session source dimensions.

vikas — Fri, 21 Oct 2011 12:27:33 +0530

vikas – 1 file(s) modified
Reorganised the first source and session source dimensions.

~ /trunk/pentaho/schema/ProductActivitySchema.xml

Rev 3750 – Add payment mode dimension.

vikas — Wed, 19 Oct 2011 12:03:46 +0530

vikas – 2 file(s) modified
Add payment mode dimension.

~ /trunk/pentaho/data-integration/transformations/orderFulfilmentLoader.ktr
~ /trunk/pentaho/schema/FulfilmentReport.xml

Rev 3708 – Change the measures to show the unique counts.

vikas — Mon, 17 Oct 2011 12:55:02 +0530

vikas – 1 file(s) modified
Change the measures to show the unique counts.

~ /trunk/pentaho/schema/ProductActivitySchema.xml

Rev 3707 – Make source domenstions in sales and product activity report similar.

vikas — Mon, 17 Oct 2011 12:08:07 +0530

vikas – 2 file(s) modified
Make source domenstions in sales and product activity report similar.

~ /trunk/pentaho/schema/ProductActivitySchema.xml
~ /trunk/pentaho/schema/SalesSchema.xml

Rev 3706 – Fulfillment report.

vikas — Mon, 17 Oct 2011 12:06:33 +0530

vikas – 1 file(s) modified
Fulfillment report.

+ /trunk/pentaho/schema/FulfilmentReport.xml

Rev 3543 – Product activity report.

vikas — Fri, 07 Oct 2011 13:18:27 +0530

vikas – 1 file(s) modified
Product activity report.

+ /trunk/pentaho/schema/ProductActivitySchema.xml

Rev 3542 – Created a dimenstion table for order schema. Got rid of ...

vikas — Fri, 07 Oct 2011 13:17:50 +0530

vikas – 1 file(s) modified
Created a dimenstion table for order schema. Got rid of degenerated dimension for order hour from fact table.

~ /trunk/pentaho/schema/SalesSchema.xml

Rev 3484 – Changes to calculate price range and days to purchase at ...

vikas — Thu, 29 Sep 2011 17:32:13 +0530

vikas – 1 file(s) modified
Changes to calculate price range and days to purchase at the time of data integration itself.

~ /trunk/pentaho/schema/SalesSchema.xml

Rev 3481 – Changes to calculate price range and days to purchase at ...

vikas — Thu, 29 Sep 2011 16:38:19 +0530

vikas – 2 file(s) modified
Changes to calculate price range and days to purchase at the time of data integration itself.

~ /trunk/pentaho/data-integration/transformations/ordersLoader.ktr
~ /trunk/pentaho/schema/SalesSchema.xml

Rev 3437 – Split source columns into source type and source url for ...

vikas — Tue, 27 Sep 2011 12:16:36 +0530

vikas – 1 file(s) modified
Split source columns into source type and source url for performance in cube schema.

~ /trunk/pentaho/schema/SalesSchema.xml

Rev 3393 – Add level order hour to sales schema.

vikas — Wed, 21 Sep 2011 14:24:12 +0530

vikas – 1 file(s) modified
Add level order hour to sales schema.

~ /trunk/pentaho/schema/SalesSchema.xml

Rev 3222 – Add affiliate to sales report.

vikas — Tue, 06 Sep 2011 19:05:10 +0530

vikas – 1 file(s) modified
Add affiliate to sales report.

~ /trunk/pentaho/schema/SalesSchema.xml

Rev 2886 – Give explicit name to datedim table in differenct dimensions.

vikas — Tue, 09 Aug 2011 17:09:58 +0530

vikas – 1 file(s) modified
Give explicit name to datedim table in differenct dimensions.

~ /trunk/pentaho/schema/SalesSchema.xml

Rev 2856 – Add session and source times.

vikas — Mon, 08 Aug 2011 15:09:48 +0530

vikas – 4 file(s) modified
Add session and source times.

~ /trunk/pentaho/data-integration/transformations/cartLoader.ktr
~ /trunk/pentaho/data-integration/transformations/ordersLoader.ktr
~ /trunk/pentaho/data-integration/transformations/userLoader.ktr
~ /trunk/pentaho/schema/SalesSchema.xml

Rev 2853 – Add session and source times.

vikas — Mon, 08 Aug 2011 15:00:30 +0530

vikas – 4 file(s) modified
Add session and source times.

Rev 2834 – Add coupon code.

vikas — Wed, 03 Aug 2011 19:03:36 +0530

vikas – 2 file(s) modified
Add coupon code.

~ /trunk/pentaho/data-integration/transformations/ordersLoader.ktr
~ /trunk/pentaho/schema/SalesSchema.xml

Rev 2801 – Add dimenstion source.

vikas — Tue, 02 Aug 2011 16:40:00 +0530

vikas – 1 file(s) modified
Add dimenstion source.

~ /trunk/pentaho/schema/SalesSchema.xml

Rev 2712 – Add user dimenssion.

vikas — Tue, 26 Jul 2011 15:45:02 +0530

vikas – 1 file(s) modified
Add user dimenssion.

~ /trunk/pentaho/schema/SalesSchema.xml

Rev 2704 – Cart Cube.

vikas — Tue, 26 Jul 2011 13:33:18 +0530

vikas – 3 file(s) modified
Cart Cube.

+ /trunk/pentaho/data-integration/transformations/cartLoader.ktr
+ /trunk/pentaho/data-integration/transformations/userLoader.ktr
+ /trunk/pentaho/schema/CartSchema.xml

Rev 2639 – Add order hour and payment dimenstions. Update price range dimension ...

vikas — Tue, 19 Jul 2011 15:06:48 +0530

vikas – 1 file(s) modified
Add order hour and payment dimenstions. Update price range dimension ranges.

~ /trunk/pentaho/schema/SalesSchema.xml