Youcannowusethelinkingdimensiontoapplyamaster/detailformat
inthereport.
Deletingthelinkbetweendataproviders
Todeletethelinkbetweendataproviders,youdeletethelinkofthecommon
dimensionthatlinksthedataproviders.Youwoulddeletethelinkbetween
dataproviderstouseallthevariablesinasingledataprovidertobuildan
independentquery.
Todeletethelinkbetweendataproviders
1. ClickViewDataontheDatamenu.
TheDataManagerappears.
2. IntheDataProvidersbox,clickthedimensionthatactsasthelink.
ClicktheDefinitiontab,thenclickUnlink.
3. ClickOKtoclosetheDataManager.
DesktopIntelligenceAccessandAnalysisGuide
101
5
CombiningDatafromDifferentSources
Linkingdataproviders
Change font on pdf form - C# PDF Field Edit Library: insert, delete, update pdf form field in C#.net, ASP.NET, MVC, Ajax, WPF
Online C# Tutorial to Insert, Delete and Update Fields in PDF Document
add image field to pdf form; add an image to a pdf form
Change font on pdf form - VB.NET PDF Field Edit library: insert, delete, update pdf form field in vb.net, ASP.NET, MVC, Ajax, WPF
How to Insert, Delete and Update Fields in PDF Document with VB.NET Demo Code
create pdf form; add signature field to pdf
102
DesktopIntelligenceAccessandAnalysisGuide
CombiningDatafromDifferentSources
5
Linkingdataproviders
C# PDF File Compress Library: Compress reduce PDF size in C#.net
RasterEdge.Imaging.Font.dll. Program.RootPath + "\\" 3_optimized.pdf"; // create optimizing options TargetResolution = 150F; // to change image compression
cannot edit pdf form; pdf form save in reader
VB.NET PDF File Compress Library: Compress reduce PDF size in vb.
Reduce font resources: Font resources will also take up too Program.RootPath + "\\" 3_optimized.pdf"; 'create optimizing 150.0F 'to change image compression
change font in pdf fillable form; adding form fields to pdf
Managing Data Providers
6
C# PDF insert text Library: insert text into PDF content in C#.net
Powerful .NET PDF edit control allows modify existing scanned PDF text. Ability to change text font, color, size and location and output a new PDF document.
convert pdf to editable form; cannot save pdf form in reader
C# PDF Sticky Note Library: add, delete, update PDF note in C#.net
Allow users to add comments online in ASPX webpage. Able to change font size in PDF comment box. Able to save and print sticky notes in PDF file.
allow saving of pdf form; create a pdf form online
Overview
InwhatwayscanyoumanagequeriesandotherdataprovidersinDesktop
Intelligencedocuments?Thischapteranswersthatquestionbydescribing
howto:
• renamedataproviders
• getstatisticssuchasthedateandtimeadataproviderwaslastrefreshed,
andhowmanyrowsofdatawerereturned
• emptydataprovidersoftheirdata(called),anddeletedataprovidersyou
nolongerneed
Note:
DataprovideristheDesktopIntelligencegenerictermforalltypesofqueries:
queriesonuniverses,free-handSQL,storedprocedures,VBAprocedures
orXMLfiles.
Renaming data providers
DesktopIntelligenceassignsanametoalldataproviders.Herearesome
examples:
Description
Dataprovidername
ThefirstquerybuiltontheeFashion
universeinthecurrentdocument.
Query1oneFashion
Storedprocedurerunonadatabase
accountcalledStock.
PS1onStock
Afree-handSQLscriptrunona
databaseconnectionnamedSales.
SQL1withSales
104
DesktopIntelligenceAccessandAnalysisGuide
ManagingDataProviders
6
Overview
VB.NET PDF Password Library: add, remove, edit PDF file password
RasterEdge.Imaging.Font.dll. passwordSetting.IsHighReso = True ' Allow to change document. passwordSetting.IsAssemble = True ' Add password to PDF file.
add text field to pdf acrobat; create a pdf form to fill out
C# PDF Password Library: add, remove, edit PDF file password in C#
RasterEdge.Imaging.Font.dll. passwordSetting.IsHighReso = true; // Allow to change document. passwordSetting.IsAssemble = true; // Add password to PDF file.
create a pdf form from excel; change font in pdf form field
Description
Dataprovidername
Personaldatacomingfroma
spreadsheetstoredinMyDocu-
ments.
PD1inC:\MyDocuments\Fore-
cast.xls
ThefirstVBAdataproviderbuiltin
thecurrentdocument,whereThisDoc-
umentAppisthenameoftheVBA
macroitself.
VBA1withThisDocumentApp
Whyrenamedataproviders?
RenamingdataprovidersisbynomeansrequiredinDesktopIntelligence.
Youcanworkwiththesoftwarewithouteverthinkingaboutthesenames.
However,dataprovidernamesappearinseveralplacesinDesktop
Intelligence,forexampleintheReportManager.
Hereareafewcaseswhereyoumightwanttorenamedataproviders.
Documentswithdatafromdifferentsources
Indocumentscontainingtwoormoredataproviders,thenamesofvariables
mayalsocontainthenameofthedataproviderthattheybelongto.For
example,Year(Query2oneFashion)istheYeardimensionfromthesecond
querybuiltontheeFashionuniverse.
Thisadditionalinformationonlyappearsifthedataprovidersinthedocument
containvariableswiththesamename.Insuchcases,tohelpyoudistinguish
betweenvariableswiththesamename,whichinfactcomefromdifferent
datasources,DesktopIntelligenceautomaticallyinsertsthefullvariable
nameforexampleYear(Query2oneFashion)incolumnheadingsinthe
report.
DesktopIntelligenceAccessandAnalysisGuide
105
6
ManagingDataProviders
Renamingdataproviders
Annotate, Redact Image in .NET Winforms| Online Tutorials
Click "Font" to change annotations font color, size We are dedicated to provide powerful & profession imaging controls, PDF document, image to pdf
adding images to pdf forms; add email button to pdf form
C# PDF Text Box Edit Library: add, delete, update PDF text box in
Support to change font color in PDF text box. Ability to change text size in PDF text box. Adding text box is another way to add text to PDF page.
add attachment to pdf form; change font pdf fillable form
Selectingthedataprovideryouwanttoedit
Editingadataproviderinadocumentwithmultipledataprovidersalsocauses
eachdataprovider'snametoappear.WhenyouselecttheEditDataProvider
commandontheDatamenu,youarepromptedtoselectonedataprovider
inthefollowingdialogbox.
Givingdataprovidersmoremeaningfulnamescanhelpyouknowrightaway
whichoneyouwant.
Torenamedataproviders
YourenamedataprovidersintheDataManager.
1. Openthedocumentcontainingthequeryyouwanttorename.
2. ClickViewDataontheDatamenu.
TheDataManagerappears.
3. Clicktheiconofthedataprovideryouwanttorename
4. ClicktheDefinitiontab.
5. TypethenewnameintheNamebox.
6. ClickOK.
Getting statistics on data providers
DesktopIntelligenceallowsyoutofindoutusefulinformationondata
providers,suchaswhenaquerywaslastrefreshed,howmanyrowsofdata
apersonaldatafilereturned,andhowlongittooktorefreshafree-handSQL
script.
Togetstatisticsondataproviders
1. Openthedocumentcontainingthedataprovider.
2. ClickViewDataontheDatamenu.
TheDataManagerappears.
106
DesktopIntelligenceAccessandAnalysisGuide
ManagingDataProviders
6
Gettingstatisticsondataproviders
C# PDF Annotate Library: Draw, edit PDF annotation, markups in C#.
Able to edit and change PDF annotation properties such as font size or color. Abilities to draw markups on PDF document or stamp on PDF file.
chrome save pdf with fields; add date to pdf form
3. Clicktheiconofthequeryyouwanttofindoutabout.
4. clicktheDefinitiontab.
Theinformationappearsinthebottomrightcornerofthedialogbox.
Purging and deleting data providers
What'sthedifferencebetweenpurginganddeletingadataprovider?Purging
meansemptyingadataproviderofitsresults,deletingmeansgettingridof
thedataproviderforgood—anactionthatcannotbeundone.
Whypurgeordeleteadataprovider?Purgingreducesthesizeofadocument,
soisusefulwhenyouwanttosendthedocumenttootherusers,orsaveit
onyourharddrive,forexample.Youshouldonlydeleteadataprovider,
however,ifyouarecertainthatyouandotherusersnolongerneedit.
Topurgeordeleteadataprovider
1. Openthedocumentcontainingthedataprovider.
2. ClickViewDataontheDatamenu.
TheDataManagerappears.
3. Clicktheiconofthequeryyouwanttopurgeordelete.
4. ClickPurge/Delete.
5. ClickYesintheconfirmationboxthatappears
6. ClickOKtoclosetheDataManager.
Tip:YoucanpopulateapurgeddataproviderbyclickingRefreshDataon
theDatamenu.Notethatthiscommandrefreshesallthedataprovidersin
theactivedocument.
Using data providers efficiently
Ifyouhavemultiplereportsonseparatereporttabsandthesereportsdraw
theirdatafromthesamesource,youdonotneedtocreateaseparatedata
providerforeachreport.Insteadyoucreatea"base"dataproviderthat
containsthedatausedbyallthereports.Thisapproachisbetterbecause
DesktopIntelligenceperformsonedataretrievalforeachdataprovider;itis
DesktopIntelligenceAccessandAnalysisGuide
107
6
ManagingDataProviders
Purginganddeletingdataproviders
moreefficienttoretrievedataonceandshareitamongreportsthantoretrieve
thesamedataseveraltimes.
Reportsshowingrevenuebycountryandresort,
revenuebycountry
InthisexampletheRevenueandCountryobjectsarecommontobothreports.
Insteadofcreatingadataproviderforeachreportyoucreateadataprovider
containingtheRevenue,Country,andResortobjectsandusetheseobjects
inbothreports.
Example:Tocreateadataproviderusingcertainobjects
1. Createareportshowingrevenuebycountryandresortbydraggingthe
Country,ResortandRevenueobjectsintothereport.(See"Buildinga
basicqueryonauniverseforanexplanationofhowtobuildareporton
auniverse.)
2. AddanadditionalreporttabbyclickingReportontheInsertMenu.
3. DragtheCountryandRevenueobjectstothenewreporttabtocreate
therevenuebycountryreport.
Whenyourunthisreport,DesktopIntelligenceretrievesthedataonceand
sharesitbetweenthetworeports,ratherthanretrievingthedatatwice.
Note:YoucanusetheQueryPaneltomodifyadataproviderbyclicking
EditontheDatamenu.Dothisratherthancreateanewdataproviderifyou
wishtoaddanewreporttoanewtabandthenewreportusesthesameor
similardatatoyourexistingreport(s).
108
DesktopIntelligenceAccessandAnalysisGuide
ManagingDataProviders
6
Usingdataprovidersefficiently
Introduction to Data
Analysis
7
Overview
WithDesktopIntelligence,youanalyzedatabylookingatitondifferentlevels
ofdetailandfromdifferentviewpoints.Throughyouranalysis,yougainnew
informationandtherebyanswerquestions.
YouneedgonofurtherthantheDesktopIntelligenceinterfacetoaddress
allyourmultidimensionalanalysisneeds:
• DesktopIntelligenceon-reportanalysisallowsyoutoworkdirectlyon
yourdatainyourreportusingdraganddropandorwithsimplemouse
clicks.
• Explorer,anoptionalcomponentinDesktopIntelligence,enablesyouto
carryoutmultidimensionalanalysisinDrillmode.
• DesktopIntelligenceSliceandDicemodeallowsyoutoorganizedata
foranalysisinthesliceanddicepanel.
On-report analysis
ThispartoftheUser'sGuidedescribeshowDesktopIntelligenceon-report
analysisallowsyoutoanalyzeyourdatadirectlyonyourreportusingeasy
mouseclicksanddraganddroporwithasimplemouseclick.
Youcandraganddropdataonyourreporttogetadifferentviewpointfor
youranalysis.YoucanadddatafromtheReportManagertocreatetables
andsections.Youcanreplace,swapandre-organizedataonthereport.
DesktopIntelligenceredoesthecalculationsinyourreportimmediatelyso
thatyoucanseeatoncehowdifferentcombinationsoffactorsaffectyour
performance.
Dynamicon-reportgroupingallowsyoutocreategroupsforcomparative
analysisandyoucanquicklyinsertcommonbusinesscalculationsoreasily
createyourownformulasandvariablesforanalysis.
Youcansort,filterandrankyourdatausingasimplemouseclicktofocus
youranalysisonasliceofdata.
110
DesktopIntelligenceAccessandAnalysisGuide
IntroductiontoDataAnalysis
7
Overview
Documents you may be interested
Documents you may be interested