COGNOiSe.com - The IBM Cognos Community

IBM Cognos Analytics Platform => Cognos Analytics => Framework Manager => Topic started by: fpganhao on 23 Mar 2018 07:11:06 AM

Title: Use condition (data range) to select Data Source to use
Post by: fpganhao on 23 Mar 2018 07:11:06 AM
Hi! I'm using Cognos 11.0.3 and I have NPS (DW) with Hot Data (latest 6 months) and Hive with Cold Data (historical data). Is it possible to have attrbiutes and measures created in Framework Manager that depending on the data range selected, they either go fetch data from NPS or Hive? The table structures are exactly the same and the attrbutes and measures are the same (not duplicated).