c# pdf to image conversion: Convert pdf to editable form control application platform web page azure winforms web browser Business_Objects_Desktop_Intelligence

Why?Theinputcontextrequiredtodisplayrevenuefor1998isYear,

whereastheoutputcontextofthebreakfooterisResort.Tofixthiserror,

youaddYeartotheoutputcontextusingtheForEachoperator:

=(If (<Year>="FY1998") Then <Revenue>) ForEach <Year>

Finally,youaddMax(orMin)toreturnthesinglevalueyouneed:

=Max((If (<Year>="FY95") Then <Revenue>) ForEach <Year>)

DesktopIntelligencenowdisplaysRevenuefor1998inthebreakfooter.

Solutionfor#COMPUTATIONinanon-aggregateformula

1. Edittheformulasothattheoutputcontextisincludedintheinputcontext,

asdescribedintheexampleabove.

2. AddMaxorMintothebeginningoftheformula,followedbyanopening

parenthesis.

3. Addaclosingparenthesisattheendoftheformula,thenpressEnter.

#MULTIVALUE

Thissectionprovidesdescriptions,examplesandsolutionsfor#MULTIVALUE

inDesktopIntelligence:

• #MULTIVALUEinaggregationsonpage272suchasmaximumrevenue

peryear

• #MULTIVALUEinbreakheadersandfootersonpage274

DesktopIntelligenceAccessandAnalysisGuide

271

CalculationTroubleshooting

#MULTIVALUE

Convert pdf to editable 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

cannot save pdf form; pdf create fillable form

Convert pdf to editable 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

change text size pdf form; create a form in pdf

#MULTIVALUE inaggregations

Theexpression"aggregations"referstoanycalculationcontainingan

aggregatefunctionsuchasSum,Count,Min,Maxetc.Inreports,

aggregationsletyouanswerquestionssuchas"Whatistheminimumrevenue

percityforeachregion?".

Thissectionprovidesadescriptionofwhy#MULTIVALUEoccursin

aggregations,withanexample,andoffersasolution.

Note:

TheinformationpresentedhererequiresthatyouunderstandDesktop

Intelligenceextendedsyntax,whichisdescribedin"CalculationContexts

andExtendedSyntax."

Descriptionof#MULTIVALUEinanaggregation

#MULTIVALUEoccursinaggregationsbecause

Example:#MULTIVALUEinanaggregation

Lookatthefollowingtable:

Thedesiredresultintheright-handcolumnisrevenueforadimensionthat

isnotpresentinthetable,forexample,Year.Theformula

=<Revenue> In <Year>

returns#MULTIVALUEbecauseYearisspecifiedastheoutputcontextbut

itisnotpresentinthelocalcontext(thetable).

272

DesktopIntelligenceAccessandAnalysisGuide

CalculationTroubleshooting

#MULTIVALUE

C# PDF Convert to Text SDK: Convert PDF to txt files in C#.net

RasterEdge PDF document conversion SDK provides reliable and effective .NET solution for Visual C# developers to convert PDF document to editable & searchable

change font size pdf form reader; build pdf forms

C# PDF Convert to Word SDK: Convert PDF to Word library in C#.net

hardly edit PDF document. Under this situation, you need to convert PDF document to some easily editable files like Word document.

adding text fields to pdf acrobat; adding a signature to a pdf form

Note:

Theformulainthisexampledoesnotbeginwithanaggregatefunction(Min,

Max,etc.).Ifyouomitthefunctioninthisway,DesktopIntelligencecalculates

asumbydefault.However,ifyouhadspecifySumoranotheraggregatefunction

intheformulaabove,forexample

=Sum(<Revenue>) In <Year>

DesktopIntelligencereturns#COMPUTATION.

IftheYeardimensionisavailableinthedocument,youcan,usingextended

syntax,calculaterevenueperyearwithoutdisplayingYearinthetable.To

dothis,youmustdefineaformulawithaninputandanoutputcontext,like

this:

=Sum(<Revenue> In (<Region>,<City>,<Year>) In <Year>)

Solutionfor#MULTIVALUEinanaggregation

Toavoid#MULTIVALUEinanaggregation,theoutputcontextmustbe

includedinthelocalcontext,whichmeansthatthedimension(s)specified

ontherightoftheformulaafterInorForEachmustbepresent.

Tofixyourformula:

1. DisplaytheFormulaBar(FormulaBarcommand,Viewmenu),thenclick

thecellcontainingtheformula.

2. Lookforthefollowing:

• Doestheoutputcontextcontaindimensionsthatarenotintheblock

orsectioninwhichtheformulaisinserted?Forexample,ifthefollowing

formulaappearsinablockthatdoesnotcontainYear,you'llgeta

#MULTIVALUE:

=Min(<Revenue>)In(<Year>)

• Doestheoutputcontextcontainmoredimensionsthanthelocal

context?

• Forexample

=Min(<Revenue>) In(<Region>,<City>)

DesktopIntelligenceAccessandAnalysisGuide

273

CalculationTroubleshooting

#MULTIVALUE

C# Create PDF Library SDK to convert PDF from other file formats

