Multiple facts with conformed dimensions
Both tools support
them with star schema. While Power BI can only create a relationship with a
single column, Cognos can support any expression based relationship as long as
it is SQL compliant. However, Power BI can use TREATAS to create a virtual
relationship.
Multiple Facts with different granularity
Check the link How to handle multiple fact tables with different granularity for
detail
Model relative date dimension
Check the link How to model relative date dimension for
detail
Model row-level security
Check the link How to implement row-level security for detail
Reporting
How to make a visual
show and hide
Power BI: Use
Benchmark Pane, Selection Pane, Blank Buttons.
- Define Bookmark
- Define Buttons
- Associate Bookmark to report visuals
- Associate Button to Bookmark
Cognos Analytics: Use
Conditional block, block variable
How to quickly
identify a visual
Power BI: Selection
Pane, it is better to define these visuals with good name and sequence.
Cognos Analytics: Page
structure
No comments:
Post a Comment