Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

There is a ‘planning-form template’ that feeds in data to some dimensions of a PPS planning. Using the same data that was submitted, a summary report needs to... Expand / Collapse
Author
Message
Posted Friday, November 14, 2008 10:04 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Thursday, May 27, 2010 1:31 PM
Points: 132, Visits: 101
There is a form template that takes data from different contributors. Now, same data is to be presented in the same template as report. This will be summary data... as in not for individual countries (as Contributors submitted) but for all countries within a region. Two approaches that we are considering are:

Approach1: A financial model with inbuilt dimension objects (dimensions cannot be customized).
Approach1: A generic model with customizable dimensions (calculations may have to be manipulated using PEL rules as the auto calculation feature is not available for this model)

Issues:
1. Data is not getting pulled into the report as required. What is the best way to design it?
2. Some columns on contributors' sheet are defined as properties of a dimension. These cannot be mathematically manipulated using rules as properties are always handled as strings and not numeric. How to manipulate them in PEL rules?

Any help will be greatly appreciated.

Thanks
Prakriti
Post #602904
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse