<ROOT>
 <APPS_INITIALIZE_DATA>
  <USER_NAME>ENGINATICS</USER_NAME>
  <RESPONSIBILITY_KEY>SYSTEM_ADMINISTRATOR</RESPONSIBILITY_KEY>
  <APPLICATION_SHORT_NAME>SYSADMIN</APPLICATION_SHORT_NAME>
 </APPS_INITIALIZE_DATA>
<LOVS>
<!-- loader xml for Enginatics Blitz Report lov: Blitz Report Category -->
 <LOVS_ROW>
  <GUID>8E2FF36EDEFA79D2E0530100007F1FF2</GUID>
  <LOV_NAME>Blitz Report Category</LOV_NAME>
  <VALIDATE_FROM_LIST>Y</VALIDATE_FROM_LIST>
  <LOV_QUERY>select
xrcv.category value,
(select count(*) from xxen_report_category_assigns xrca where xrcv.category_id=xrca.category_id) description
from
xxen_report_categories_v xrcv
order by
xrcv.category</LOV_QUERY>
  <LOV_TRANSLATIONS>
   <LOV_TRANSLATIONS_ROW>
    <LANGUAGE>US</LANGUAGE>
   </LOV_TRANSLATIONS_ROW>
  </LOV_TRANSLATIONS>
 </LOVS_ROW>
</LOVS>
<REPORTS>
<!-- loader xml for Enginatics Blitz Report: DIS Import Performance -->
 <REPORTS_ROW>
  <GUID>8B82AC7D028B5E01E0530100007FC566</GUID><ENABLED>Y</ENABLED>
  <SQL_TEXT>select
x.*,
xxen_util.time(x.seconds) time
from
(
select
xrv.report_name,
regexp_substr(xrv.description,&apos;Object IDs: (.+)&apos;,1,1,null,1) object_use_key,
xrv.category,
xxen_util.user_name(xrv.created_by) created_by,
xxen_util.client_time(xrv.creation_date) creation_date,
(xrv.creation_date-lag(xrv.creation_date) over (order by xrv.report_id))*86400 seconds
from
xxen_reports_v xrv
where
1=1
order by
xrv.report_id desc
) x</SQL_TEXT>
  <REPORT_TRANSLATIONS>
   <REPORT_TRANSLATIONS_ROW>
    <LANGUAGE>AR</LANGUAGE>
    <REPORT_NAME>DIS Import Performance</REPORT_NAME>
    <DESCRIPTION>استعلام بسيط لمراجعة ورقة عمل Discoverer لأداء استيراد Blitz Report ، عند تشغيل البرنامج النصي للترحيل الجماعي.
https://www.enginatics.com/user-guide/#Discoverer_Worksheet</DESCRIPTION>
   </REPORT_TRANSLATIONS_ROW>
   <REPORT_TRANSLATIONS_ROW>
    <LANGUAGE>D</LANGUAGE>
    <REPORT_NAME>DIS Import Performance</REPORT_NAME>
    <DESCRIPTION>Einfache Abfrage zur Überprüfung der Leistung beim Import von Discoverer-Arbeitsblättern in Blitz Reports, wenn das Skript für die Massenmigration ausgeführt wird.
https://www.enginatics.com/user-guide/#Discoverer_Worksheet</DESCRIPTION>
   </REPORT_TRANSLATIONS_ROW>
   <REPORT_TRANSLATIONS_ROW>
    <LANGUAGE>E</LANGUAGE>
    <REPORT_NAME>DIS Import Performance</REPORT_NAME>
    <DESCRIPTION>Consulta simple para revisar el rendimiento de la importación de hojas de trabajo de Discoverer a Blitz Report, cuando se ejecuta el script de migración masiva.
https://www.enginatics.com/user-guide/#Discoverer_Worksheet</DESCRIPTION>
   </REPORT_TRANSLATIONS_ROW>
   <REPORT_TRANSLATIONS_ROW>
    <LANGUAGE>F</LANGUAGE>
    <REPORT_NAME>DIS Import Performance</REPORT_NAME>
    <DESCRIPTION>Requête simple pour vérifier les performances d&apos;importation de la feuille de calcul Discoverer vers le rapport Blitz, lors de l&apos;exécution du script de migration de masse.
https://www.enginatics.com/user-guide/#Discoverer_Worksheet</DESCRIPTION>
   </REPORT_TRANSLATIONS_ROW>
   <REPORT_TRANSLATIONS_ROW>
    <LANGUAGE>I</LANGUAGE>
    <REPORT_NAME>DIS Import Performance</REPORT_NAME>
    <DESCRIPTION>Semplice query per rivedere le prestazioni di importazione del foglio di lavoro Discoverer in Blitz Report, quando si esegue lo script di migrazione di massa.
