Sample Reports - Overview
The following has been taken from the Tax Provision Blueprint "Instruction Guide" starting at page 20. See KB article: "Tax Provision Blueprint Instruction Guide - PV7.3.0 SV100" See KB article: "Report Groups" See KB article: "Reports" Sample Reports - Overview We have several Report Groups and will show sample reports from group. Here are the links to all the Sample Reports that have been created in the Tax Provision Blueprint solution. Sample Reports - Tax Provision Blueprint Solution Sample Reports - Overview of Rates / RTP Years / Nat Process / LNB Sample Reports - Metadata Review Sample Reports - FX Currency Rates Sample Reports - Calc Status Sample Reports - Tax Provision Blueprint Overview Sample Reports - Group Filings Analysis Sample Reports - Trend Reports Sample Reports - Consolidating Reports Sample Reports - Tax Reviewer – Actual Reports (Actual Scenario Only) Sample Reports - Tax Reviewer - Forecast Reports Sample Reports - National Benefit AnalysisSample Reports - Calc Status
The following has been taken from the Tax Provision Blueprint "Instruction Guide" starting at page 233. See KB article: "Tax Provision Blueprint Instruction Guide - PV7.3.0 SV100" Calc Status These cube views show the Calc Status either for the workflow entities or for all entities. Two are for the scenario “Actual”, one is for the scenario “ActualRTP” and the last one is for the Workflow Scenario.Sample Reports - FX Currency Rates
The following has been taken from the Tax Provision Blueprint "Instruction Guide" starting at page 230. See KB article: "Tax Provision Blueprint Instruction Guide - PV7.3.0 SV100" FX Currency Rates These cube views show either the current year’s FX rate (with the prior year’s M12 period and the next year’s M01, M02 and M03 periods) or shows all the years. These CV’s will need to be modified to include future years as the application grows. We have CV’s for the three forecast scenarios.Cube Views
The following has been taken from the Tax Provision Blueprint "Instruction Guide" starting at page 126. See KB article: "Tax Provision Blueprint Instruction Guide - PV7.3.0 SV100" See KB article: "Cube View Groups" See KB article: "Cube View Profile" Cube Views Cube Views are included for data entry and viewing. Modifying these Cube Views is permitted but may impact data collection and Form/Schedule rendering. Extreme caution is advised. Note: It is recommended to retain all the original Cube Views. If a different setup for a Cube View is required, create a copy of the original Cube View. Remember that the Forms / Schedules are dashboard driven and references a specific cube view through a Data Adapter. If you rename or create a new cube view, the associated dashboard data adapter may/will need to be updated. There are a few CV’s (Sch 02, 03, 04 and 05) that show an explanation column. This column has been defined with the C#Local member so that when you change the currency from Local to USD, you still see the cell text comments. If you also need the ability to enter comments at the USD member, then remove the C#Local from the column. Most of the cube views have the Default setting “ShowDimensionImages = False” which means you do not see a dimension icon in the column header or row header. This can be changed on a CV-by-CV basis.Cube View Groups
The following has been taken from the Tax Provision Blueprint "Instruction Guide" starting at page 127. See KB article: "Tax Provision Blueprint Instruction Guide - PV7.3.0 SV100" See KB article: "Cube Views" See KB article: "Cube View Profile" Cube View Groups The following Cube View (CV) Groups & Profiles are included in the Tax Provision Blueprint app. XFW_Tax Admin CV (TXP) helps the admin set the Origin Year in Schedule 03. You must perform a Force Calculate to populate the origin year for each period. The admin can do a Force Calculate in the last period to do the whole year at once. This would be a yearly process for the Admin. This Cube View is available in OnePlace under Cube Views. XFW_Tax Admin Reports (TXP) show the FX exchange rates used as well as the Calc Status of the entities. They are available in OnePlace in the Dashboards section. XFW_Tax CV’s Admin Workflow Actual (TXP) includes Admin Cube Views that are (1) used to capture date and time stamps when the bulk copy/clear is performed and (2) available at the parent level workflow in the Analysis section. Note: Sch 08_09 - ETR Consol Review_TXP has columns that are hard coded to the entities in the Tax Provision Blueprint app. You will need to change these hard coded entities to entities in your app. Entities to look for and update in your app are: E#TXP_Legal_CTX, E#TXP_Domestic_Total and E#TXP_Intl_Total. XFW_Tax CV’s All Workflows Actual (TXP) includes general Cube Views that are available at the parent level workflow in the Analysis section. XFW_ Tax CV’s All Workflows FCST (TXP) includes general Forecast Cube Views that are available at the parent level workflow in the Analysis section. XFW_Tax Forms Actual (TXP) are used for the Tax Provision Blueprint Schedules, where Tax data is input through a variety of available methods and then calculated. In general, data flows from Schedule 01 (Tax Rates) through to Schedule 18 (Interim Reporting Rate Reconciliation). Each data point is entered only once and flows through to all the required data points. The results may be viewed in Forms and/or Reports. The Forms are designed so that regardless of the Jurisdiction (National or Local) only one Form is required. This is handled primarily by the use of parameters. Certain rows or columns will appear or suppress based on the jurisdiction. These Local JD rows or columns will appear with Dark Blue text. Certain rows or columns will appear with Purple text to highlight that they are “Discrete” items. The Forms require minimal changes when following the recommended metadata setup. Restricting data cell input in the Forms is primarily controlled either using No Input Business Rules or setting the intercompany dimension to I#Top. The use of Row Overrides and Column Overrides are used extensively throughout the CV’s. XFW_Tax Forms FCST (TXP) are used for the Forecast Tax Provision Blueprint Schedules, where Tax data is input through a variety of available methods and then calculated. XFW_Tax Forms Linked CV Actual (TXP) includes the Linked Cube Views that are used on schedules 02, 05, 06, 06a and 06c. Navigation Links are used to help ensure a consistent POV. XFW_Tax Forms Linked CV FCST (TXP) includes the Linked Cube Views that are used on schedules 01cFC, 03FC, 05FC, 06aFC, 06FC and 40cFC. XFW_ Metadata Hierarchies (TXP) includes Cube Views for reviewing how each Dimension has been set up. It uses many UD8 dynamic members to capture the setup attributes and is displayed through a dashboard. It is available in OnePlace as a dashboard: XFW_Tax National Benefit Analysis (TXP) includes Cube Views used for Reports. XFW_Tax Reports Actual (TXP) includes Cube Views used for Reports. They can be run as a dashboard in OnePlace through the Dashboards: The two CV’s (80a… and 80b…) are used for the Tax Provision Blueprint Analysis dashboard. XFW_Tax Reports Other (TXP) includes Cube Views used for Reports. XFW_Tax_Reviewer_Monthly_Reports Actual (TXP) includes all the reports for the role “Tax Reviewer – Actual Report”. The reports are available here: XFW_Tax_Reviewer_Monthly_Reports FCST (TXP) includes all the reports for the role “Tax Reviewer – Forecast Reports”. XFW_Templates_Rows Actual (TXP) includes Cube Views for the rows for Schedules 05, 06, 07, 10 & 18. XFW_Templates_Rows FCST (TXP) includes Cube Views for the Forecast rows for Schedules 05FC & 06FC.Reports
The following has been taken from the Tax Provision Blueprint "Instruction Guide" starting at page 273. See KB article: "Tax Provision Blueprint Instruction Guide - PV7.3.0 SV100" See KB article: "Report Groups" See KB article: "Sample Reports - Overview" Reports This section will show you how to make modifications to the list of Reports that appear in each Report Group section. This list is controlled by a parameter called “ListOfReports_BR_new_TXP”. Take note of the Value Items number from the previous section. For the Trend Report, that number is “7”. In the business rule “TXP_HelperQueries” located in the Dashboard Data Set group, go to the section “GetReportList_new” and then look for where we reference Value Item “7”. You will notice the name that we gave each report. It can be modified if necessary. You will also notice after the comma (,), the name of the dashboard to display when that report is selected. Here are the dashboard references:Sample Reports - Tax Provision Blueprint Overview
The following has been taken from the Tax Provision Blueprint "Instruction Guide" starting at page 235. See KB article: "Tax Provision Blueprint Instruction Guide - PV7.3.0 SV100" Tax Provision Blueprint Overview This dashboard shows the walk from “Total Adjusted Pretax Income” to “Total Statutory ETR”. It is ranked by absolute value. The two CV’s that are used for this dashboard are located here:Sample Reports - Tax Provision Blueprint Solution
The following has been taken from the Tax Provision Blueprint "Instruction Guide" starting at page 220. See KB article: "Tax Provision Blueprint Instruction Guide - PV7.3.0 SV100" Tax Provision Blueprint Solution These three reports are just PDF overviews of the Data Flow (Actual and Forecast) and the Group Filing Flowchart.Sample Reports - National Benefit Analysis
The following has been taken from the Tax Provision Blueprint "Instruction Guide" starting at page 272. See KB article: "Tax Provision Blueprint Instruction Guide - PV7.3.0 SV100" National Benefit Analysis We have created a few reports based on schedule 05 and 06 that show the detail behind the calculation of the National Benefit.
