Determining which list-of-values type to use

“——————————————————————————————————————————————————
Support machine translation: http://amzn.to/1Z7d5oc
——————————————————————————————————————————————————



Crystal Reports Online Help
Determining which list-of-values type to use
Different reporting problems require different prompting solutions, depending on the amount of data in the lists of values. This table provides a rough guide to which list-of-values design you should use.
Description Unmanaged list of values Managed list of values
Report fields Command objects Business Views
Single-level code tables. (A table that has hundreds of semi-static values in a single level.) Not well suited.
Because report fields cannot be filtered, any filtering of the list that you require must be done outside of Crystal Reports in a database view. Well suited.
You can define filtering within a command object. (That command objects return the data for all levels in the list is not a problem for single-level lists.) Well suited.
You can define filtering within the source Business View.
Multi level-cascading code tables. (A table that has hundreds of semi-static values in multiple levels.) Well suited.
Provided that the data filtering is done outside of Crystal Reports, report fields are well suited to multi-level cascading code tables because they retrieve data one level at a time. Well suited.
Provided that the total data volume for all levels in the list is not too large. If there is too much data, you could encounter performance issues because command-object-based lists of values retrieve data for all levels in one trip to the database. Well suited.
Business-View-based lists of values can support both filtering and level-by-level data retrieval.
Fact tables. (These tables tend to be very large, dynamic tables with millions of values in multiple levels.) Well suited.
Provided that the filtering is done outside of Crystal Reports in a database view, and provided that there is a multi-level hierarchy to the data. Not well suited.
Because command objects retrieve their data in one trip to the database, there could be performance issues when you use them against very large tables. Well suited.
Partially scheduled lists of values excel in this situation, where the semi-static part of the data can be scheduled, and the most dynamic part can be retrieved on-demand.

——————————————————————————–

Previous page Next page
SAP BusinessObjects
http://www.sap.com/sapbusinessobjects/
Support services
http://service.sap.com/bosap-support/
Product Documentation on the Web
http://help.sap.com/

“————————————————– ————————————————– ————————————————–
Appoġġ ta ‘traduzzjoni awtomatika: http://amzn.to/1Z7d5oc
————————————————– ————————————————– ————————————————–

Rapporti Crystal Online Għajnuna
Jiddeterminaw liema lista ta ‘valuri tip għall-użu
problemi differenti ta ‘rappurtar jeħtieġu soluzzjonijiet tħeġġeġ differenti, jiddependi fuq l-ammont ta’ data fil-listi ta ‘valuri. Din it-tabella tipprovdi gwida approssimattiva li għalih lista ta ‘valuri disinn għandek tuża.
Deskrizzjoni lista ġestjonati ta ‘valuri lista ta’ valuri Immexxi
oqsma Rapport Kmand oġġetti Views Business
tabelli ta ‘kodiċijiet ta’ livell wieħed. (Tabella li mijiet ta ‘valuri semi-statiku fi f’livell wieħed.) Mhux adattat tajjeb.
Minħabba l-oqsma rapport ma tistax tkun iffiltrata, kull filtrazzjoni tal-lista li għandek bżonn għandu jsir barra mill Rapporti Crystal fid ħsieb database. Adattat tajjeb.
Tista ‘tiddefinixxi filtrazzjoni fi oġġett kmand. (Li oġġetti kmand jirritorna l-informazzjoni għal-livelli kollha fil-lista mhix problema għal listi ta ‘livell wieħed.) Ukoll adattati.
Inti tista ‘tiddefinixxi l-iffiltrar fi ħdan is-sors tan-Negozju View.
Multi tabelli ta ‘kodiċijiet cascading ta’ livell. (Tabella li mijiet ta ‘valuri semi-statiku fil-livelli multipli.) Ukoll adattati.
Da l-filtrazzjoni tad-data jsir barra mill Rapporti Crystal, oqsma rapport huma tajbin għat-tabelli tal-kodiċi tat-tip cascading multi-livell minħabba li jirkupraw data livell wieħed kull darba. Adattat tajjeb.
Basta li l-volum totali ta ‘dejta għall-livelli kollha fil-lista mhix kbira wisq. Jekk ikun hemm wisq data, inti tista ’tiltaqa’ ma ‘kwistjonijiet ta’ prestazzjoni minħabba listi kmand-b’bażi ta ‘oġġett ta’ valuri jirkupraw data għal-livelli kollha fl-vjaġġ wieħed għad-database. Adattat tajjeb.
listi bbażati negozju View-of-valuri jistgħu jappoġġjaw kemm filtrazzjoni u ta ‘livell by livell ta’ dejta irkupru.
tabelli ta ‘Fatti. (Dawn it-tabelli għandhom tendenza li jkunu kbar ħafna, tabelli dinamika ma ‘miljuni ta’ valuri fil-livelli multipli.) Ukoll adattati.
Da l-filtrazzjoni isir barra mill Rapporti Crystal fid ħsieb database, u sakemm ikun hemm bosta livelli ġerarkija għad-data. Mhux adattati sew.
Minħabba oġġetti kmand jirkupraw data tagħhom vjaġġ wieħed għad-database, jista ‘jkun hemm kwistjonijiet ta’ prestazzjoni meta tuzahom kontra t-tabelli kbar ħafna. Adattat tajjeb.
listi parzjalment skedati ta ‘valuri jisbqu f’din is-sitwazzjoni, fejn il-parti semi-statika tad-data jistgħu jiġu skedati, u l-parti l-aktar dinamika jkun jista’ jitfittex on-demand.

