Creating a Snippet report
To create a snippet report:
Navigate to the Explorer pane and expand Financial Planning & Analysis.
Expand the Standard App, then Revenue Planning and then click the Gross Sales sheet to proceed.
-
Make sure that your Gross Sales sheet contains these assignments:
1. Plan - Current Plan
2. 2024 - 2024
3. All-Customer
4. PS-Standard
5. All-Company
In the sheet, click the Snippets icon.
At the bottom of the pane, click Create Snippets and select Report.
-
In the Report Details pane, type Gross Sales in the Name and Title fields.
Note: The Name must be unique in your JustPerform environment.
Ensure that the Private checkbox is unchecked to make the report accessible to others.
-
Next, organize the report layout into the desired Columns and Rows.
Drag and drop the Products field into the Rows section.
Drag and drop Company field to the Columns section.
Drag and drop Customers field to the Filters section.
Drag and drop Time from the Fields section and Metrics from the Rows section to the Filters section.
Now we want to use filters to identify which products to include. Click the Filter icon beside the Products field.
From the MEMBER SELECTOR window expand the All-Products folder, the PO-All Types folder, and then enable the checkbox beside PS-Standard products.
-
Click the Relationship dropdown and scroll to select Current Member & Leaf Members and then click Insert Members.
The filtered products now appear on the right side of the MEMBER SELECTOR popup.
We will check the box beside FAContext - FAContext on the right and click the trashcan icon to remove the selection focusing on Standard Products only.
Click OKAY.
-
Repeat the same steps for Company field.
Click the Filter icon beside the Company field.
From the MEMBER SELECTOR window, expand the All-Company folder.
Click the Relationship dropdown and select Leaf Members and then click Insert Members.
Check the box beside FAContext - FAContext and then click the trashcan icon to remove the selection.
Click OKAY.
-
Repeat the same steps for Customers field.
Click the Filter icon beside the Customers field.
From the MEMBER SELECTOR window, select the All-Customer folder.
Click the Relationship dropdown and select Current Member and then click Insert Members.
Check the box beside FAContext - FAContext and then click the trashcan icon to remove the selection.
Click OKAY.
Select the Filter icon next to Metric Gross Sales.
Check the box next to Gross Sales.
Click the Relationship dropdown and select Leaf Member and then click Insert Members.
Click the Publish icon.