https://www.enginatics.com/user-guide/#Discoverer_Worksheet</DESCRIPTION>
   </REPORT_TRANSLATIONS_ROW>
   <REPORT_TRANSLATIONS_ROW>
    <LANGUAGE>JA</LANGUAGE>
    <REPORT_NAME>DIS Import Performance</REPORT_NAME>
    <DESCRIPTION>大量移行スクリプトを実行しているときに、DiscovererワークシートからBlitzレポートのインポートパフォーマンスを確認するための簡単なクエリ。
https://www.enginatics.com/user-guide/#Discoverer_Worksheet</DESCRIPTION>
   </REPORT_TRANSLATIONS_ROW>
   <REPORT_TRANSLATIONS_ROW>
    <LANGUAGE>KO</LANGUAGE>
    <REPORT_NAME>DIS Import Performance</REPORT_NAME>
    <DESCRIPTION>대량 마이그레이션 스크립트를 실행할 때 Discoverer 워크 시트에서 Blitz Report 가져 오기 성능을 검토하는 간단한 질의입니다.
https://www.enginatics.com/user-guide/#Discoverer_Worksheet</DESCRIPTION>
   </REPORT_TRANSLATIONS_ROW>
   <REPORT_TRANSLATIONS_ROW>
    <LANGUAGE>PTB</LANGUAGE>
    <REPORT_NAME>DIS Import Performance</REPORT_NAME>
    <DESCRIPTION>Consulta simples para rever a folha de trabalho do Discoverer para o desempenho de importação do Blitz Report, ao executar o roteiro de migração em massa.
https://www.enginatics.com/user-guide/#Discoverer_Worksheet</DESCRIPTION>
   </REPORT_TRANSLATIONS_ROW>
   <REPORT_TRANSLATIONS_ROW>
    <LANGUAGE>RU</LANGUAGE>
    <REPORT_NAME>DIS Import Performance</REPORT_NAME>
    <DESCRIPTION>Простой запрос на просмотр рабочего листа Discoverer к производительности импорта Blitz Report при выполнении скрипта массового переноса.
https://www.enginatics.com/user-guide/#Discoverer_Worksheet</DESCRIPTION>
   </REPORT_TRANSLATIONS_ROW>
   <REPORT_TRANSLATIONS_ROW>
    <LANGUAGE>S</LANGUAGE>
    <REPORT_NAME>DIS Import Performance</REPORT_NAME>
    <DESCRIPTION>Enkel fråga för att granska Discoverers kalkylblad till importprestanda för Blitz Report när du kör massmigrationsskriptet.
https://www.enginatics.com/user-guide/#Discoverer_Worksheet</DESCRIPTION>
   </REPORT_TRANSLATIONS_ROW>
   <REPORT_TRANSLATIONS_ROW>
    <LANGUAGE>TR</LANGUAGE>
    <REPORT_NAME>DIS Import Performance</REPORT_NAME>
    <DESCRIPTION>Toplu taşıma komut dosyasını çalıştırırken Discoverer çalışma sayfasını Blitz Raporu içe aktarma performansına incelemek için basit sorgu.
https://www.enginatics.com/user-guide/#Discoverer_Worksheet</DESCRIPTION>
   </REPORT_TRANSLATIONS_ROW>
   <REPORT_TRANSLATIONS_ROW>
    <LANGUAGE>US</LANGUAGE>
    <REPORT_NAME>DIS Import Performance</REPORT_NAME>
    <DESCRIPTION>Query to review Discoverer to Blitz Report import performance, after running the &apos;Blitz Report Discoverer Import&apos; concurrent program or mass migration script.
https://www.enginatics.com/user-guide/#Discoverer_Worksheet</DESCRIPTION>
   </REPORT_TRANSLATIONS_ROW>
   <REPORT_TRANSLATIONS_ROW>
    <LANGUAGE>ZHS</LANGUAGE>
    <REPORT_NAME>DIS Import Performance</REPORT_NAME>
    <DESCRIPTION>当运行大规模迁移脚本时，简单的查询以审查Discoverer工作表到Blitz Report的导入性能。
https://www.enginatics.com/user-guide/#Discoverer_Worksheet</DESCRIPTION>
   </REPORT_TRANSLATIONS_ROW>
  </REPORT_TRANSLATIONS>
  <CATEGORY_ASSIGNMENTS>
   <CATEGORY_ASSIGNMENTS_ROW>
    <CATEGORY>Enginatics</CATEGORY>
   </CATEGORY_ASSIGNMENTS_ROW>
  </CATEGORY_ASSIGNMENTS>
  <ANCHORS>
   <ANCHORS_ROW>
    <ANCHOR>1=1</ANCHOR>
   </ANCHORS_ROW>
  </ANCHORS>
  <PARAMETERS>
   <PARAMETERS_ROW>
    <SORT_ORDER>1</SORT_ORDER>
    <DISPLAY_SEQUENCE>10</DISPLAY_SEQUENCE>
    <ANCHOR>1=1</ANCHOR>
    <SQL_TEXT>xrv.creation_date&gt;=:date_from</SQL_TEXT>
    <PARAMETER_TYPE_DSP>DateTime</PARAMETER_TYPE_DSP>
    <DEFAULT_VALUE>select
