MicroStrategy ONE
Enterprise Manager to Platform Analytics Attribute Mapping
As the new default monitoring tool for the MicroStrategy platform, Platform Analytics has a slightly different attribute structure to Enterprise Manager. See the table below to understand what Enterprise Manager terms mean in Platform Analytics.
Enterprise Manager (EM) Attribute Name |
EM Attribute Forms EM Attribute Elements |
Platform Analytics (PA) Attribute Name |
PA Attribute Forms PA Attribute Elements |
Notes |
---|---|---|---|---|
Ad-Hoc Indicator |
ID DESC NON-AD-HOC AD-HOC |
Object Status |
ID DESC Ad Hoc Hidden Deleted Visible |
In Platform Analytics, if an object is ad-hoc, the Object Type is Adhoc Object. Additionally, the Object Status is Ad hoc. |
Address |
ID DESC (email) Default (0/1) |
Recipient |
ID Address (email) Name GUID |
The Default address is derived in Platform Analytics by adding a filter on account@email address= recipient@email address. |
Attribute |
ID Name GUID Description Creation Date Modification Date Location Version Abbreviation Access Granted Number of Children Number of Parents Owner Name |
Object |
ID Name GUID Desc Creation timestamp Modification timestamp Location Version Component Objects Objects Owner Name |
Abbreviation and Access Granted are not available in Platform Analytics. Platform Analytics can provide analysis for the count of child/parent objects for all objects types, it is not limited to attributes as in Enterprise Manager. Count of Children in Platform Analytics: There is an OOTB metric called Component Objects, which calculates the children of an object. It is derived based on a count against the fact_object_component table. A sample report is: Attributes: Metadata, Project, Object, Object Type, Component Object Type Metrics: Component Objects Count of Parents in Platform Analytics: There is an OOTB metric called Objects, which calculates the parents of a component object. It is derived based on a count against the fact_object_component table. A sample report is: Attributes: Metadata, Project, Component Object, Component Object Type, Object Type, Metrics: Objects |
Attribute Form |
ID Name GUID Description Creation Date Modification Date Location Version Abbreviation Access Granted Datatype ID Datatype Description Owner Name |
Object |
ID Name GUID Desc Creation timestamp Modification timestamp Location Version Owner Name |
Abbreviation, Access Granted, Datatype ID, and Datatype Description are not available in Platform Analytics. |
Cancelled Indicator |
ID DESC NOT CANCELLED CANCELLED |
Status Category |
ID DESC Successful Job xxx cancelled |
If the execution is cancelled, the Platform Analytics Status Category is Job xxx cancelled. |
Child Job Indicator |
ID DESC USER DATA REQUEST JOB DATASET CHILD JOB |
Child Jobs (metric) Standalone Report Executions (metric) |
In Platform Analytics, the end-user can show only report jobs triggered by document executions using the two metrics noted. Additionally, you can use a filter on Parent Job if the ID is -1. If the Parent Job ID is -1, it means the user directly executed the report and did not execute it as a dataset of a document or dashboard. |
|
Column |
ID Name GUID Description Creation Date Modification Date Location Version Abbreviation Access Granted Datatype ID Datatype Description Owner Name |
Object/Column |
ID Name GUID Desc Creation timestamp Modification timestamp Location Version Owner Name |
Abbreviation and Access Granted are not available in Platform Analytics. In Platform Analytics, Datatype ID and Datatype Description are appended as suffixes to the column name. |
Configuration Object Owner |
ID GUID Description Location Version Abbreviation |
Derived attributes. The owner_id form of all configuration objects. |
||
Connection Source |
ID DESC SDESC: IF((Position("MICROSTRATEGY", [EM_CONNECT_DESC]) = 0), [EM_CONNECT_DESC], SubStr([EM_CONNECT_DESC], 15, (Length([EM_CONNECT_DESC]) - 14))) |
Session Source |
ID DESC |
|
Consolidation |
ID Name GUID Description Creation Date Modification Date Location Version Abbreviation Access Granted Owner Name |
Object |
ID Name GUID Desc Creation timestamp Modification timestamp Location Version Owner Name |
Abbreviation and Access Granted are not available in Platform Analytics. |
Contact |
ID (GUID) DESC |
Recipient |
ID GUID Name |
|
Cube Hit Indicator |
ID DESC CUBE EXECUTION DB EXECUTION |
Action Type |
ID DESC |
In Platform Analytics, the filter named Action Type = Cache Hit shows only executions that hit a cache. If the report, document, or dashboard execution is done against the database, it is not a Cache Hit and falls under the Action Type = Execution. |
Custom Group |
ID Name GUID Description Creation Date Modification Date Location Version Abbreviation Access Granted Owner Name |
Object |
ID Name GUID Desc Creation timestamp Modification timestamp Location Version Owner Name |
Abbreviation and Access Granted are not available in Platform Analytics. |
Day |
ID (2016-12-01) DESC (12/01/2016 Thursday) Short Desc (12/01/2016 Thu) Date (2016-12-01) |
Date |
ID (2017-01-01) Day of Week@desc (Wednesday) Day of Week@short desc (Wed) |
Day of Week (element) is a standalone attribute in Platform Analytics. |
Datamart Report |
ID DESC REGULAR REPORT DATAMART REPORT |
Object Type |
ID DESC Datamart Report |
In Platform Analytics, the Object Type = Datamart Report. If the report is not a datamart report, it is another object type. For example, Grid Report, Graph Report, or Transaction Services Report. |
DB Connection |
ID Name GUID Description Creation Date Modification Date Location Version Abbreviation Access Granted Connection String Database Name Database Type Database Version Default Database User |
Database Connection |
ID Name GUID Description Creation timestamp Modification timestamp Version Database Name Database Type (attribute) Database Version (attribute) Data Source Name |
Access Granted, Abbreviation, Location, and Connection Strings are not available in Platform Analytics. |
DB Instance |
ID Name GUID Description Creation Date Modification Date Location Version Abbreviation Access Granted |
Database Instance |
ID Name GUID Description Creation timestamp Modification timestamp Version |
Access Granted, Abbreviation, and Location are not available in Platform Analytics. |
Device |
ID Name GUID Description Creation Date Modification Date Location Version Abbreviation Access Granted |
Subscription Device |
ID Name GUID Description Creation Timestamp Modification Timestamp Version Status |
Location, Abbreviation, and Access Granted are not available in Platform Analytics. |
Delivery Type |
ID DESC FILE PRINTER CUSTOM INBOX CLIENT CACHE MOBILE ALL |
Subscription Type |
ID DESC File History List Cache Update Mobile Personal View FTP |
In Platform Analytics, elements are updated to be in-line with what you see in the interface. For example, what Enterprise Manage previously called INBOX is now History List Message. The data granularity is the same, but the descriptions have been updated. |
Document |
ID Name GUID Description Creation Date Modification Date Location Version Abbreviation Access Granted Owner Name |
Object |
ID Name GUID Desc Creation timestamp Modification timestamp Location Version Owner Name |
Abbreviation and Access Granted are not available in Platform Analytics. |
Document Job |
CID (Compound) ID Session ID ERROR DESC Timestamps (Compound) EXEC REQ TS EXEC START TS EXEC FINISH TS |
Multiple Attriutes/Metrics |
Job@ID (Job attribute) Session@GUID (Session attribute) Status@desc (Status attribute) Initial Queue Duration (ms) (fact) Action Start Timestamp UTC (metric) Action Finish Timestamp UTC (metric) |
|
Document Job Step Sequence |
ID (Compound) StepID JobID SessionID Timestamps (compound) STEP_ST_TS STEP_FN_TS |
Job Step Sequence |
ID Job@ID (Job attribute) Session@GUID (Session attribute) Job Step Start Timestamp (UTC) (fact) Job Step Finish Timestamp (UTC) (fact) |
|
Document Job Step Type |
ID DESC UNKNOWN HTML RENDERING |
Job Step Type |
ID DESC |
In Platform Analytics, document and report step types are combined into a single attribute called Job Step Type. |
Document Type |
ID DESC HTML DOCUMENT Dashboard Document |
Object Type |
ID DESC HTML Document Dashboard Document Report Writing Document |
In Platform Analytics, dashboard is renamed to dashboard. |
Error |
ID (Job error code) DESC (Exact error message) |
Status/Status Category |
|
Status Category provides a high-level grouping to analyze individual error messages based on the JobErrorCode. Status is the exact error message that is recorded in the logs. Most errors in the logs are recorded at the unique job and session level. Therefore, when trying to determine what is the "most frequent error," which occurs in my MicroStrategy environment, an aggregate count of errors at the status level almost always results in 1. To improve the reporting for this use case, Platform Analytics can aggregate the telemetry the at the level of Status Category. |
Error Indicator |
ID DESC NO ERROR ERROR |
Status/Status Category |
ID DESC Successful |
If you are trying to analyze successful actions in Platform Analytics, use the OOTB filter called Action Status = Success. If you are trying to analyze failed actions in Platform Analytics, use the OOTB called Failed MicroStrategy Actions. Status Category provides a high-level grouping to analyze individual error messages based on the JobErrorCode. Status is the exact error message that is recorded in the logs. Most errors in the logs are recorded at the unique job and session level. Therefore, when trying to determine what is the "most frequent error," which occurs in my MicroStrategy environment, an aggregate count of errors at the status level almost always results in 1. To improve the reporting for this use case, Platform Analytics can aggregate the telemetry the at the level of Status Category. |
Event |
ID Name GUID Description Creation Timestamp Modification Timestamp Location Version Abbreviation Access Granted |
Event |
ID Name GUID Description Creation timestamp Modification timestamp Version |
Access Granted, Abbreviation, and Location are not available in Platform Analytics. |
Export Indicator |
ID DESC NO EXPORT EXPORTED |
Action Type |
ID DESC |
In Platform Analytics tracks whether the execution was exported and what type of export action occurred (Export to Excel, Export to CSV, Export to PDF, etc). The MSTR file download actions is also tracked, along with the export telemetry for documents, dashboards, and reports objects. In Platform Analytics, you can use both the OOTB filter and metric called Export Engine Jobs to analyze export telemetry. |
Fact |
ID Name GUID Description Creation Date Modification Date Location Version Abbreviation Access Granted Datatype ID Datatype Description Owner Name |
Object |
ID Name GUID Description Creation timestamp Modification timestamp Location Version Owner Name |
Access Granted, Abbreviation, Datatype ID, and Datatype Description are not available in Platform Analytics. |
Filter |
ID Name GUID Description Creation Date Modification Date Location Version Abbreviation Access Granted Owner Name |
Object |
ID Name GUID Desc Creation timestamp Modification timestamp Location Version Owner Name |
Access Granted and Abbreviation are not available in Platform Analytics. |
Folder |
ID |
Object |
Location |
In Platform Analytics, the object@location form of the Object attribute contains the entire folder path. |
Hour |
ID (22) DESC (22-23) 24 Hour Desc (10 PM - 11 PM) |
Hour |
ID (22) DESC (10PM) |
|
Inbox Action |
ID Start Time Inbox Message ID Session ID DESC |
Multiple Attributes |
Timestamp@ID (Timestamp attribute) History List Message@GUID (History List Message attribute) Session@GUID (Session attribute) history list message@status (History List Message attribute) |
|
Inbox Action Type |
ID DESC ADD REMOVE BATCH REMOVE RENAME CHANGE STATUS EXECUTE REQUESTED |
Action Type |
ID DESC Create History List Message (add) Delete History List Message (remove and batch remove) Rename History List Message (rename) Change History List Message Status (change status) Execute History List Message View History List Message (execute) |
|
Inbox Message |
ID DESC User-defined name Creation Date |
History List Message |
ID GUID Title Creation timestamp Modification timestamp Status |
|
Intelligence Server Definition |
ID Name GUID Description Creation Date Modification Date Location Version Abbreviation Access Granted |
Intelligence Server Definition |
ID Name GUID Creation timestamp Modification timestamp Version |
Description, Access Granted, Abbreviation, and Location are not available in Platform Analytics. |
Intelligence Server Machine |
ID Port Name |
Intelligence Server Instance |
ID Port I-server Machine Name |
In Platform Analytics, there are three attributes to represent the Intelligence Server configuration: Intelligence Server Machine, Intelligence Server Instance, and Intelligence Server Definition. A single Intelligence Server Machine can host multiple Intelligence Server instances running on different ports. For this reason, the attribute name is Intelligence Server Instance. The Intelligence Server Machine is represented as a separate attribute without the port. |
N/A |
N/A |
Intelligence Server Machine |
ID Name IP |
In Platform Analytics, there are three attributes to represent the Intelligence Server configuration: Intelligence Server Machine, Intelligence Server Instance, and Intelligence Server Definition. A single Intelligence Server Machine can host multiple Intelligence Server instances running on different ports. For this reason, the attribute name is Intelligence Server Instance. The Intelligence Server Machine is represented as a separate attribute without the port. |
Intelligent Cube |
ID Name GUID Description Creation Date Modification Date Location Version Abbreviation Access Granted Owner Name |
Object |
ID Name GUID Desc Creation timestamp Modification timestamp Location Version Owner Name |
Abbreviation and Access Granted are not available in Platform Analytics. |
Intelligent Cube Action Type |
ID DESC CUBE PUBLISH CUBE VIEW HIT CUBE DYNAMIC SOURCE HIT CUBE DESTROY CUBE ACTIVATE CUBE DEACTIVATE CUBE LOAD CUBE UNLOAD CUBE DOCUMENT HIT REPUBLISH CUBE DATA VIA UPDATE REPUBLISH CUBE DATA VIA APPEND REPUBLISH CUBE DATA DYNAMICALLY REPUBLISH CUBE DATA VIA UPSERT REFRESH CUBE DATA BY APPENDING VIA FILTER REFRESH CUBE DATA BY DELETING VIA FILTER REFRESH CUBE DATA BY UPDATING VIA FILTER REFRESH CUBE DATA BY UPSERTING VIA FILTER REFRESH CUBE DATA BY APPENDING VIA REPORT REFRESH CUBE DATA BY DELETING VIA REPORT REFRESH CUBE DATA BY UPSERTING VIA REPORT |
Action Type |
ID DESC Cube Publish Execute View Report with Cube Cache Hit Delete Cube Cache Activate Cube Cache Deactivate Cube Cache Load Cube Cache Unload Cube Cache Execute Document with Cube Cache Hit Republish cube data via update Republish cube data via append Republish cube data dynamically Republish cube data via upsert Refresh cube data by appending via filter Refresh cube data by deleting via filter Refresh cube data by updating via filter Refresh cube data by upserting via filter Refresh cube data by appending via report Refresh cube data by deleting via report Refresh cube data by updating via report Refresh cube data by upserting via report Republish DI Cube with Multi-refresh Policies |
The same action types exist in Platform Analytics, but the descriptions and elements have been updated to reflect the current supported cube actions in MicroStrategy. For example, Platform Analytics has removed obsolete actions (cube destroy) and add new actions (Republish DI Cube with Multi-refresh Policies). |
Intelligent Cube Instance | ID (GUID) | Cache |
ID Cache Instance GUID |
|
Intelligent Cube Type |
ID DESC BASE REPORT WORKING SET REPORT PRIVATE BASE REPORT REPORT SERVICES BASE REPORT CSQL PRE EXEC REPORT OLAP CUBE REPORT OLAP VIEW REPORT INCREMENTAL REFRESH REPORT |
Object Type |
ID DESC Report OLAP Cube Intelligence Cube Report Incremental Refresh Report Data Import Cube |
Platform Analytics has removed the obsolete object types that are no longer supported in MicroStrategy (i.e. PRIVATE BASE REPORT) and added Data Import Cubes to the Object Types. |
Intelligence Server Cluster | ID | Intelligence Server Cluster |
ID DESC |
|
Job Error Code |
CID (Composite ID Form because can be same JOB ERROR CODES with different DESCRIPTIONS) Job Error Code Error Description |
Status Category |
ID DESC |
Status Category provides a high-level grouping to analyze individual error messages based on the JobErrorCode. Status is the exact error message that is recorded in the logs. Most errors in the logs are recorded at the unique job and session level. Therefore, when trying to determine what is the "most frequent error," which occurs in my MicroStrategy environment, an aggregate count of errors at the status level almost always results in 1. To improve the reporting for this use case, Platform Analytics can aggregate the telemetry the at the level of Status Category. |
Metadata |
ID DESC (GUID) |
Metadata |
ID GUID Metadata Connection String |
|
Metric |
ID Name GUID Description Creation Date Modification Date Location Version Abbreviation Access Granted Owner Name |
Object |
ID Name GUID Desc Creation timestamp Modification timestamp Location Version Owner Name |
Abbreviation and Access Granted are not available in Platform Analytics. |
Minute |
ID (2) DESC (12:02 AM - 12:01 AM) 24 Hour Desc (00:02 - 00:03) |
Minute |
ID (2) DESC (00:02) |
|
Month |
ID (201701) DESC (2017 Jan) Long Desc (2017 January) |
Month |
ID (201701) DESC (January, 2017) |
|
Month of Year |
ID (1) DESC (January) Short Desc (Jan) |
Month of Year |
ID (1) DESC (Janurary) Short DESC (Jan) |
|
Object Creation Date |
ID (2017-01-01) DESC (01/01/2017 Sunday) |
Object Creation Date |
ID (2017-01-01) |
|
Object Exists Status |
ID Desc ALREADY DELETED FROM THE MD REPOSITORY EXISTS IN THE MD REPOSITORY |
Object Status |
ID DESC Ad Hoc Hidden Deleted Visible |
Platform Analytics considers "hidden" as an element of the Object Status rather than a separate attribute. |
Object Hidden Status |
ID DESC VISIBLE HIDDEN |
Object Status |
ID DESC Ad Hoc Hidden Deleted Visible |
Platform Analytics considers "hidden" as an element of the Object Status rather than a separate attribute. |
Object Modification Date |
ID (20050101) DESC: 1/1/2005 LDESC: 01/01/2005 Saturday |
Object Modification Date | ID (2017-08-16) | |
Owner |
ID Name GUID Description Location Abbreviation |
Object Owner |
ID Name GUID Description Version Creation timestamp Modification timestamp Status Login |
Access Granted, Abbreviation, and Location are not available in Platform Analytics. |
Project |
ID Name GUID Description Creation Date Modification Date Location Version Abbreviation Access Granted |
Project |
ID Name GUID Description Creation timestamp Modification timestamp Version Status |
Access Granted, Abbreviation, and Location are not available in Platform Analytics. |
Prompt |
ID Name GUID Description Creation Date Modification Date Location Version Abbreviation Access Granted Owner Name |
Prompt/Object |
ID Name GUID Desc Creation timestamp Modification timestamp Location Version Owner Name |
Access Granted and Abbreviation are not available in Platform Analytics. In Platform Analytics, prompts are tracked in two lookup tables/attributes in order to support the analysis of prompt answers by joining on fact_prompt_answers. |
Prompt Answer |
CID REP_JOB_ID PR_ORDER_ID SEQUENCE SESSION_ID Prompt Answers Count of Answers |
Multiple Attributes/Facts |
Job@ID (Job attribute) Prompt Answer Sequence (fact) Session@GUID (Session attribute) Prompt Answer@DESC (Prompt Answer attribute) Prompt Actions (fact) |
SEQUENCE is not available in Platform Analytics. |
Prompt Type |
ID STRING ELEMENTS DOUBLE OBJECTS |
Prompt Type |
ID DESC Attribute Element Prompt Object Prompt Prompt Value Prompt Embedded Prompt |
|
Quarter of Year |
ID DESC (1st Quarter) Short Desc (Q1) |
Derived Attribute |
Definition: Quarter([Date@ID]) |
In Platform Analytics, the quarter of year can be created using a derived attribute in MicroStrategy based off the Date attribute. |
Report |
ID Name GUID Description Creation Date Modification Date Location Version Abbreviation Access Granted Owner Name |
Object |
ID Name GUID Desc Creation timestamp Modification timestamp Location Version Owner Name |
Access Granted and Abbreviation are not available in Platform Analytics. |
Report Job |
CID Job ID Session ID Error DESC No_of_prompts PRIORITIZATION Priority Number Assigned Cost TIMESTAMPS EXEC_REQ_TS EXEC_START_TS EXEC_FN_TS |
Multiple Facts/Attributes |
Job@ID (Job attribute) Session@GUID (Session attribute) Status@DESC (Status attribute) <derived> Job Priority@DESC (Job Priority attribute) Initial queue Duration (ms) (fact) Action Start Timestamp UTC (metric) Action Finish Timestamp UTC (metric) |
Assigned Cost is not available in Platform Analytics. To derive the No-of_prompts per report job, build a report with the following definition:
|
Report Job SQL Pass |
CID SQL Pass Sequence ID Report Job ID Session ID DESC DB ERROR MESSAGE Timestamps EXEC_ST_TS EXEC_FN_TS |
Multiple Facts/Attributes |
SQL Pass Sequence (fact) Job@ID (Job attribute) Session@GUID (Session attribute) SQL Pass@DESC (SQL Pass attribute) Database Error Message@desc (attribute) SQL Pass Start Timestamp (UTC) (fact) SQL Pass Start Timestamp (UTC) (fact) |
|
Report Job SQL Pass Type |
ID DESC |
SQL Pass Type |
ID DESC |
|
Report Job Step Sequence |
ID Step ID Job ID Session ID Timestamps EXEC_ST_TS EXEC_FN_TS |
Multiple Facts/Attributes |
SQL Pass Sequence (fact) Job@ID (Job attribute) Sesion@GUID (Session attribute) Job Step Start Timestamp (UTC) (fact) Job Step Finish Timestamp (UTC) (fact) |
|
Report Job Step Type |
ID DESC |
Job Step Type |
ID DESC |
|
Report Type |
ID DESC RELATIONAL MDX CUSTOM SQL FREE FORM CUSTOM SQL WIZARD FLAT FILE |
Object Extended Type |
ID DESC Relational MDX Free Form SQL Custom SQL Wizard Data Import Data Import Excel File Data Import Text File Custom SQL Data Import Table Data Import OAuth Data Import SalesForce Data Import Google Drive Data Import Drop Box Data Import Google Analytics Data Import Google Big Query Data Import Google Big Query FFSQL Data Import Twitter Data Import Facebook Data Import Google Big Query Single Table Data Import Custom SQL Wizard Data Import Single Table Data Import Open Refine Data Import Remote Data Source Data Import Spark Server Data Import |
|
Report/Document Indicator |
ID DESC REPORT DEFINITION DOCUMENT DEFINITION |
Object Category |
ID DESC Reports Documents |
|
Schedule |
ID Name GUID Description Creation Date Modification Date Location Version Abbreviation Access Granted |
Schedule |
ID Name GUID Description Creation timestamp Modification timestamp Version Status |
Access Granted, Abbreviation, and Location are not available in Platform Analytics. |
Schedule Indicator |
ID DESC NON-SCHEDULED SCHEDULED |
Session Source |
ID DESC Scheduler |
In Platform Analytics, if the execution was a result of a scheduled job, the Session Source will be Scheduled. To remove all scheduled jobs from the analysis, add a filter on Session Source != Scheduler. The end-user can also utilize the OOTB filters Non Subscriptions or Subscriptions to limit the data accordingly. |
Security Filter |
ID Name GUID Description Creation Date Modification Date Location Version Abbreviation Access Granted Owner Name |
Security Filter |
ID Name GUID Desc Creation timestamp Modification timestamp Location Owner Name |
Access Granted, Abbreviation, and Location are not available in Platform Analytics. |
Session |
ID (GUID) Connection Timestamp Disconnection Timestamp |
Session |
ID GUID |
Platform Analytics stores the connection/disconnect actions in the fact_access_transaction table. Therefore, the Timestamp attribute plus the Action Type are used to represent the connection and disconnection timestamp. The same level of analysis can be derived from the below sample attributes/filters: Attributes: Session, Timestamp Filter: "Action Type = Project Login" or "Action Type = Project Logout" |
SQL Execution Indicator |
ID DESC NO SQL EXECUTED SQL EXECUTED |
Action Type/Action Category |
|
Only Cubes and Reports objects can generate SQL. Using the OOTB filter Action Category = Cube Executions returns a list of cubes that generate SQL. Using the OOTB filter Report Executions returns a list of reports that generate SQL. |
Subscription |
ID DESC (subscription name) |
Subscription |
ID Name GUID Creation timestamp Modification timestamp Status Project Name (to support CM delete command) |
|
Table |
ID Name GUID Description Creation Date Modification Date Location Version Abbreviation Access Granted Table Size Table Prefix Owner Name |
Object |
ID Name GUID Desc Creation timestamp Modification timestamp Location Version <appended as a suffix to the table name> <appended as a prefix to the table name> Owner Name |
Access Granted, Abbreviation, and Location are not available in Platform Analytics. |
Template |
ID Name GUID Description Creation Date Modification Date Location Version Abbreviation Access Granted Owner Name |
Object |
ID Name GUID Desc Creation timestamp Modification timestamp Location Version Owner Name |
Access Granted and Abbreviation are not available in Platform Analytics. |
Transformation |
ID Name GUID Description Creation Date Modification Date Location Version Abbreviation Access Granted Owner Name |
Object |
ID Name GUID Desc Creation timestamp Modification timestamp Location Version Owner Name |
Access Granted and Abbreviation are not available in Platform Analytics. |
User |
ID Name GUID Description Creation Date Modification Date Location Abbreviation Access Granted Enabled Status PWD Expiration Freq Allow Change PWD PWD Expiration Date Metadata |
Account/User |
ID Name GUID Description Creation timestamp Modification timestamp Account Status (Attribute) Password Expiration Frequency Password Change Allowed Password Expiration Date Password Change Required Standard Auth Allowed Trusted Auth User Id Version Login LDAP Link NT Link WH Link |
Access Granted, Abbreviation, and Location are not available in Platform Analytics. |
User Group |
ID Name GUID Description Creation Date Modification Date Location Version Abbreviation Access Grated |
User Group |
ID Name GUID Description Creation timestamp Modification timestamp Version Status |
Access Granted, Abbreviation, and Location are not available in Platform Analytics. |
User Group (Parent) |
ID DESC |
User Group |
ID Name GUID Description Creation timestamp Modification timestamp Status |
|
Week of year |
ID (201701) Week Start Date (2017-01-02 00:00:00) Week Finish Date (2017-01-08 23:59:59) |
Week |
ID (201701) Week Begin Date (2017-01-02) Week End Date (2017-01-08) Week Range (01/02/2017-01/08/2017) |
|
Weekday |
ID (1) DESC (Monday) Short Desc (Mon) |
Day of Week |
ID (1) DESC (Monday) |
|
Year |
ID (2017) DESC (Year 2017) Short Desc (Y 2017) |
Year |
ID (2017) |
|
Database Error Indicator |
ID DESC NO DB ERROR DB Error |
Status |
Database Error Indicator 0 1 |
|
Delivery Status Indicator |
ID DESC FAILED SUCCESSFUL |
Status |
ID DESC |
|
Element Load Indicator |
ID DESC REGULAR REPORT ELEMENT LOAD REPORT |
Object Type |
ID DESC Element Load Object |
|
Quarter |
ID (20171) DESC (2017 Quarter 1) Short Desc (2017 Q1) |
Quarter |
ID (20171) DESC (Q1 2017) |
|
Cache Creation Indicator |
ID DESC NO CACHE CREATION CACHE CREATION |
Action Category |
ID DESC Cache Creation |
|
Cache Type |
ID DESC NO CACHE HIT SERVER CACHE DEVICE CACHE APPLICATION CACHE |
Cache Type |
ID DESC Report Cache Intelligence Cube Cache |
|
DB Table |
ID Name GUID Description Creation Date Modification Date Location Version Abbreviation Access Granted Owner Name |
DB Table |
ID Name GUID Description Creation timestamp Modification timestamp Location Version Owner@id |
Access Granted and Abbreviation are not available in Platform Analytics. |
SQL Clause Type |
ID DESC SELECT SELECT GROUP BY SELECT AGGREGATE FROM WHERE ORDER BY |
SQL Clause Type |
ID DESC Select Select Group By Select Aggregate From Where Order By |
|
Job Priority Map |
ID DESC UNKNOWN LOW PRIORITY MEDIUM PRIORITY HIGH PRIORITY |
Job Priority |
ID DESC Low Priority Medium Priority High Priority |
|
Job Priority Number |
ID |
Job Priority |
ID DESC Low Priority Medium Priority High Priority |
|
Hierarchy |
ID Name GUID Description Creation Date Modification Date Location Version Abbreviation Access Granted Owner Name |
Object |
ID Name GUID Desc Creation timestamp Modification timestamp Location Version Owner Name |
Access Granted and Abbreviation are not available in Platform Analytics. |