Thursday Mar 08, 2012

Loading Product Family into Demantra Using Legacy Collection

I am using legacy collection to load product family into Demantra.  In the soucre EBS/Value Chain Planning (VCP)
I can see my product family and member in the ASCP plan.

I would like to be able to have product family dimension populated in a Demantra Hierarchy.  I have used demhistory
flat file to upload forecasts for my items (members) and I expect to have product family dimension populated.

I started to analyse demantra collection and EP launch, and it seems to me that stagging table T_SRC_ITEM_TMPL is
populated by process "Collect Level Type (2)"  or perhaps a subprocess.

The stagging table stores the link between members and product family itself, ebs_product_family_code field, but it
is populated with default value (0).

The profile 'MSD_DEM: Master Org' is used for collecting item -> product family rollups into demantra.
Item to product family rollup needs to be available in ASCP under the master organization specified by the above profile.

This is a source side profile, and cannot be set by hand in case of legacy source.  To set the value, you will need to run the
request 'Configure Legacy Profiles' from 'Demand Management System Administrator' responsibility.  Parameters for this
request are as follows:

- Legacy Instance
- Master Org
- Category set

After running this, check for records in msd_dem_legacy_setup_params table.  Then try running flat file load and verify
product family is populated in t_src_item_tmpl table in demantra schema.

Also the product family members/product family relationship comes from the msc_system_items table for the master organization,
not organization where product family/product members is defined

You can check for a link between members and product family in the master org within msc_system_items and then the product family
should be visible within Demantra.

Monday Feb 27, 2012

Performance and RDBMS Tuning and Maintenance

Demantra is a Data Base resource intensive application.

- Evident from large implementations
- Large-scale implementations are global solutions across multiple regions or
  retailer oriented store-level solutions - Require very large demand data
  repositories storing billions of data points.

Common Demantra Performance issues
- Poor worksheet response times
- Longer Batch Engine run times
- Extended Simulation runs
- Prolonged Data loads
- Slow running user updates

These issues can be addressed by appropriate DB setup and tuning activities

Example 1.
This customer has been live on a Demantra VMI implementation and suddenly reported worksheet performance issues.

Sales_Data was ~32M records, non-partitioned

Highlights:
Analyze_Schema was not being run
Did a chained row count after Analyze_Schema – 48%
Recommended Rebuild_schema and worksheet performance improved 60% on average

 

Example 2.
This is a Demantra DM/PTP/DSM implementation. Just before UAT customer loaded full volume of Sales history,
Promotion and Settlement data and started experiencing serious worksheet performance issues.

MDP_Matrix=1.5M; Sales_Data=30M; Promotion_Data = 22M;

Highlights:
- CBO parameter changes
- Relocating null and empty columns in very large tables at the end of the row
- Sales_Data partitioning
- Reorder of Data by PK
- Worksheet specific Indexes

Performance Improvements reported:

Series Config Changes, 21%

GL Data Trim, 8%

Indexes, 2%

Reorder Data by PK, 32%

Worksheet Cache Refresh, 73%

Monday Nov 14, 2011

Upgrading/Installing Demantra 7.3.1.1? Check this out!

Here is a summary for relase 7.3.1.1 install/upgrade/features

  • Data Preservation Setting for General Levels 
  • Deploying Demantra Application Server 10g 
  • Important upgrade Information 
  • Known upgrade issues 
  • Mozilla Firefox Browser 
  • Installer Issues 
  • Reviewing / Simulating General Level Data Such as CTO Base Model Demand 
  • Failure Rate Calculation 
  • Demantra SSL Client Authentication and Java 6 
  • CTO functionality does not work in release 7.3.1.1 after upgrading from 7.3.0 using the ‘Platform Upgrade Only’ option. 
  • User Privileges and Export Worksheet to Excell 
  • Cookie Attribute Causes Logging Issue in Worksheet 
  • List of bugs fixed in 7.3.1.1

See the following for details.

  • Demantra 7.3.1.1 Install / Upgrade Known Issues, Notes, Guidance, Defects, Workarounds (Doc ID 1370518.1)
  • Related Documents For Demantra Version 7.3.1.1 And If Demantra Supports The Required Stacks (Doc ID 1367141.1)
About

This blog delivers the latest information regarding performance and install/upgrade. Comments welcome

Search

Archives
« April 2014
SunMonTueWedThuFriSat
  
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
   
       
Today