Skip to Content
0
Former Member
Apr 29, 2014 at 01:25 AM

Drill Through Question

27 Views

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.