Does anybody know where we can find complete documentation on how to configure the JS 14.2 for an ONDEMAND SaaS environment?
Below step is all required to be use jaspersoft reporting
Set the Language and Fiscal Periods for the Data Warehouse
To set the languages and the entity for fiscal periods for the Data Warehouse, use the System Options page in CA Clarity PPM.
Important! Modifying the fields that are described in the following procedure, requires you to run the Load Data Warehouse job with the option Full Load selected. Changes to the field Entity for Fiscal Periods result in a resource-intensive operation because all fiscal fields within the Data Warehouse are recalculated.
Follow these steps:
1. Open Administration and from General Settings, click System Options.
2. In the Data Warehouse Options section, complete the following fields:
Specifies the language localizations that are included in the Data Warehouse. Multiple languages result in increased storage requirements on the Data Warehouse server.
Entity for Fiscal Periods
Specifies the entity that is used to determine fiscal periods. The fiscal periods that are associated with the selected entity are used for all Data Warehouse fiscal period data calculations. Setting the entity for the first time creates new Data Warehouse time slice requests. Hence, the initial run of the Time Slicing job takes significantly longer than normal.
Initially setting an entity or updating it also updates the fiscal entity and fiscal period type for the Data Warehouse fiscal time slice requests. Do not set or change the entity when a time slice rollover is in progress. If you do, an error message appears. Wait until the rollover completes and then set the entity. To determine which slices requests are in the rollover, check the expiration date on the time slices. A slice request with an expiration date that is blank, earlier than the current date, or the same as the current date is in the rollover. Allow the slice request to complete processing before setting the entity.
Note: The entity must have Monthly (or 13 period) fiscal time periods set up to cover the time range of the time slice requests. Otherwise, the time slice requests are ignored when the Time Slicing job runs.
3. Save your changes.
a. Run the create jaspersoft user job
Populate the Data Warehouse with CA Clarity PPM Data
To populate the Data Warehouse with data from the CA Clarity PPM database, run the following jobs in the order given:
This job splits time varying data into a relational format.
Note: The first run of this job can take substantial time.
Load Data Warehouse
This job extracts the data from the CA Clarity PPM database, transforms the data, and loads the data into the Data Warehouse.
Note: This job is initially disabled. Enable this job before you run it.
Before you run this job, open the properties for any custom object or attribute that you want to include and select the Include in the Data Warehouse option. This option must be selected for custom objects or attributes to be populated in the Data Warehouse.
Important! If you are running the job for the first time to populate the Data Warehouse, select the Full Load configuration in the job parameters.
The following actions require you to rerun the Load Data Warehouse job after the initial population:
■ Deleting an attribute or clearing the Include in the Data Warehouse option for the attribute in Studio.
■ Changing the data type of an attribute.
■ Adding a language to the Data Warehouse.
■ Changing a timeslice date to include a larger timeframe.
Load Data Warehouse Access Rights
This job loads the access privileges for resources and investments from the CA Clarity PPM database to the Data Warehouse.
Note: When the Load Data Warehouse Access Rights and Load Data Warehouse jobs run, the jobs write standard messages to the Jobs logs and detailed messages to the Data Warehouse logs. The default Data Warehouse log files are bg-dwh.log and bg-ca.log. To review the detailed Data Warehouse log messages, navigate to the Data Warehouse logs (under the standard Jobs logs) in Clarity System Administration. You can enable more logging by changing the Kettle Log Level in Clarity System Administration (Logs, Edit Configuration). Use the detailed messages to monitor job progress and to analyze Data Warehouse load failures.
Hope this helps
We are still in CA PPM 13.1 and we are planning to upgrade to CA PPM 14.2 and Jaspersoft. I have few questions regarding Full Load option.
1. Will Full Load option truncate all the tables in datawarehouse side and reload the data from the scratch from OLTP?
2. If we add new attribute in application and set it to be included in the Datawarehouse, do I also need to run this Full Load again?
Can you please clarify?
Here is the answer to your questions:
1. The Full Load Datawarehouse job will truncate the tables in DWH, and reload them from Clarity PPM. Incremental load does not truncate, but runs delete statements only.
2. If you add a new attribute, Load Datawarehouse job with either Full or Incremental options will add the attribute to Datawarehouse database. You will not have to run the Full Load if you don't need to.
Hope this helps, let me know if any questions.
Suman has already provided you the required setup info for Jaspersoft. In addition, you can access the CA Clarity PPM 14.2 On Demand DocOps Platform and search for any information related to advanced reporting. Make sure to log in to the platform using your CA Support password so you see all the restricted and non-restricted information.
Apart from what my peers said above, there is also some additional SAAS JS documentation that is currently being written, with steps and screenshots. I will let you know once it get published.
Principal Support Engineer
I also look forward to receiving the documentation. I just implemented CA PPM SAAS, and have not been able to modify reports to meet our needs. Since we started with 14.2 (and Jaspersoft), without the documentation the product is only partially useful.
The PMO Accelerator Advanced Reporting Product Guide Release 14.2.00 has some good info on initial setup. Regarding modifications to existing reports - the document states "The report source files are included in a zip file (jaspersoft_csk.zip) and are available after the installation in the CA PPM reporting content folder....". FYI - I'm having issues finding these files in SaaS environment and have a helpdeskt ticket. Also, "The JRXML report files require the Jaspersoft Studio report designer development tool. The Jaspersoft Studio report designer is an eclipse-based development tool that can be downloaded and installed locally on your computer.".
The Jaspersoft Report Development Guide for SaaS Guide was now posted on CA Support site, on the link below provided by Tina:
CA PPM Advanced Reporting and Database Schema Index - CA Technologies
Please check it out and let us know for any comments.
Below are a few links which will be helpful-
ii. Page 50
You may also find the Jaspersoft Report Development Guide for SaaS helpful. This guide was recently posted on the following CA Support page (you will need to log in):
Advanced Reporting and Database Schema Index
On the page, scroll down to the Jaspersoft Studio Professional section and click the doc link.
Retrieving data ...