AnsweredAssumed Answered

PROBLEM STATMENT

Question asked by abhijatsingh on May 11, 2018
Latest reply on May 11, 2018 by abhijatsingh

scenario:  If i want to make one of my block constant and other one dynamic  in same data-view ?

 

block a:  data of year 2017  i.e Historical data

block b:  is my budged cube which contains inhered data  i.e some planned data, data copied using some procedure

if i wanted my block a to be dynamic and block b to be fixed? what should i do?

 

***************************************************************************************************************************************

expected output: if user selects year 2016 then historical data of 2016 appears while my budgeted cube should be same. i.e budged cube should hold the procedure value which was ran earlier?

***************************************************************************************************************************************

My Approach:Method

i used interactive selection and applied selection to layout block , my block a is dynamic ,but once i apply it  the data of selected year is copied in Historical year block i.e is block a, while my budged cube is static.Please suggest what must be done to prevent copying of data on selection? if i select year 2016 the only data of 2016 should come.#

Outcomes