SAPIDTCreatingUniverse

[Link]
[Link]

TocreateaUniverseinIDT,gotoStartAllProgramsSAPBusinessIntelligenceSAPBusinessObjects
BIPlatform4ClientTool.

InInformationDesignTool,[Link]
NameandClickonFinish.
Oncetheprojectiscreated,nextistocreateanOLAPorRelationalconnectiontoconnecttoadatasource.A
[Link]
isusedtoconnecttothemultidimensionalmodellikeanInformationViewinSAPHANA.

RightclickonProjectnameNewSelectRelationalConnectionEnterconnection/resourcename
Next.
ChooseSAPfromthelistSAPHANASelectDriversJDBCNextEnterdetails.

Enterthesystemdetails,username,password,andclickNext.
ClickFinish.

UnderGeneralInformationClickonTestConnectionSuccessful.

WehavetopublishthisconnectiontotheRepositorytomakeitavailableforuse.

RightclickontheconnectionnamePublishtheconnectiontotheRepositoryEnterBOrepository
passwordClickonConnectFinishYes.
Onceyouclickonfinish,itwillcreateasecureRepositoryconnection.
.cnssecuredRepositoryconnection

.cnxlocalunsecuredifyouusethisconnectionitwillnotallowyoutopublishanythingtorepository.

ThenextstepistocreateaDataFoundationLayeronthissecureconnection.

[Link].

[Link]
[Link]
[Link].

TodefineaJoin,[Link]
differentJoinsasperdatarequirementandclickondetectCardinalitytodefinecardinality1:1,1:n,n:n.
[Link].
Then,[Link].

EnterResourceNameGeneratingBusinessLayerf orDataF [Link]

[Link],measures,
aggregation,etc.
TodefineanAggregation,[Link]
[Link].

OnceyoudefineBusinessLayer,clickSaveAlliconatthetopofthescreenasshowninthefollowing
screenshot.

TopublishaUniversetotheRepository,[Link].
SelectResourcesNextInPublishUniversewindow,selectNextSelecttheRepositoryfolderwhere
youwanttopublishUniverseandclickFinish.

YouwillgetaconfirmationthatUniversepublishedsuccessfully.

TochecktheUniverseunderRepository,gotoRepositoryresourcesandcheckfortheUniversethathasbeen
created.
CreatingaUniverseonSAPERP
[Link]
connectiontoERPdatasource,infosets,SAPqueries,andABAPfunctionsthataretreatedastablesinthe
connection.

YoucancreateasinglesourceDataFoundationtosupportlocalconnectionsbutitdoesntsupportJoinsand
calculatedcolumnsbetweenthetablesinsertedfromanERPconnection.

Touseacalculatedcolumn,joins,youneedtocreateaDatafoundationthatismultisourceenabledona
securedconnection.

CreatingaUniverseonSAPERP

WhenatableisaddedinDataFoundationlayer,thetabletypeofinfoset,SAPquery,orABAPfunctionis
[Link],thereisonedatafoundation
tablecreatedtomapthemainfunction.

[Link]
[Link],youneedtoedittheinputcolumns.

LimitationsofUsingSAPERP
WhenyouusemeasuresthatcontainaggregatefunctionsitcantbeusedasfiltersintheQueryPanelasthe
outputSQLexpressionconsistsofHAVINGclause,[Link],
ifameasureisaddedthatcontainsAggregationfunctionasfilter,itthrowsanerrorwhilerefreshingthequery.

CreatingaUniverseonSAPBW
IfyouwanttouseSAPBWtodesignaUniverse,youshoulduseadatafoundationbasedonmultisource
[Link]
BusinessLayeriscreatedonDataFoundation,allobjectsareautomaticallymovedtotheBusinessLayer.
Ifyoudontwanttoinserttablesandjoinsautomatically,youcanunselecttheDetecttablesbygoingtoadvance
propertieswhileaddingconnectiontoDataFoundation.

YoucanalsoturnoffinsertionofBusinessLayerobjectsbyuncheckingtheoptiontoautomaticallycreate
classesandobjectswhenselectingdatafoundationinNewBusinessLayer.

CreatingaUniverseonMicrosoftAnalysisServices
YouhavetocreateBusinessLayeronMicrosoftAnalysisServicesM AS andbusinesslayerobjectsarecreated
[Link]

DimensionAnalysisdimensionsarecreatedinthebusinesslayerforeachdimensioninthecube.

DisplayFolderFoldersarecreatedintheanalysisdimensiontocontainthehierarchiesinthedisplay
folder.

HierarchyForvaluebasedparent childhierarchies,avaluebasedhierarchyiscreatedinthe
[Link].

AttributeHierarchyAttributehierarchiesinthecubearecreatedaslevelbasedhierarchiesinthe
analysisdimension.

NamedSetNamedsetsarecreatedintherelatedanalysisdimension,inthefolderNamedsets.

MeasuresandCalculatedMeasuresMeasuresandcalculatedmeasuresarecreatedasmeasuresinthe
[Link].

CreatingaUniverseonSAS
YoucanbuildaUniverseonSASbyusingmultisourceenableddatafoundationandusingasecureconnection.

ConnectiontoSASdatasourcearemanagedbydatafederationservice.
MultilingualUniverses

[Link]
solutionbyusingsingleUniversemetadatamodel.

FollowingarethestepstousemultilingualUniverseforreportcreation

Step1UseUniversedesignertodesignUniverseinsourcelanguageinIDT.

Step2Usetranslationmanagementtooltotranslatethemetadatainthedatafoundationandbusinesslayer.

Step3UsereportdesignerstobuildthereportsonthesameUniverse,whichcanbedisplayedindifferent
languagesasperuserpreferences.

Step4GotoInformationDesignToolPreferencesPreferredViewingLocaledeterminesthelanguageof
themetadataanddataintheQueryPanel.

Thiscanbeusedifyouhavesupportforthefollowing

Translationsareavailableinthelanguagemetadata.

Theconnectionsupportsthelanguageparameterdata.