Compare Data with Metadata
SummaryCompare Data with Metadata
I would like to compare a Data value at an intersection of Start_Dt (Account member)->BegBalance->PositionA->Project1 to that of a Period member and assign a new value to that Period member.
Ex: If the data value of (Start_Dt->BegBalance->PositionA->Project1 = 20171103). (Users would enter this in a SmartView template).
Also, the members in the Period dimension are at days level in the YYYYMMDD format. (for around 3 years).
Let's say my requirement is to assign 10$ for PositionA->Project1->20171103.
I would need to know for which Period member or a range of members the users would like to assign that 10$.