Quarterly Report Change in personal name/comapny name

[Divya]

Hello All,
I ahve to create the report and got the package published already.
The reporting requirements--If the personal name has been changed within the reporting period; or
registered company name has been changed within the reporting period
then i have to provide id, code, previous personal name/company name, new personal name/company name and date the name changed.

Pleas anyone give me some idea how to apply the logic and start creating the report
Thanks
Divya

[Sridevi]

Hi Divya,

Can you please give some more details. Like you will be having all the details like the old person/company name,new name and the date of change all in a table rt? And what do you mean my reporting period?


Thanks,
Sridevi

[Divya]

Hello sridevi,

Actually there are no fields in the tables indicating old name and new name. and theer is seperate  reporting period query subject. I am bit new to this cognos. Do i need to make any changes in the model so that i can build report for the above report specification.

Its a quarterly report. Do i need to verify whether there are indicators in the database representing old and new names? please give me some idea so that i can work on it.

Thanks a lot

[Sridevi]

Divya,

First of all , the information you need for reporting should be stored in some tables in the database.
Please find out those and check if you existing model includes those tables in it. Probably the query subject you say should hold it. If not you need to include those tables to the model and then republish the package .
Use this package for designing your report.

[dwh.vamsi]

[hi any one can tell how to find difference between totals of current and previous month on dimensional data