oraclebipublishbestpractice-甲骨文bipublish最佳實(shí)踐-培訓(xùn)-資料下載頁(yè)
2025-01-23 09:45本頁(yè)面
【正文】 erved. 36 QA Copyright 169。 2023, Oracle and/or its affiliates. All rights reserved. 37 Copyright 169。 2023, Oracle and/or its affiliates. All rights reserved. 38 Copyright 169。 2023, Oracle and/or its affiliates. All rights reserved. 39 APPENDIX Copyright 169。 2023, Oracle and/or its affiliates. All rights reserved. 40 Resources Copyright 169。 2023, Oracle and/or its affiliates. All rights reserved. 41 Server Configuration Options ? Scalable threshold (in bytes) ? Cache expiration (in min) ? Cache size limit ( of datasets) ? Maximum cached reports ? Database Fetch Size Administration Server Configuration Default values Copyright 169。 2023, Oracle and/or its affiliates. All rights reserved. 42 Server Configuration Options ? Bursting (10g only) – Enable multithreading – Default: False* – Thread count – Default: 2* ? FO processing – Use BI Publisher’s XSLT processor – Default: True – Enable scalable feature of XSLT processor – Default: False* – Pages cached during processing – Default: 50 – Enable multithreading – Default: False* – FO Parsing Buffer Size – Default: 1000000* – Enable XSLT runtime optimization – Default: True Administration Runtime Configuration Properties Copyright 169。 2023, Oracle and/or its affiliates. All rights reserved. 43 Reportlevel Properties Edit Report Properties Formatting Copyright 169。 2023, Oracle and/or its affiliates. All rights reserved. 44 Reportlevel Properties ? For long running reports – Take advantage of scheduling and disable Run Report Online. Viewing Reports Online Report Editor Report Viewer Copyright 169。 2023, Oracle and/or its affiliates. All rights reserved. 45 Reportlevel Properties ? Enable Data Caching – Saves XML data for reuse up to the Cache Expiration threshold – Improved performance with different template/output format – Not remended for realtime data ? Enable Document Caching – Better performance – Consumes more Temp storage space ? User Level (11g only) – Disable for better performance if data can be shared across users ? Cache Duration (11g only) Viewing Reports Online Report Editor Copyright 169。 2023, Oracle and/or its affiliates. All rights reserved. 46 Data Model Design Guidelines ? Avoid reusing the same name for element names。 it can cause confusion in template design. – For example, CITY under SHIPPING_ADDRESS and BILLING_ADDRESS. But in many cases you are better off using different names . S_CITY and B_CITY Element Naming Copyright 169。 2023, Oracle and/or its affiliates. All rights reserved. 47 Data Model Design Guidelines ? Avoid generating empty tags in the XML – Aggregation over fields that contain empty tags will fail with a “not a number” exception – Missing fields do not cause an issue with XSL – for example a print statement will just return an empty string ? Avoid XML attributes – They are supported in both RTF Excel templates but they add an extra layer of plexity。 they are not supported in the BI Publisher Layout Editor NULL Elements XML Attributes Copyright 169。 2023, Oracle and/or its affiliates. All rights reserved. 48 Data Model Design Guidelines ? If possible use SQL/JDBC against BI Server instead of using an Answers Request as a data source – Tip: Copy the SQL in an Answers Request and paste into the Query Builder text area OBIEE Data Source Copyright 169。 2023, Oracle and/or its affiliates. All rights reserved. 49 Copyright 169。 2023, Oracle and/or its affiliates. All rights reserved. 50 Copyright 169。 2023, Oracle and/or its affiliates. All rights reserved. 51 演講完畢，謝謝觀看！
環(huán)評(píng)公示相關(guān)推薦
鄂ICP備17016276號(hào)-1