file. Create and save editable PDF with a blank page, bookmarks, links, signatures, etc. Create fillable PDF document with fields.

pdf add signature field; change font in pdf form

VB.NET PDF Convert to Word SDK: Convert PDF to Word library in vb.

Convert PDF document to DOC and DOCX formats in Visual Basic control to export Word from multiple PDF files in Create editable Word file online without email.

pdf fillable form creator; add signature field to pdf

• returns#MULTIVALUEinatablecontainingonlyoneofthese

dimensions.

3. EdittheformulaintheFormulaBar,thenpressEnter.

#MULTIVALUE inbreakheaders andfooters

#MULTIVALUEcanoccurwhenyouinsertavariableinabreakheaderor

footerinatableorcrosstab.

Descriptionof#MULTIVALUEinabreakheaderorfooter

Abreaksplitsupthevaluesofavariableandthusenablesyoutomake

calculations.

Abreakfooterisacellatthebottomofeachvalueofthebreak.Users

typicallydisplaytextorcalculationssuchasrunningtotalsinbreakfooters.

#MULTIVALUEoccursinabreakheaderorfooter:

And...

ThenYou...

IfYou...

Thesetwovariables

havea1:1relationship,

asisthecasewithCus-

tomerandAge.

Insertasecondvariable

inthebreakfooter

Setabreakonavari-

able

Here'sanexample.

Example:#MULTIVALUEinabreakfooter

Thetablebelowshowstherunningtotalrevenuefortwocustomers.When

youinsertAgeinthebreakfooter,DesktopIntelligencereturns

#MULTIVALUE.

274

DesktopIntelligenceAccessandAnalysisGuide

CalculationTroubleshooting

#MULTIVALUE

VB.NET PDF Convert to Text SDK: Convert PDF to txt files in vb.net

to editable & searchable text formats. Support .NET WinForms, ASP.NET MVC in IIS, ASP.NET Ajax, Azure cloud service, DNN (DotNetNuke), SharePoint. Convert PDF

allow users to save pdf form; can save pdf form data

VB.NET Create PDF from PowerPoint Library to convert pptx, ppt to

Link: Edit URL. Bookmark: Edit Bookmark. Metadata: Edit, Delete Metadata. Form Process. Convert multiple pages PowerPoint to fillable and editable PDF documents.

add text field to pdf acrobat; create a form in pdf from word

Thiserroroccursbecausevariableswitha1:1relationship,(Customerand

Age),areinsertedatthesamebreaklevel.Bydefault,abreakisbasedon

onevariableonly.

Solutionfor#MULTIVALUEinabreakheaderorfooter

Youfixthisproblembyincludingthevariablefromtheheaderorfooterin

thebreakdefinition.

1. Clickinsidethetableorcrosstabcontainingthebreak,thenselectclick

BreaksontheFormatmenu.

TheBreaksdialogboxappears.

2. Clicktheiconofthebreakconcerned,thenclickEdit.

3. Adialogboxlistingallthevariablesinthereportappears.

4. Clickthecheckboxnexttothevariableyouwanttodisplayinthebreak

footer(Ageinthepreviousexample),thenclickOK.

5. ClickOKintheBreaksdialogbox.

DesktopIntelligencedisplaysthevariableinthebreakfooter.

DesktopIntelligenceAccessandAnalysisGuide

275

CalculationTroubleshooting

#MULTIVALUE

VB.NET Create PDF from Word Library to convert docx, doc to PDF in

Link: Edit URL. Bookmark: Edit Bookmark. Metadata: Edit, Delete Metadata. Form Process. Convert multiple pages Word to fillable and editable PDF documents.

add forms to pdf; change font size in fillable pdf form

VB.NET Create PDF from Excel Library to convert xlsx, xls to PDF

Create fillable and editable PDF documents from Excel in Create searchable and scanned PDF files from Excel in VB Convert to PDF with embedded fonts or without

add jpg to pdf form; adding image to pdf form

#MULTIVALUEinacellatthesectionlevel

Areportsectiondisplaysdatainamastercellandinablockorblocks.Ifyou

usetwovariablesatthesectionlevel,#MULTIVALUEcanoccur.Here'san

example.

Example:#MULTIVALUEinasectioncontainingnameandaddress

Youwanttodisplaycustomernamesandaddressesinasection,andthe

customers'revenuedetailsinatable.YoubuildatablecontainingCustomer,

Address,InvoiceDateandRevenue,thendragCustomeroutoftheblock

tocreateasection.

276

DesktopIntelligenceAccessandAnalysisGuide

CalculationTroubleshooting

#MULTIVALUE

C# Create PDF from Excel Library to convert xlsx, xls to PDF in C#

Create fillable and editable PDF documents from Excel in both .NET WinForms and ASP.NET. Create searchable and scanned PDF files from Excel. Convert to PDF with

change pdf to fillable form; adding text to a pdf form

ThenextstepistodragAddressoutoftheblock,anddropitnextto

Customer.Here'swhatyouget:

Why?Becausebydefault,thereisonlyonemastervariablepersection.

Solution#1for#MULTIVALUEatthesectionlevel

Thewayaroundthisproblemistoturnthevariablethatreturnstheerrorinto

