If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Time Dimension

Started by cognostechie, 19 Jan 2016 12:31:42 PM

Previous topic - Next topic
Print
Go Down Pages1
User actions

cognostechie

19 Jan 2016 12:31:42 PM
Not sure where to post this so posting it here as Data Manager is closer to ETL design than BI tools.

I am wondering of anybody had implemented a Time Dimension (not a Date Dimension) and if so, willing to share the structure of the Dimension and Fact table? What's the granularity? Records by the hour, minute or second? Can you provide an example?

Ex: I want to track orders received in every 2 hr interval and have to compare that to the same time of yesterday.
 
Print
Go Up Pages1
User actions
BSP Software Documentation
MetaManager Documentation and Knowledgebase
Version Control Documentation and Knowledgebase
BSP Software Resources About Us
MetaManager BSP Software Training BSP Software
Integrated Control Suite YouTube Channel Micro Strategies Inc
Security Migration IBM Cognos
Integrated Management Suite