Tiempo de lectura:11 Minutos, 39 Segundos

Como ya conocerás MicroStrategy Platform Analytics (PA) es la nueva herramienta de monitoreo por defecto en sustitución de Enterprise Manager (EM). Esto conlleva ligeros cambios en el modelo de datos. En el siguiente cuadro se muestra la equivalencia de atributos entre Platform Analytics y Enterprise Manager.

(EM) Nombre(EM) Representación
– (EM) Elementos
(PA) Nombre(PA) Representación
– (PA) Elementos
Ad-Hoc IndicatorID
DESC
– NON-AD-HOC
– AD-HOC
Object StatusID
DESC
– Ad Hoc
– Hidden
– Deleted
– Visible
AddressID
DESC (email)
– Default (0/1)
RecipientID
Address (email)
Name
GUID
AttributeID
Name
GUID
Description
Creation
Date
Modification Date
Location
Version
Abbreviation
Access Granted
Number of Children
Number of Parents
Owner Name
ObjectID
Name
GUID
Desc
Creation timestamp
Modification timestamp
Location
Version
Component Objects
Objects
Owner Name
Attribute FormID
Name
GUID
Description
Creation Date
Modification Date
Location
Version
Abbreviation
Access Granted
Datatype ID
Datatype Description
Owner Name
ObjectID
Name
GUID
Desc
Creation timestamp
Modification timestamp
Location
Version
Owner Name
Cancelled IndicatorID
DESC
– NOT CANCELLED
– CANCELLED
Status CategoryID
DESC
– Successful
– Job xxx cancelled
Child Job IndicatorID
DESC
– USER DATA REQUEST JOB
– DATASET CHILD JOB
Child Jobs (metric)



Standalone Report Executions (metric)
 
ColumnID
Name
GUID
Description
Creation Date
Modification Date
Location
Version
Abbreviation
Access Granted
Datatype ID
Datatype Description
Owner Name
Object/ColumnID
Name
GUID Desc
Creation timestamp
Modification timestamp
Location
Version
Owner Name
Configuration Object OwnerID
GUID
Description
Location
Version
Abbreviation
Derived attributes.

The owner_id form of all configuration objects.
 
Connection SourceID
DESC
Session SourceID
DESC
ConsolidationID
Name
GUID
Description
Creation Date
Modification Date
Location
Version
Abbreviation
Access Granted
Owner Name
ObjectID
Name
GUID
Desc
Creation timestamp
Modification timestamp
Location
Version
Owner Name
ContactID (GUID)
DESC
RecipientID
GUID
Name
Cube Hit IndicatorID
DESC
– CUBE EXECUTION
– DB EXECUTION
Action TypeID
DESC
Custom GroupID
Name
GUID
Description
Creation Date
Modification Date
Location
Version
Abbreviation
Access Granted
Owner Name
ObjectID
Name
GUID
Desc
Creation timestamp
Modification timestamp
Location
Version
Owner Name
DayID (2016-12-01)
DESC (12/01/2016 Thursday)
Short Desc (12/01/2016 Thu)
Date (2016-12-01)
DateID (2017-01-01)
Day of Week@desc (Wednesday)
Day of Week@short desc (Wed)
Datamart ReportID
DESC
REGULAR REPORT
DATAMART REPORT
Object TypeID
DESC
Datamart Report
DB ConnectionID
Name
GUID
Description
Creation Date
Modification Date
Location
Version
Abbreviation
Access Granted
Connection String
Database Name
Database Type
Database Version
Default Database User
Database ConnectionID
Name
GUID
Description
Creation timestamp
Modification timestamp
Version
Database Name
Database Type (attribute)
Database Version (attribute)
Data Source Name
DB InstanceID
Name
GUID
Description
Creation Date
Modification Date
Location
Version
Abbreviation
Access Granted
Database InstanceID
Name
GUID
Description
Creation timestamp
Modification timestamp
Version
DeviceID
Name
GUID
Description
Creation Date
Modification Date
Location
Version
Abbreviation
Access Granted
Subscription DeviceID
Name
GUID
Description
Creation Timestamp
Modification Timestamp
Version
Status
Delivery TypeID
DESC
– EMAIL
– FILE
– PRINTER
– CUSTOM
– INBOX
– CLIENT
– CACHE
– MOBILE
– ALL
Subscription TypeID
DESC
– Email
– File
– Print
– History List
– Cache Update
– Mobile
– Personal View
– FTP
DocumentID
Name
GUID
Description
Creation Date
Modification Date
Location
Version
Abbreviation
Access Granted
Owner Name
ObjectID
Name
GUID
Desc
Creation timestamp
Modification timestamp
Location
Version
Owner Name
Document JobCID (Compound)
ID
Session ID
ERROR DESC
Timestamps (Compound)
EXEC REQ TS
EXEC START TS
EXEC FINISH TS
Multiple Attriutes/MetricsJob@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 SequenceID (Compound)
StepID
JobID
SessionID
Timestamps (compound)
STEP_ST_TS
STEP_FN_TS
Job Step SequenceID Job@ID (Job attribute) Session@GUID (Session attribute)
Job Step Start Timestamp (UTC) (fact)
Job Step Finish Timestamp (UTC) (fact)
Document Job Step TypeID
DESC
UNKNOWN
HTML RENDERING
Job Step TypeID
DESC
Document TypeID
DESC
– HTML
– DOCUMENT
– Dashboard
– Document
Object TypeID
DESC
– Documento HTML
– Dossier
– Report Writing Document
– Documento
ErrorID (Job error code)
DESC (Exact error message)
Status/Status Category 
Error IndicatorID
DESC
– NO ERROR
– ERROR
Status/Status CategoryID
DESC
– Successful
EventID
Name
GUID
Description
Creation Timestamp
Modification Timestamp
Location
Version
Abbreviation
Access Granted
EventID
Name
GUID
Description
Creation timestamp
Modification timestamp
Version
Export IndicatorID
DESC
– NO EXPORT
– EXPORTED
Action TypeID
DESC
FactID
Name
GUID
Description
Creation Date
Modification Date
Location
Version
Abbreviation
Access Granted
Datatype ID
Datatype Description
Owner Name
ObjectID
Name
GUID
Description
Creation timestamp
Modification timestamp
Location
Version
Owner Name
FilterID
Name
GUID
Description Creation
Date Modification
Date Location
Version
Abbreviation
Access Granted
Owner Name
ObjectID
Name
GUID
Desc
Creation timestamp
Modification timestamp
Location
Version
Owner Name
FolderIDObjectLocation
HourID (22)
DESC (22-23)
24 Hour Desc (10 PM – 11 PM)
HourID (22)
DESC (10PM)
Inbox ActionID
– Start Time
– Inbox Message ID
– Session ID
DESC
Multiple AttributesTimestamp@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 TypeID
DESC
– ADD
– REMOVE
– BATCH REMOVE
– RENAME
– CHANGE STATUS
– EXECUTE
– REQUESTED
Action TypeID
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 MessageID
DESC
User-defined name
Creation Date
History List MessageID
GUID
Title
Creation timestamp
Modification timestamp
Status
Intelligence Server DefinitionID
Name
GUID
Description
Creation Date
Modification Date
Location
Version
Abbreviation
Access Granted
Intelligence Server DefinitionID
Name
GUID
Creation timestamp
Modification timestamp
Version
Intelligence Server MachineID
Port
Name
Intelligence Server InstanceID
Port
I-server Machine Name
N/AN/AIntelligence Server MachineID
Name
IP
Intelligent CubeID
Name
GUID
Description
Creation Date
Modification Date
Location
Version
Abbreviation
Access Granted
Owner Name
ObjectID
Name
GUID
Desc
Creation timestamp
Modification timestamp
Location
Version
Owner Name
Intelligent Cube Action TypeID
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 TypeID
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
Intelligent Cube InstanceID (GUID)CacheID
Cache Instance GUID
Intelligent Cube TypeID
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 TypeID
DESC
– Report
– OLAP Cube
– Intelligence Cube Report
– Incremental Refresh Report
– Data Import Cube
Intelligence Server ClusterIDIntelligence Server ClusterID
DESC
Job Error CodeCID (Composite ID Form because can be same JOB ERROR CODES with different DESCRIPTIONS)
– Job Error Code
– Error Description
Status CategoryID
DESC
MetadataID
DESC (GUID)
MetadataID
GUID
Metadata Connection String
MetricID
Name
GUID
Description
Creation Date
Modification Date
Location
Version
Abbreviation
Access Granted
Owner Name
ObjectID
Name
GUID
Desc
Creation timestamp
Modification timestamp
Location
Version
Owner Name
MinuteID (2)
DESC (12:02 AM – 12:01 AM)
24 Hour Desc (00:02 – 00:03)
MinuteID (2)
DESC (00:02)
MonthID (201701)
DESC (2017 Jan)
Long Desc (2017 January)
MonthID (201701)
DESC (January, 2017)
Month of YearID (1)
DESC (January)
Short Desc (Jan)
Month of YearID (1) DESC (Janurary)
Short DESC (Jan)
Object Creation DateID (2017-01-01)
DESC (01/01/2017 Sunday)
Object Creation DateID (2017-01-01)
Object Exists StatusID
Desc
– ALREADY DELETED FROM THE MD REPOSITORY
– EXISTS IN THE MD REPOSITORY
Object StatusID
DESC
– Ad Hoc
– Hidden
– Deleted
– Visible
Object Hidden StatusID
DESC
– VISIBLE
– HIDDEN
Object StatusID
DESC
– Ad Hoc
– Hidden
– Deleted
– Visible
Object Modification DateID (20050101)
DESC: 1/1/2005
LDESC: 01/01/2005 Saturday
Object Modification DateID (2017-08-16)
OwnerID
Name
GUID
Description
Location
Abbreviation
Object OwnerID
Name
GUID
Description
Version
Creation timestamp
Modification timestamp
Status
Login
ProjectID
Name
GUID
Description
Creation Date
Modification Date
Location
Version
Abbreviation
Access Granted
ProjectID
Name
GUID
Description
Creation timestamp
Modification timestamp
Version
Status
PromptID
Name
GUID
Description
Creation Date
Modification Date
Location
Version
Abbreviation
Access Granted
Owner Name
Prompt/ObjectID
Name
GUID
Desc
Creation timestamp
Modification timestamp
Location
Version
Owner Name
Prompt AnswerCID
– REP_JOB_ID
– PR_ORDER_ID
– SEQUENCE
– SESSION_ID
Prompt Answers
Count of Answers
Multiple Attributes/FactsJob@ID (Job attribute)
Prompt Answer Sequence (fact)
Session@GUID (Session attribute)
Prompt Answer@DESC (Prompt Answer attribute)
Prompt Actions (fact)
Prompt TypeID
– STRING
– ELEMENTS
– DOUBLE
– OBJECTS
Prompt TypeID
DESC
– Attribute Element Prompt
– Object Prompt
– Prompt
– Value Prompt
– Embedded Prompt
Quarter of YearID
DESC (1st Quarter)
Short Desc (Q1)
Derived AttributeDefinition: Quarter([Date@ID])
ReportID
Name
GUID
Description
Creation Date
Modification Date
Location
Version
Abbreviation
Access Granted
Owner Name
ObjectID
Name
GUID
Desc
Creation timestamp
Modification timestamp
Location
Version
Owner Name
Report JobCID
– 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/AttributesJob@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)
Report Job SQL PassCID
– SQL Pass Sequence
– ID Report Job ID
– Session ID
DESC
DB ERROR MESSAGE Timestamps
– EXEC_ST_TS
– EXEC_FN_TS
Multiple Facts/AttributesSQL 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 TypeID
DESC
SQL Pass TypeID
DESC
Report Job Step SequenceID
– Step ID
– Job ID
– Session ID
Timestamps
– EXEC_ST_TS
– EXEC_FN_TS
Multiple Facts/AttributesSQL 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 TypeID
DESC
Job Step TypeID
DESC
Report TypeID
DESC
– RELATIONAL
– MDX
– CUSTOM SQL FREE FORM
– CUSTOM SQL WIZARD
– FLAT FILE
Object Extended TypeID
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 IndicatorID
DESC
– REPORT DEFINITION
– DOCUMENT DEFINITION
Object CategoryID
DESC
– Reports
– Documents
ScheduleID
Name
GUID
Description
Creation Date
Modification Date
Location
Version
Abbreviation
Access Granted
ScheduleID
Name
GUID
Description
Creation timestamp
Modification timestamp
Version
Status
Schedule IndicatorID
DESC
– NON-SCHEDULED
– SCHEDULED
Session SourceID
DESC
– Scheduler
Security FilterID
Name
GUID
Description
Creation Date
Modification Date
Location
Version
Abbreviation
Access Granted
Owner Name
Security FilterID
Name
GUID
Desc
Creation timestamp
Modification timestamp
Location
Owner Name
SessionID (GUID)
Connection Timestamp
Disconnection Timestamp
SessionID
GUID
SQL Execution IndicatorID
DESC
– NO SQL EXECUTED
– SQL EXECUTED
Action Type/Action Category 
SubscriptionID
DESC (subscription name)
SubscriptionID
Name
GUID
Creation timestamp
Modification timestamp
Status
Project Name (to support CM delete command)
TableID
Name
GUID
Description
Creation Date
Modification Date
Location
Version
Abbreviation
Access Granted
Table Size
Table Prefix
Owner Name
ObjectID
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
TemplateID
Name
GUID
Description
Creation
Date Modification
Date Location
Version
Abbreviation
Access Granted
Owner Name
ObjectID
Name
GUID
Desc
Creation timestamp
Modification timestamp
Location
Version
Owner Name
TransformationID
Name
GUID
Description
Creation Date
Modification Date
Location
Version
Abbreviation
Access Granted
Owner Name
ObjectID
Name
GUID
Desc
Creation timestamp
Modification timestamp
Location
Version
Owner Name
UserID
Name
GUID
Description
Creation Date
Modification Date
Location
Abbreviation
Access Granted
Enabled Status
PWD Expiration Freq
Allow Change PWD
PWD Expiration Date
Metadata
Account/UserID
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
User GroupID
Name
GUID
Description
Creation Date
Modification Date
Location
Version
Abbreviation
Access Grated
User GroupID
Name
GUID
Description Creation timestamp
Modification timestamp
Version
Status
User Group (Parent)ID
DESC
User GroupID
Name
GUID
Description Creation timestamp
Modification timestamp
Status
Week of yearID (201701)
Week Start Date (2017-01-02 00:00:00)
Week Finish Date (2017-01-08 23:59:59)
WeekID (201701)
Week Begin Date (2017-01-02)
Week End Date (2017-01-08)
Week Range (01/02/2017-01/08/2017)
WeekdayID (1)
DESC (Monday)
Short Desc (Mon)
Day of WeekID (1)
DESC (Monday)
YearID (2017)
DESC (Year 2017)
Short Desc (Y 2017)
YearID (2017)
Database Error IndicatorID
DESC
– NO DB ERROR
– DB Error
StatusDatabase Error Indicator
– 0
– 1
Delivery Status IndicatorID
DESC
– FAILED
– SUCCESSFUL
StatusID
DESC
Element Load IndicatorID
DESC
– REGULAR REPORT
– ELEMENT LOAD REPORT
Object TypeID
DESC
– Element Load Object
QuarterID (20171)
DESC (2017 Quarter 1)
Short Desc (2017 Q1)
QuarterID (20171)
DESC (Q1 2017)
Cache Creation IndicatorID
DESC
– NO CACHE CREATION
– CACHE CREATION
Action CategoryID
DESC
– Cache Creation
Cache TypeID
DESC
– NO CACHE HIT
– SERVER CACHE
– DEVICE CACHE
– APPLICATION CACHE
Cache TypeID
DESC
– Report Cache
– Intelligence
– Cube Cache
DB TableID
Name
GUID
Description
Creation Date
Modification Date
Location
Version
Abbreviation
Access Granted
Owner Name
DB TableID
Name
GUID
Description Creation timestamp
Modification timestamp
Location
Version
Owner@id
SQL Clause TypeID
DESC
– SELECT
– SELECT GROUP BY
– SELECT AGGREGATE
– FROM
– WHERE
– ORDER BY
SQL Clause TypeID
DESC
– Select
– Select Group By
– Select Aggregate
– From
– Where
– Order By
Job Priority MapID
DESC
– UNKNOWN
– LOW PRIORITY
– MEDIUM PRIORITY
– HIGH PRIORITY
Job PriorityID
DESC
– Low Priority
– Medium Priority
– High Priority
Job Priority NumberIDJob PriorityID
DESC
– Low Priority
– Medium Priority
– High Priority
HierarchyID
Name
GUID
Description
Creation Date
Modification Date
Location
Version
Abbreviation
Access Granted
Owner Name
ObjectID
Name
GUID
Desc
Creation timestamp
Modification timestamp
Location Version
Owner Name

Fuente: https://www.microstrategy.com/

Deja una respuesta

Tu dirección de correo electrónico no será publicada.

Este sitio está protegido por reCAPTCHA y se aplican la política de privacidad y los términos de servicio de Google.

Perfiles en Redes Sociales