Reporting directly from PPM DB has it pros and cons. Pros
are in terms of getting real time data. And CONS if you run heavy reporting,
then it is ideal run reports during peak hours only, since otherwise you will
hit your Clarity database performance and it might slow down the regular PPM
usability.
Hence using a separate DWH database can also be a big
plus, as you get your data without slowing down your system.
When it comes to Jaspersoft : most reports use DWH
database, which means they will retrieve the data that is in DWH, updated by
the Load DWH job. You can run the job as often as you need to have the data
updated: most of the reports return data that may be updated Daily with no
impact on being real-time. And DWH DB is exclusive for reporting purposes.
If you need to get an actual real-time data from Clarity,
with Jaspersoft, I would recommend you use real time Ad Hoc Views and Reports
that provide that feature.
Reference:
b. If we
use Niku DB what we will miss in Jasper soft by comparing traditional Jasper
soft report.
{CA Support}: The answer was basically provided above.
Jaspersoft reports can be sourced from PPM and DWH datasources. The future
plans are to completetly move the default reports to DWH. You may refer to
Advanced reporting product guide for explanations on the default reports.
Reference:
You may review the pros and cons mentioned
in 1A. Jaspersoft is the currently supported PPM reporting content, and it is
getting a lot of liking from the larger PPM user community. So the sooner we
adapt the better it is.
In summary, Jaspersoft is smaller and generally smarter:
it requires less resources than Business Objects. What would be best for you
will depend on what features you are going to be using.
If you have the bandwidth, you can also install both and
see which one would be more convenient for your business. If not anything else,
it can definitely help you with your decision, based on your exact situation.
Using Jasper Soft we will get the capability to run the
reports in different ways. i.e. via the CA PPM BEAN Datasource and CA PPM DWH
Bean Datasource. If your reporting needs are not strict to show real time data,
then you can source your data of the CA PPM DWH BEAN Datasource. And for real
time data you may use the CA PPM Bean Datasource. The default reports or in
other words are based on these datasources. You may create custom domains
combining the tables of your choice.