min(xr.creation_date)
from  
xxen_report_categories_v xrcv,
xxen_report_category_assigns xrca,
xxen_reports xr
where
xrcv.category=:$flex$.category and
xrcv.category_id=xrca.category_id and
xrca.report_id=xr.report_id</DEFAULT_VALUE>
    <PARAMETER_TRANSLATIONS>
     <PARAMETER_TRANSLATIONS_ROW>
      <LANGUAGE>F</LANGUAGE>
      <PARAMETER_NAME>Heure de création du rapport De</PARAMETER_NAME>
     </PARAMETER_TRANSLATIONS_ROW>
     <PARAMETER_TRANSLATIONS_ROW>
      <LANGUAGE>US</LANGUAGE>
      <PARAMETER_NAME>Report Creation Time From</PARAMETER_NAME>
     </PARAMETER_TRANSLATIONS_ROW>
    </PARAMETER_TRANSLATIONS>
   </PARAMETERS_ROW>
   <PARAMETERS_ROW>
    <SORT_ORDER>2</SORT_ORDER>
    <DISPLAY_SEQUENCE>20</DISPLAY_SEQUENCE>
    <ANCHOR>1=1</ANCHOR>
    <SQL_TEXT>xrv.creation_date&lt;=:date_to</SQL_TEXT>
    <PARAMETER_TYPE_DSP>DateTime</PARAMETER_TYPE_DSP>
    <DEFAULT_VALUE>select
max(xr.creation_date)
from  
xxen_report_categories_v xrcv,
xxen_report_category_assigns xrca,
xxen_reports xr
where
xrcv.category=:$flex$.category and
xrcv.category_id=xrca.category_id and
xrca.report_id=xr.report_id</DEFAULT_VALUE>
    <PARAMETER_TRANSLATIONS>
     <PARAMETER_TRANSLATIONS_ROW>
      <LANGUAGE>F</LANGUAGE>
      <PARAMETER_NAME>Heure de création du rapport à</PARAMETER_NAME>
     </PARAMETER_TRANSLATIONS_ROW>
     <PARAMETER_TRANSLATIONS_ROW>
      <LANGUAGE>US</LANGUAGE>
      <PARAMETER_NAME>Report Creation Time To</PARAMETER_NAME>
     </PARAMETER_TRANSLATIONS_ROW>
    </PARAMETER_TRANSLATIONS>
   </PARAMETERS_ROW>
   <PARAMETERS_ROW>
    <SORT_ORDER>3</SORT_ORDER>
    <DISPLAY_SEQUENCE>100</DISPLAY_SEQUENCE>
    <ANCHOR>1=1</ANCHOR>
    <SQL_TEXT>xrv.report_id in (
select
xrca.report_id
from  
xxen_report_categories_v xrcv,
xxen_report_category_assigns xrca
where
xrcv.category=:category_name and
xrcv.category_id=xrca.category_id
)</SQL_TEXT>
    <PARAMETER_TYPE_DSP>LOV</PARAMETER_TYPE_DSP>
    <LOV_NAME>Blitz Report Category</LOV_NAME>
    <LOV_GUID>8E2FF36EDEFA79D2E0530100007F1FF2</LOV_GUID>
    <VALIDATE_FROM_LIST_DSP>Y</VALIDATE_FROM_LIST_DSP>
    <LOV_QUERY_DSP>select
xrcv.category value,
(select count(*) from xxen_report_category_assigns xrca where xrcv.category_id=xrca.category_id) description
from
xxen_report_categories_v xrcv
order by
xrcv.category</LOV_QUERY_DSP>
    <DEFAULT_VALUE>Discoverer</DEFAULT_VALUE>
    <PARAMETER_TRANSLATIONS>
     <PARAMETER_TRANSLATIONS_ROW>
      <LANGUAGE>F</LANGUAGE>
      <PARAMETER_NAME>Catégorie</PARAMETER_NAME>
     </PARAMETER_TRANSLATIONS_ROW>
     <PARAMETER_TRANSLATIONS_ROW>
      <LANGUAGE>US</LANGUAGE>
      <PARAMETER_NAME>Category</PARAMETER_NAME>
     </PARAMETER_TRANSLATIONS_ROW>
    </PARAMETER_TRANSLATIONS>
   </PARAMETERS_ROW>
  </PARAMETERS>
  <TEMPLATES>
  </TEMPLATES>
  <DEFAULT_TEMPLATES>
  </DEFAULT_TEMPLATES>
  <UPLOAD_COLUMNS>
  </UPLOAD_COLUMNS>
  <UPLOAD_PARAMETERS>
  </UPLOAD_PARAMETERS>
  <UPLOAD_SQLS>
  </UPLOAD_SQLS>
 </REPORTS_ROW>
</REPORTS>
</ROOT>
