Use condition (data range) to select Data Source to use

[fpganhao]

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).