Hello,
I would appreciate it if someone can help me with this requirement. For Drill through from BPC to ECC, Time needs to be in Period/year format. Since BPC Time dimension has a property called period and another one called a year, is it possible to somehow do the configuration so that the drill through query can on the fly make these two properties in a format that ECC can understand?
E.g. Period 12 of Year 2014.
Time ID Period Property Year Property
2014.DEC 12 2014
Instead of creating another property called Drill ID that has 012/2014 value stored, is it possible that drill through configuration can do it on the fly? Thanks.