|
Query |
|
| |||||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | |||||||||||||
SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |
com.sas.iquery.util.ExportInfoUtilities
public class ExportInfoUtilities
Utility methods to extract specific information from the export object.
Constructor Summary | |
---|---|
ExportInfoUtilities()
|
Method Summary | |
---|---|
static java.util.Comparator<ExportDataSource> |
getExportDataSourceSorter()
returns a comparator suitable for sorting export data sources. |
static void |
getHierarchyInfo(Export export,
java.util.List<java.lang.String> allUniqueLevelNames,
java.util.Map<java.lang.String,java.lang.String> mapUniqueLevelNamesToFormats,
java.util.Map<java.lang.String,com.sas.iquery.metadata.business.QualifiedColumn> mapUniqueLevelNamesToColumns,
java.util.Map<java.lang.String,java.util.Map<java.lang.String,java.util.Map<java.lang.Integer,java.lang.String>>> mapDimensionsToMemberLevels)
Populates data structures with DIMENSION, HIERARCHY, and LEVEL information useful for displaying in a GUI. |
static void |
getJoinInfo(Export export,
java.util.Map<ExportDataSource,java.util.Map<com.sas.iquery.metadata.business.QualifiedColumn,java.util.Set<ExportJoin>>> joinedTableColumns)
Populates data structures with JOIN based information useful for displaying in a GUI. |
static void |
getMeasureInfo(Export export,
java.util.List<java.lang.String> allUniqueMeasureNames,
java.util.Map<java.lang.String,com.sas.iquery.metadata.business.QualifiedColumn> mapUniqueMeasureNamesToColumns,
java.util.Map<java.lang.String,java.lang.String> mapUniqueMeasureNamesToLabels,
java.util.Map<java.lang.String,java.lang.String> mapUniqueMeasureNamesToDescriptions,
java.util.Map<java.lang.String,java.lang.String> mapUniqueMeasureNamesToFormats,
java.util.Map<java.lang.String,java.lang.String> mapUniqueMeasureNamesToAggregations)
Populates data structures with the predefined measures from the exported model. |
static void |
getTableInfo(Export export,
java.lang.String lasrLibrefName,
java.util.List<ExportDataSource> allTables,
java.util.Map<ExportDataSource,java.util.List<com.sas.iquery.metadata.business.QualifiedColumn>> tableColumns,
java.util.Set<java.lang.String> libnameStatements,
java.util.Map<ExportDataSource,java.lang.String> sourceTableNames,
java.util.Map<ExportDataSource,java.lang.String> lasrTableNames)
Populates data structures with LIBRAY, TABLE, and COLUMN information useful for displaying in a GUI. |
static java.util.List<ExportJoin> |
getUploadJoinsUsedBetween(Export export,
ExportDataSource dataSource1,
ExportDataSource dataSource2)
returns a list of export joins used between two export data sources or an empty list if none found. |
Constructor Detail |
---|
public ExportInfoUtilities()
Method Detail |
---|
public static void getTableInfo(Export export, java.lang.String lasrLibrefName, java.util.List<ExportDataSource> allTables, java.util.Map<ExportDataSource,java.util.List<com.sas.iquery.metadata.business.QualifiedColumn>> tableColumns, java.util.Set<java.lang.String> libnameStatements, java.util.Map<ExportDataSource,java.lang.String> sourceTableNames, java.util.Map<ExportDataSource,java.lang.String> lasrTableNames) throws MetadataException
export
- The export object to be inspected.lasrLibrefName
- The libref of the lasr library that the schema tables will be upload to.allTables
- Populated with all the tables used to define the star schema.tableColumns
- Populated with a mapping of the export tables to all the columns for that table.libnameStatements
- Populated with the libname statements needed to be issued to access the physical tables.sourceTableNames
- Populated with the fully qualified and identifier escaped source libref table names.lasrTableNames
- Populated with the fully qualified and identifier escaped destination lasr table names.
MetadataException
public static java.util.List<ExportJoin> getUploadJoinsUsedBetween(Export export, ExportDataSource dataSource1, ExportDataSource dataSource2) throws MetadataException
export
- The export object to be inspected.dataSource1
- An export data sourcedataSource2
- An export data source
MetadataException
public static void getHierarchyInfo(Export export, java.util.List<java.lang.String> allUniqueLevelNames, java.util.Map<java.lang.String,java.lang.String> mapUniqueLevelNamesToFormats, java.util.Map<java.lang.String,com.sas.iquery.metadata.business.QualifiedColumn> mapUniqueLevelNamesToColumns, java.util.Map<java.lang.String,java.util.Map<java.lang.String,java.util.Map<java.lang.Integer,java.lang.String>>> mapDimensionsToMemberLevels) throws MetadataException
export
- The export object to be inspected.allUniqueLevelNames
- Populated with the unique level names defined by the export source.mapUniqueLevelNamesToFormats
- Populated with a mapping of the unique level names to the formats to use for each that level.mapUniqueLevelNamesToColumns
- Populated with a mapping of the unique level names to the qualified column to use for that level.mapDimensionsToMemberLevels
- Populated with a nested mapping of "Unique Dimension Names"->"Unique Hierarchy Names"->"Level Depths"->"Unique Level Name".
MetadataException
public static void getMeasureInfo(Export export, java.util.List<java.lang.String> allUniqueMeasureNames, java.util.Map<java.lang.String,com.sas.iquery.metadata.business.QualifiedColumn> mapUniqueMeasureNamesToColumns, java.util.Map<java.lang.String,java.lang.String> mapUniqueMeasureNamesToLabels, java.util.Map<java.lang.String,java.lang.String> mapUniqueMeasureNamesToDescriptions, java.util.Map<java.lang.String,java.lang.String> mapUniqueMeasureNamesToFormats, java.util.Map<java.lang.String,java.lang.String> mapUniqueMeasureNamesToAggregations) throws MetadataException
export
- The export object to be inspected.allUniqueMeasureNames
- Populated with a list of unique measure names defined by the export source.mapUniqueMeasureNamesToColumns
- Populated with a mapping of unique measure names to the qualified columns in the output table.mapUniqueMeasureNamesToFormats
- Populated with a mapping of the unique measure names to the format to apply to the aggregated results of the measure.mapUniqueMeasureNamesToAggregations
- Populated with a mapping of the unique measure names to the aggregation name to used to aggregate that measure.
MetadataException
public static void getJoinInfo(Export export, java.util.Map<ExportDataSource,java.util.Map<com.sas.iquery.metadata.business.QualifiedColumn,java.util.Set<ExportJoin>>> joinedTableColumns) throws MetadataException
export
- The export object to be inspected.joinedTableColumns
- Populated with the list of key columns for a table. (keep track of each join by columns used.
MetadataException
public static java.util.Comparator<ExportDataSource> getExportDataSourceSorter()
|
Query |
|
| |||||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | |||||||||||||
SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |