MicroStrategy
Posts  1 - 2  of  2
arunruggu
Hi,

I am new to microstrategy, can you tell me what is facts,attributes,metrics and filters breifely.

Thanks,
Arun
Save
Cancel
Reply
replied to:  arunruggu
rahulrao
Replied to:  Hi, I am new...
Hi Arun
..facts and attributes are schema objects
..metrics and filters both of them under public objects
microstrategy mainly three types
1) configuration objects: these objects are based on admin part (creating users etc)
2) schema objects: these objects handled by architect
schema objects are
attributes
facts
hierarchies
transformations
tables etc
3) public objects: these objects related to report developer
public objects are
report
filters metrics prompts consolidations custom groups autostyles documents dashboards
................
facts that contains numeric values
attributes created by fact tables
attribute it contains its id desc forms
attributes examples
year Qtr month week day
..............................
metrics it contains 4 types
formula(default)
level or dimensionality
condition
transformations
metrics created on facts(revenue ex fact)
.............
filters are restrict the data
filter conditions are
add an attribute qualification
add a set qualification
report as a filter
filter as areport
Save
Cancel
Reply
 
x
OK