————————————————– ——————————

paġna ta ‘qabel paġna li jmiss
SAP BusinessObjects
http://www.sap.com/sapbusinessobjects/
servizzi ta ‘appoġġ
http://service.sap.com/bosap-support/
Dokumentazzjoni prodott fuq il-Web
http://help.sap.com/
 

“————————————————– ————————————————– ————————————————–
Ondersteuning masjien vertaling: http://amzn.to/1Z7d5oc
————————————————– ————————————————– ————————————————–

Crystal Reports Online Hulp
Die bepaling van watter lys-of-waardes tipe om te gebruik
Verskillende verslagdoening probleme vereis verskillende waarna oplossings, na gelang van die hoeveelheid data wat in die lyste van waardes. Hierdie tabel gee ‘n rowwe riglyn waaraan lys-of-waardes te ontwerp wat jy moet gebruik.
Beskrywing Onbestuurde lys van waardes Bestuurde lys van waardes
Verslag velde Command voorwerpe Besigheid Views
Enkel-vlak-kode tafels. ( ‘N tabel wat honderde semi-statiese waardes in ‘n enkele vlak het.) Nie geskik.
Omdat verslag velde nie kan gefiltreer, moet enige filter van die lys wat jy nodig het buite Crystal Reports gedoen word in ‘n databasis oog. Geskik.
Jy kan filter te definieer binne ‘n opdrag voorwerp. (Daardie bevel voorwerpe terugkeer die data vir alle vlakke in die lys is nie ‘n probleem vir ‘n enkel-vlak lyste.) Goed aangepas.
Jy kan filter te definieer binne die bron Besigheid View.
Multi-vlak waterval kode tafels. ( ‘N tabel wat honderde semi-statiese waardes in verskeie vlakke het.) Goed aangepas.
Met dien verstande dat die data filter gedoen buite Crystal Reports, verslag velde is uiters geskik om ‘n multi-vlak waterval kode tafels omdat hulle data een vlak op ‘n slag te haal. Geskik.
Met dien verstande dat die totale volume data vir alle vlakke in die lys is nie te groot. As daar te veel data, kan jy die prestasie kwessies teëkom omdat bevel objekgerigte lyste van waardes haal data vir alle vlakke in ‘n reis na die databasis. Geskik.
Besigheid-View-gebaseerde lys van waardes kan beide filter en vlak-vir-vlak data herwinning ondersteun.
Trouens tafels. (Hierdie tabelle is geneig om baie groot, dinamiese tafels met miljoene waardes in verskeie vlakke wees.) Goed aangepas.
Met dien verstande dat die filter buite Crystal Reports word in ‘n databasis oog, en met dien verstande dat daar ‘n multi-vlak hiërargie aan die data. Nie goed geskik.
Omdat opdrag voorwerpe hul data te haal in ‘n reis na die databasis, daar kan prestasie kwessies wanneer jy dit gebruik teen ‘n baie groot tafels. Geskik.
Gedeeltelik geskeduleer lyste van waardes presteer in hierdie situasie, waar die semi-statiese deel van die data kan geskeduleer word, en die mees dinamiese deel kan opgespoor word nie op aanvraag.