How do you create a data mart

by Calvin on July 17, 2008

How do you create a data mart

  • right click and create the export data source for the ODS/cube
  • in the target system replicate the data source
  • create transfer rules and update rules
  • create info package to load

{ 0 comments }

amount quantity and number

by Calvin on June 7, 2008

Difference between amount/quantity and number - amount/quantity always comes with units; for example sales will be amount and inventory quantity

{ 0 comments }

SAP BW Alpha conversion

by Calvin on June 7, 2008

Alpha conversion

Alpha conversion is used to store data consistently by storing any numeric values with prefixing with 0s; for example if you defined material as 6 Numc then number 1 is stored as 000001 but displayed as 1; this removes inconsistencies between 01 vs. 001.

{ 0 comments }