ameasure.

1. Clickthecellcontainingthe#MULTIVALUEerror.

2. ClickVariablesontheDatamenu.

TheVariablesdialogboxappears:

3. Inthedialogbox,clickthevariablethatreturnstheerror.

4. Thenextstepdependsonthetypeofvariableyoujustclicked:

DesktopIntelligenceAccessandAnalysisGuide

277

CalculationTroubleshooting

#MULTIVALUE

IftheEditbuttonisavailable

IftheEditbuttonisgrayed

Youcanchangethevariableintoa

measure.

Thismeansthatthevariableyou

needtoturnintoameasurecomes

fromaqueryonauniverse.

Youcannoteditvariablesthatcome

fromqueriesonuniverses,soyou

havetocreateanewvariablein-

stead.

ClickEdit.

TheVariableEditorappears.

IntheQualificationbox,clickMea-

sure,thenclickOK.

ClickAdd.

TheVariableEditorappears.

IntheDefinitiontab,typeaname

forthenewvariable.

IntheQualificationbox,clickMea-

sure.

ClicktheFormulatab.

IntheVariablesbox,double-click

thenameofthevariablethatre-

turnedtheerror.Forexampleifyou

arecreatinganewvariabletore-

placeAddress,double-clickAd-

dressintheVariablesbox.

ClickOK.

5. IntheVariablesdialogbox,clickReplace.

Youreplacetheerroneousvariablewiththeoneyouhavejusteither

createdormodified.Thedataappearsinsteadoftheerror.

278

DesktopIntelligenceAccessandAnalysisGuide

CalculationTroubleshooting

#MULTIVALUE

Solution#2for#MULTIVALUEatthesectionlevel

Youcanalsofix#MULTIVALUEatthesectionlevelbyapplyingtheMinor

Maxfunction,whichforcesDesktopIntelligencetodisplayonlyonevalue.

Thissolutionworksformastervariableswitha1:1relationship,suchas

CustomerandAddress(unlessyourcustomershavemorethanoneaddress).

Ifthevariablereturning#MULTIVALUEcontainsmorethantwovalues,you

willonlybeabletodisplaythefirstandlastofthesebyapplyingMinorMax.

1. Clickthemastercelldisplaying#MULTIVALUE.

2. IntheFormulaBar,typeMinorMaxafter(=),thenaddparentheses,like

this=Min(<Address>)

3. PressEnter.

#######

Thecellisnotwideenoughtodisplaythedataitcontainsinfull.

Solution:double-clickthecell'srightborder.DesktopIntelligencewidensthe

celltoautofitthedata.

#ALERTER

Thiserroroccurswhenanalertercontainsamissingvariable.Forexample,

ifthedefinitionofthealertercontainstheRevenuevariable,#ALERTER

appearsifRevenuedoesnotexistinthereport.

Thedefinitionofthealerteritselfmayalsobethecauseofthiserror.For

example,ifyoutrytocompareameasurewithadimension(Revenuegreater

thanCountry),#ALERTERisreturned.

Solution:

Youcan:

Obtainthemissingdatabyaddingthecorrespondingobjecttothequery

(EditDataProvidercommand,Datamenu)

Editthealertersothatitsdefinitioncontainsonlyavailabledata(Alerters

command,Formatmenu)

DesktopIntelligenceAccessandAnalysisGuide

279

CalculationTroubleshooting

#######

Deactivatethealerter(Alerterscommand,Formatmenu,thenuncheckthe

alerterinthedialogbox).

Checkthatthedefinitionofthealerterdoesnotcontainacomparisonsuch

asthatofameasurewithadimension.

Tip:TousetheAlerterscommandontheFormatmenu,firstclickanycell

containingdata.

#DICT.ERROR

InDesktopIntelligence,youcanformatareportbyapplyingatemplate.You

dothisbychoosingReport,thenclickingApplyTemplateontheFormat

menu.TheApplyTemplatedialogboxappears.

Atemplatecontainsasetofvariables,alsoreferredtoasthevariable

dictionary.Thereportyouwishtoformatalsocontainsavariabledictionary.

Whenyouapplyatemplate,unlessyouclickOptionsbuttonintheApply

Templatedialogboxinordertospecifythecorrespondencebetweenthetwo

variabledictionaries,DesktopIntelligenceautomaticallyreplacesthevariables

inthetemplatewiththevariablesinthereport.Insomecases,Desktop

Intelligencecannotmatchthevariabledictionariesandreturns

#DICT.ERROR.

Tofixthis problem:

1. Clickthecellcontaining#DICT.ERROR,thenclickVariablesontheData

menu.

The Variables dialog box appears.

2. Clickthevariableorformulathatyouwanttodisplayintheselectedcell.

3. ClickReplace.

TheVariablesdialogboxcloses,andthevariableorformulaappearsin

thereport.

280

DesktopIntelligenceAccessandAnalysisGuide

CalculationTroubleshooting

#DICT.ERROR

Documents you may be interested

c# pdf to image conversion : Convert pdf to editable form control application platform web page azure winforms web browser Business_Objects_Desktop_Intelligence_Guide27-part1916