BPS Postable Hierarchies - how to deal with Intervals

[Former Member]

Hi,

I am using BPS postable hierarchies. If I put an interval (of say account numbers) in the hierarchy this does not show up on the BPS layout.

It looks like it would show up only if I list each account individually.

Any way around this?

[Former Member]

Marc,

Its not practical to build the hierarchy non-programmatically.

I figured another way to do that is to not use the Hieararchy but use Characteristic derivation. eg. grouping by Account Group where Account Group is an attribute of Account. Here I would use the Account Group and Account in the lead columns.

This works well. The problem with this approach however is that you no longer have control of what the initial screen would look like. BPS by default expands to the lowest node. Is there any way to control this?

[gerd_schoeffl]

Hello Anil,

You can control the expand level of a hierarchy in the BPS provided that you are using the web front end (Web Interfaces). Please have a look at note 720264. It is however not possible to restrict the expand level in the other front ends.

Best regards,

Gerd Schoeffl,

BI RIG

[former_member93896]

Hello Anil,

BPS does not support planning on hierarchies with intervals. As you said, you have to include the single values in the hierarchy or create a separate hierarchy for planning. The reason is that the system needs a unique value for each row otherwise it's not possible to store the data.

However, you can still use the hierarchy with intervals for reporting purposes.

Regards,

Marc

SAP NetWeaver RIG, US BI