He’s also responsible for last week’s Jaspersoft Tip | Email Anyone Reports, which gives you an outline of how to email HTML versions of your reports to anyone. That includes non-CA PPM users.
But let’s get back to starting your new report fast.
Step 1 | Navigate to Ad Hoc Views
From CA PPM Home, select Advanced Reporting from the drop down, and choose “Create” beneath Ad Hoc Views.
Step 2 | Choose Data Warehouse
This brings up your 8 Domain options: Application Management, Custom Master Objects, Financial Management, Idea Management, Investment Management, Project Management, Resource Management, and Time Management.
Select Data Warehouse, Jaspersoft in CA PPM
CA specifically built the domains in the Data Warehouse for reporting purposes. Bless them. It has a lot of pre-translated measures and facts ready, so we can leave off that disagreeable business of calculating data.
Select the domain you want your data to pull from the Data Warehouse. For our purposes, we’ll highlight Project Management, and select “Choose Data.”
Step 3 | Choose Data
The Choose Data Screen allows you to choose your fields by dragging them over to “Selected Fields.”
Choose Data Source by selecting fields, Jaspersoft in CA PPM
You might be after custom attributes here, and there are many measures, like Tasks, Issues, and Risks, where you can see the Total Cost by Project, by Week, by Month, or within a Project by Team or even by Task.
Every domain has a different structure depending on what type of data you need.
While best practice is to be specific, to show you all the options available, we’ll select the entire Projects folder, drag it into Selected Fields, and click OK.
Step 4 | Choose Report Type
On the left-side, under the “Domain: Project Management,” you can see all the Fields and Measures.
The majority of the screen contains your burgeoning report, labeled “New Ad Hoc View.”
New Ad Hoc View, ready for Input via Project Management Domain, Jaspersoft in CA PPM
Since you haven’t done any dragging and dropping, the right-side of the screen is a massive white field. Not for long.
Step 5 | Select Report Type
The first thing you want to do before dragging and dropping Fields and Measures is to choose the type of report you’re after, either a Table, Chart, or Crosstab.
Create a Table, Chart, or Crosstab Report, Jaspersoft in CA PPM
Tip | Test on the Fly
One more tip before we leave you. If you’d like the report data to populate fast while you test your creation, choose “Sample Data.” It’s just to the right of the report type. And after you’ve finished your masterpiece, you can switch to the real stuff.
As the leading PPM, Work Management, and Agile services provider, Rego Consulting has helped hundreds of organizations achieve a higher return on their software investment, including 60% of Fortune 100 and 70% of Fortune 20 companies.