I want to create a P&L application (Income Statement) in Hyperion Planning. There are two designs to be considered:
1. One application that has product dimension in the outline. For example, the dimensions are: Account, Version, Scenario, Period, Year, Entity, Department, Currency, and PRODUCT. There are about 9000 part numbers in the product dimension and 500 members in account. Moreover, the revenue will be calculated by product qty * Average selling price
2. Two applications, one with P&L that has same above dimensions WITHOUT Product dimension, the other is Revenue application that has product dimension and few revenue accounts. The Revenue application would have xref function to the P&L for revenue amount.
Can you share pros and cons with these two designs. Thanks much for your help.