How to include another column

38 Views

Matez,

I have to add another Data Column to my BPS Layout.

This additional Data Column is simply whereby my user needs to input "price" data one-time only. It doesn`t change over the years.

Hence,

                                             <b>PRICE</b>    Jan 2005   Feb 2005   Mar 2005  Apr 2005   June 2005  July 2005   Aug 2005   Sep 2005 ....
                                                    
   
  <b>Title</b>:Nominal Gross Domestic Product        
               - Real GDP Growth (%)                 XXX              XXX          XXX           XXX           XXX         XXX
  <b>Title</b>:Securities Total Trading Value
               - On-market transactions              XXX
               - Direct business transactions        XXX
               - No of trading days                  XXX
               - Average daily turnover              XXX
  <b>Title</b>:Information Services
               - Authorised Subscriber Licences      XXX
               - Terminal subscribers                XXX
               - Internet subscribers                XXX
               - Telecommunication subscription      XXX

Now, I have modelled this PRICE as a key Figure and inserted it in my Data Column(Layout: Key Figures in Data Column)

Although, here in the BPS Layout it works fine...But, in my query, I can only use ONE KEY FIGURE. And I have to include another Key Figure which basically represents the values earlier.

Hence, my question is how can I include 2 Key Figure in my BEx Query ?

I was thinking to model this "PRICE" as characteristic, but the values for this PRICE will repeat and I cannot seem to add repetitive values for the characteristic master data.

Please help!