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

EMAIL

FILE

PRINTER

CUSTOM

INBOX

CLIENT

CACHE

MOBILE

ALL

Subscription Type

ID

DESC

Email

File

Print

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:

  • Attributes: Metadata, Project, Object
  • Metrics: Component Objects
  • Filter: "Object Category = Reports" and "Component Object Category = Prompt"

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

Email

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.