PROBLEM STATMENT
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.#
Answers
-
I am not 100% sure what is the scope - visualisation in dataview or dataflow purposes.
Anyway, I believe that the "refer to" functionality inside the dataview should allow for your expected output:
References tab2 -
I have attached some screenshot things that is marked in circle i want that to be dynamic while rest other to be static, if i apply pager then changes are applied to full screen.
0 -
I solved a similar problem using a custom time entity that aggregate year.
I fix i.e. 2019 aggregated by YEAR TYPE entity linked with occurancy "budget year".
Into the dataview I made a refer to selection and, when I change year on screen, the cube display 2019 data thanks to the refer to selection.
regards
0
