SAP ABAP Program RSDD_MSSQL_CUBEANALYZE (Analysis of MS SQL Server Fact Tables)
Hierarchy
SAP_BW (Software Component) SAP Business Warehouse
   BW-SYS-DB-MSS (Application Component) BW Microsoft SQL Server
     RSMSS (Package) Microsoft SQL Server Porting
Basic Data
Program RSDD_MSSQL_CUBEANALYZE Analysis of MS SQL Server Fact Tables  
Program Type 1 Executable program  
Attributes
Status K Customer Production Program  
Application B Business Information Warehouse  
Authorization Group  
Logical database  
Selection screen  
Editor lock Fixed point arithmetic  
Unicode checks active Start using variant  
Transaction Code
There is no transaction reference to this program  
Screens
# Screen Short Description
1 0100  Initial Screen for Fact Table Analysis 
2 0200  List of F Fact Tables Without Clustered 010 Index 
3 0300  List of F Fact Tables iwth Incorrect PRIMK Flag 
4 0400  Repair Screen for Indexes 
5 0401  Repair Screen for Indexes 
6 0500  Decimal Compression Screen 
7 0501  Input of a Table Name 
8 0600  List of E Fact Tables Without PK or P Index 
9 0700  List of F Fact Tables Without P Index 
10 0800  List of E Fact Tables Without PK or P Index 
11 0900  List of F Fact Tables With Missing Partitions 
12 0950  List of F Fact Tables With Superfluous Partitions 
13 0960  List of Clone/Shadow Tables of Terminated Deletions 
14 0970  List of E Oracle-Specific F Fact Indexes (Index 900) 
15 0971  List of Temporary Tables Without Index 
16 0972  List of PSA Tables with Missing Partitions 
17 0973  List of PSA Tables with Superfluous Partitions 
18 0974  List of Cube Tables with Missing Statistics 
19 0975  List of Cube Tables with Missing Statistics 
     
GUI Status
# GUI Status Short Description
1 100  Initial Screen in Cube Analysis 
2 200  List of All F Fact Tables Without 010 Clustering 
3 300  List of All F Fact Tables Without 010 Clustering 
4 400  List of All F Fact Tables Without 010 Clustering 
5 401  Processing of Include Columns 
6 500  Compress/Decompress Decimals 
7 501  Screen for Single Table Processing 
8 600  List of All A Fact Tables Without PK or P Index 
9 700  List of All A Fact Tables Without PK or P Index 
10 900  List of All F Fact Tables with Partition Inconsistencies 
11 950  List of All F Facts with Superfluous Partitions 
12 960  List of All F Facts with Superfluous Partitions 
13 970  List of All F Fact Tables with 900 Indexes 
14 971  List of All Temporary Tables Without Index 
15 972  List of All PSA Tables with Missing Partitions 
16 973  List of All PSA Tables with Superfluous Partitions 
17 974  List of All Cube Tables with Missing Statistics 
18 975  List of All Partitioned Tables with Multiple Partitions 
     
GUI Title
# GUI Title Short Description
1 100  Cube Analysis and Repair for MS SQL Server Fact Tables 
2 200  List of All F Fact Tables Without Clustered 010 Index 
3 300  List of All F Fact Tables with Primary Key 
4 400  Processing of Indexes 
5 401  Creation of INCLUDE Columns for Indexes 
6 500  Compress/Decompress Decimals/Tables 
7 501  Enter a Single Table for Processing 
8 600  List of All E Fact Tables Without PK or P Index 
9 700  List of All F Fact Tables Without P Index 
10 900  List of All F Fact Tables with Missing Partitions 
11 950  List of All F Fact Tables with Unnecessary Partitions 
12 960  List of Remaining Clone Tables (Shadow Tables) 
13 970  List of All F Fact Tables with 900 Indexes 
14 971  List of All Temporary Tables Without Index 
15 972  List of All PSA Tables with Missing Partitions 
16 973  List of All PSA Tables with Superfluous Partitions 
17 974  List of All Cube Tables with Missing Statistics 
18 975  List of All Partitioned Tables with Multiple Partitions 
     
History
Last changed by/on SAP  20100113 
SAP Release Created in 710