Pipe in Expansion does not expand BAS members for all KeyRanges

[Former Member]

Hi all,

I created a simple report to input some figures (in this case currency translation rates). I would like to add the different figures per period (BAS members of selected time period) and would like to have the different input currencies separated using the PIPE within the expansion parameters (rf. screenshot):

http://up.picr.de/4945568.png

I would expect the following result after expanding (rf. screenshot):

http://up.picr.de/4945586.jpg

What I get is the following; for the first KeyRange the BAS members are listed from JAN to DEC. the other KeyRanges only show the JAN 12 times (rf. screenshot 😞

http://up.picr.de/4945604.jpg

Does anyone have an idea? I already tried to modify the expansion from BAS to BAS|BAS|BAS, but the result is the same.

Thanks in advance and best regards

DoubleM

Using: BPC 7.5 for Microsoft

[Former Member]

Hey DoubleM,

you're actually right, but you can create the input schedule dynamic as well how you can see in my example

http://up.picr.de/4947764.jpg

This report is complete dynamic. It uses a before range in the row to display the EvDES.

The original EvDES is still marked in green an the before range is highlighted in light blue. You can place these two rows wherever you want or you can hide them, it's up to you. But you should get the result you dreamed about

Have a nice day!

Karsten

[Former Member]

Hey DoubleM,

there's a more easy way to get exactly that, what you're looking for.

Have a look at this: http://up.picr.de/4947492.jpg

I marked the key ranges in grey. EvDES are white for COL and green for ROW. Data area has been marked in kind of orange

Have a nice day

Karsten

[Former Member]

Hi Karsten,

thank you for your answer, too. Yes, this is sth. I also thought about (just add the Dimension description in a new header able. I think now it's ok.

If I would adapt the report like this I would have the next issue. I like using the pipes as they give a little bit more overview to a report (from my point of view), but I guess the functionality is not always really sophisticated.

Example: Normaly the formula next to the first cells in the headers (like EVDES) is copied to the rest of the KeyRange. If you use pipes you have different KeyRanges and I would also expect, that the formula is also copied to this Ranges, but it will not. If I have static reports (like in the example of this thread), it's quite easy to copy the formulas, so the description is also named in the other ranges.

But if you have really dynamic reports (so you do not know, how many rows will be filled) you cannot copy the formulas easily. Maybe a solution with macros might be possible, but it's not the nicest way ...

cheers

DoubleM

[PatrickFavre]

Hi DoubleM,

I have faced the same problem. And this is probably a small bug. But you can workaround this issue.

Basically, in those kind of report, I would say that you don't need multiple ColKeyRange.

So keep only one ColKeyRange. It will remove every periods for the second and third table (NOK, and DKK).

If you still would like to keep the periods for those tables, I would say just write an Excel function referencing "2007.JAN" in the first cells of your second and third table. The, when expanding, you will have your correct period id displayed for the whole year.

Hope this will help.

Best Regards,

Patrick

[Former Member]

Hi Patrick,

I am happy, that I am not the only one, who has this kind of problems. I assume also, it might be a bug in BPC ... but your workaround (nice & easy) helped, so I can close the thread. In good time, I would create an OSS for that ....

Here you can see the workaround, which looks similar to what I wanted to have ...

http://up.picr.de/4946875.jpg

Thanks and best regards

DoubleM