Blitz Report Assignment Upload

➜ Back to Library
Description
Categories: Enginatics, Upload
Repository: Github
Upload to maintain Blitz Report assignments.
The upload support creating, deleting or copying assignment and can be run with the following modes:

-Create with 'Create Empty File'=Yes:
Opens an empty Excel file to enter new assignments.

-Create with 'Create Empty File'=blank:
You can query a list of reports that you want create assignments for by report name, category or repo ...  Upload to maintain Blitz Report assignments.
The upload support creating, deleting or copying assignment and can be run with the following modes:

-Create with 'Create Empty File'=Yes:
Opens an empty Excel file to enter new assignments.

-Create with 'Create Empty File'=blank:
You can query a list of reports that you want create assignments for by report name, category or report type.

-Create, Update:
Allows querying existing assignments, which can be deleted, or copied to a different assignment level.
A frequent use case for customers having custom responsibilities linked to custom applications would be to copy seeded application level Enginatics assignments to custom applications instead.
For this, you can query all Enginatics application level assignments, replace the application names with the corresponding custom applications, and upload the file again. Note that in this scenario, the Action column would show 'Update', but it would create new records, not update when uploading the file.   more 
select
null action_,
null status_,
null message_,
null modified_columns_,
xrv.report_name,
xrv.type_dsp type,
xrv.category,
xxen_util.meaning(nvl(xrav.include_exclude,'I'),'INCLUDE_EXCLUDE',0) include_exclude,
xrav.assignment_level_desc assignment_level,
xrav.level_value assignment_value,
xrav.description,
xrav.block_name form_block,
xrzpvv.parameter_name,
xrzpvv.block_name,
xrzpvv.item_name,
initcap(xrzpvv.id_or_value_dsp) "Id or Value",
xrzpvv.parameter_value_dsp constant_value,
xxen_util.user_name(xrav.created_by) created_by,
xxen_util.client_time(xrav.creation_date) creation_date,
xxen_util.user_name(xrav.last_updated_by) last_updated_by,
xxen_util.client_time(xrav.last_update_date) last_update_date,
null delete_,
null upload_row
from
xxen_reports_v xrv,
(select xrav.* from xxen_report_assignments_v xrav where :p_upload_mode<>'C') xrav,
xxen_report_zoom_param_vals_v xrzpvv
where
1=1 and
nvl(:p_create_empty_file,'x')<>'Y' and
xrv.report_id=xrav.report_id(+) and
xrav.assignment_id=xrzpvv.assignment_id(+)
Parameter NameSQL textValidation
Upload Mode
 
LOV
Create Empty File
 
LOV
Report Name starts with
lower(xrv.report_name) like lower(:report_name_like)||'%'
LOV
Report Category
xrv.report_id in (
select
xrca.report_id
from
xxen_report_category_assigns xrca,
xxen_report_categories_v xrcv
where
xrcv.category=:category and
xrcv.category_id=xrca.category_id
)
LOV
Report Type
xrv.type_dsp=:type
LOV
Assignment Level
xrav.assignment_level_desc=:assignment_level
LOV
Level Value
xrav.level_value=:level_value
LOV
Assignment Created By
xrav.created_by=:created_by
LOV
Assignment Creation Date From
xrav.creation_date>=:creation_date_from
Date
Assignment Creation Date To
xrav.creation_date<:creation_date_to+1
Date
Download
Related Blitz Reports
Blitz Report Assignments Blitz Report Parameter Default Values Blitz Report History Blitz Report Parameter Table Alias Validation CAC Inventory Organization Summary Blitz Reports Blitz Report Security CAC Interface Error Summary GL Account Distribution Analysis
Blitz Report™