Home

data-dictionary

1. a a Sa m E UIA m 2013 Tallan All rights reserved 19 Installation and User Guide Metadata Framework Data Dictionary Mapping Options The below screen is the default Dictionary Measure screen It contains two tabs one to create a new mapping between Dictionary entries and Measure lists and one to view the existing dictionary measure mappings e Mapping Dictionary Measure Windows Internet Explorer Gc ig http localhost MetadataFrameworkDataDictionary 3 DictionaryMeasureMap F Favorites v3 Ed Suggested sites e web Slice Gallery Mapping Dictionary Measure T 2 d Pagey Safety Tools v e SSaly gt E Glossary x gt RC Dota Dictionary Measure 5 Mapping Dictionary Measure h DUC Drag items between lists to create Measure to Dictionary Entry mapping Dictionary Application Fields Create New Mapping View Existing Mappings gt uo Explorer Dictionary Entries Measure List Filters gt Reports Average Sale Amount AAAA gt Dictionary Filters b C Admin Gross Profit Accrual Rate Gross Profit Margin Active Cards Measure Filters Order Count Adjusted Net Sales Order Quantity Adjusted Net Sales Local Currency ADs Issued ADs to be Issued Amount Auth Amt Auth Count Average Rate Award Dividend Count Done D KK Local intranet Protected Mode Off 4a 100 7 Click on the Dictionary Filters and Measure Filters links to e
2. 2013 Tallan All rights reserved 12 Installation and User Guide Metadata Framework Data Dictionary mm Data Cubes Windows Internet Explorer olx Gc 12 http localhost MetadataFrameworkDataDictionary 3t DataCube 8 x Seino og zy Favorites 3 u Suggested Sites Web Slice Gallery Data Cubes Gi d Cm v Page Safety Tools e gt Glossary mm Cubes b ev Mapping b Explorer b _ Reports I4 4 Page 1 of 1 P Cub Cube Name Description Defaut Measure Last Schema Update Last Processed Is Active ubes Measures Reseller Sales Amount 6 16 2009 4 20 25 PM 6 9 2009 9 48 06 AM Source System 6 12 2009 1 01 07 PM 9 9 2009 9 49 00 AM Parse Database Merchandising 6 12 2009 1 02 41 PM 9 9 2009 9 49 00 AM Mined Customers Measures Internet Sales Amount 6 9 2009 9 43 50 AM 6 9 2009 9 49 12 AM Operation 1 21 2010 6 33 38 AM 4 1 2011 12 19 54 AM Retail Measures Net Sales 6 12 2009 1 01 51 PM 9 9 2009 9 49 00 AM Li Strategy Plan 1 21 2010 5 38 44 AM 4 1 2011 12 19 44 AM Bee NEE o e This is the Cubes screen Here we have information related to the cubes in the SQL Server databases whose data has been scraped and imported into the MetadataRepository database This screen is read only and displays such information as the cube name description and default measure Notice that you can also filter results in the table using the Search by Name box 2013 Tallan All rights reserved
3. D http localhost MetadataFrameworkDataDictionary ParseDatabase HS Bina P he Lp Favorites n u Suggested Sites Web Slice Gallery v Parse Database m m v Page Sefety Tools Q b E Glossary Analysis Server E Data local gt oa Mapping gt Reports Analysis Server Database ContosoRetailDW Server local Cubes Source System ContosoRetailDW Parse Database Repository Server local Repository Database MetadataRepository Parse Database amp Local intranet Protected Made Off Yay 100 L LZ This is the Parse Database screen In this screen we see that there are six text boxes altogether with five editable The text boxes are as follows i Analysis Server this is the name of the SQL Server Analysis Server where the Analysis Server database that will be scraped lives ii Analysis Server Database this is the database for which the Analysis Server information will be scraped ii Server this is the name of the SQL Server instance where the database that will be scraped lives should be identical to the Analysis Server information iv Database this is the database that will be scraped for information should be identical to the Analysis Server Database information v A Repository Server this is the SQL Server instance name where the repository database lives By default it is assumed that the application lives on the same box as the application
4. METADATA FRAMEWORK DATA DICTIONARY INSTALLATION AND USER GUIDE 2013 Tallan All rights reserved Installation and User Guide Metadata Framework Data Dictionary mm METADATA FRAMEWORK DATA DICTIONARY DESCRIPTION The Metadata Framework Data Dictionary application MFDD was created to allow a user to explore the metadata of their databases A user can parse out the contents of any SQL Server Data Warehouse or Cube and look at the measures measure groups and associations that are present Why is this important For the purposes of Business Intelligence a company can have many sources of data that they would like to put together and analyze patterns trends or parallels they can extract data from different systems create reports on it and see information outside the design of the original database In the Microsoft world this is accomplished by building SQL Server Analysis Services cubes on top of a data warehouse that can relate to data in more business friendly terms for the target audience There are many hierarchies that you can structure into your description of the business in your cube once described you can start measuring these aspects of your business how many sold forecasts sales etc This data can come out of the cube and be presented using various mediums such as Microsoft Excel SQL Server Reporting Services or on screen dashboards using SharePoint What s missing here is that if a user is new t
5. so local is automatically filled in for each of the server text boxes 2013 Tallan All rights reserved 9 Installation and User Guide Metadata Framework Data Dictionary This feature allows a user administrator to enter the server and database that they would like to scrape for information By clicking Parse Database you add the information from the target databases to the MetadataRepository database 2013 Tallan All rights reserved 10 Installation and User Guide Metadata Framework Data Dictionary 2 SourceSystem Page Windows Internet Explorer Go E http localhost MetadataFrameworkDataDictionary xt SourceSystem hd s hel X et Bing L5 Ly Favorites 33 y Suggested Sites Web Slice Gallery sourceSystem Page NC ge Page Safety Tools gt Glossary ee Source System b Mapping i 7 Explorer Search by Name Clear Filters b j Reports I4 4 el ofi gt gt i lenis Name D ipti Cubes ERP Microsoft Dynamics AX HR PeopleSoft Source System Entry et X ip IA Microsoft Dynamics AX a Local intranet Protected Mode Off g 100 7 This is the Source System screen This screen allows you to add edit and view information on Source Systems used in the organization Here we see that the corporation is running Microsoft Dynamics AX as the ERP system and PeopleSoft as their HR system In this example ERP Microsoft Dynamics AX is selected
6. Sale Amount Brvmt Used d total gross sales orders Average Sale Amount Order Count Average Sale Amount PO On Order Cost Average Sale Amount PO Receipts Cost Average Sale Amount Reseller Order Quantity I4 4 Page 1 ofS Ph Done o KK Local intranet Protected Mode Off Fa R10 7 2013 Tallan All rights reserved 24 Installation and User Guide Metadata Framework Data Dictionary The following are screens for Dictionary Application Field mapping Click on the Dictionary Filters and Application Field Filters links to expand the filtering options We are currently showing all mapped and unmapped dictionary entries with any status approved pending and denied We are also showing all mapped and unmapped application fields from all application groups To filter and map items follow the same instructions as specified for mapping Dictionary Entries and Measures listed above ae Mapping Dictionary Application Field Windows Internet Explorer http localhost MetadataFrameworkDataDictionary 3 DictionaryApplicationFieldMap w Favorites 3 g Suggested Sites 4g Web Slice Gallery v amp Mapping Dictionary Application Field Te 72 l n Page Safety Tools v e p gemuy LI LJ e s a m Dictionary Application Fields x Mapping Dictionary Measure TP Ps Drag items between lists to create Application Field to Dictionary Entry mapping Dictionary Application Fields Crea
7. denydatareader Cg Server Objects Progress db denydatawriter E Replication E Management B SQL Server Agent Connection db securityadmin 12 40 PM 59 P 13 ibo 5 19 2011 E 2013 Tallan All rights reserved 7 Installation and User Guide Metadata Framework Data Dictionary App should load up like this fe Dictionary Windows Internet Explorer G x Favorites 3 u Suggested Sites Web Slice Gallery v Dictionary fy gt ga v Page Safety gt Tools gt ig http localhost MetadataFrameworkDataDictionar yt Dictionary aall t ens 2z v KC Glossary m Dictionary Applications gt Data Search by Long Name D 1 Clear Filters gt C9 Mapping New Dictionary i4 4 Page 1 ofi p gt d Wo Explorer Long Name Short Name Data Type Data Steward Is Active y ull Reports Average Sale Amount Avg Sales Integer Chery Riggins Director of Finance P gt Admin Gross Profit GP Currency Sally Smith Accounting P Gross Profit Margin GP 95 Decimal Nobody will own up to this one P Order Count Order Count integer Tom Smith Sales Manager P Order Quantity Order Quantity Integer Tom Jones Director of Sales P Done D KK Local intranet Protected Mode Off Fa Rio 7 4 12 53 PM B9 o 09 tb sijzo11 2013 Tallan All rights reserved 8 Installation and User Guide Metadata Framework Data Dictionary Admin Options G Parse Database Windows Internet Explorer ICE XI
8. drilled down to different levels with the Adventure Works Mined Customers cube selected It s information is on the right In the last screen we have drilled down to a measure in the Contoso DW database with the information for that measure displayed on the right hand side 2013 Tallan All rights reserved 16 Installation and User Guide Metadata Framework Data Dictionary fo Explorer Measure Windows Internet Explorer Gc i http localhost MetadataFrameworkDataDictionary 3t MeasureExplorer ri hey x s Bing ys w Favorites v g Suggested Sites Web Slice Gallery v Explorer Measure Th zi Page Safety Tools e L gt Glossary gt Data Measures b Mapping v Database Measures Adventure Works DW 2008 Database b alj Reports EBAnalysis2 Database Clothing World Data tosoRetailDW Dae FE Local intranet Protected Mode Off vq amp 1009 7 2013 Tallan All rights reserved 17 Installation and User Guide Metadata Framework Data Dictionary x toes P F Le 19 gt g http localhost MetadataFrameworkDatabDictionary 3t MeasureExplorer Favorites E Kl sosestea Sites v Web Slice Gallery e Explorer Measure fp E 6 ode pages Safety Too gt KL Glossary Measures j Database Measures 2B Adventure Works DW 2008 DW Cube Cube Low Adventure Works Adventure Works DW 2008 B Mined Customers 5 Measure Group s Mea
9. install MetadataFramework D ata Dictionary to the following web location To install to this web location click Next To install to a different web location enter it below Site Default Web Site Disk Cost Virtual directory MetadataFrameworkD ataDictionary Application Pool Default amp ppPool m Default amp ppPool Classic NET AppPool ASP NET v4 0 ASP NET v4 0 Classic Windows ASP NET v4 0 Default amp ppPool System St Cancel lt Back ashraf vj 2h a ele arom SN m 2013 Tallan All rights reserved 5 Installation and User Guide Metadata Framework Data Dictionary Once installed make certain the default document for the new application points to main aspx EInternet Information Services IIS Manager Recycle Bin d j E gt 23 gt NY SQLAZURE gt Sites Default WebSite MetadataFrameworkDataDictionary gt i View Help I HB EG ga M a T i og Default Document Hile E me Start Page 1 43 NY SQLAZURE CORP zplevritis Use this Feature to specify the default file s to return when a client does not Disable koi request a specific File Set default documents in order of priority ae Application Pools E1 8 Sites Revert To Parent Na e ntry y pe HI e Help Default Web Site man aspx Online Hel H E aspnet_client j P MetadataFrameworkDataC E Certification Eres Defau
10. shows all of the active and inactive dictionary entries in the Meta Data Dictionary It also allows you to filter and edit entries in the dictionary results table 2 Dictionary Windows Internet Explorer Qo http localhost MetadataFrameworkDataDictionary Dictionary ri ey x 2 Bing L I Up Favorites 3s EJ susvested Sites g Web Slice Gallery Dictionary gt X Page Safety Tools e IG ciossary TM Dictionary Applications EE o l gt S Mapping m i 4 Pagi ofi pri Long Name Short Name Data Type Data Steward Status Is Active rts Average Sale Amount Avg Sales Integer Cheryl Riggins Director of Finance Admin Gross Profit GP Currency Sally Smith Accounting Gross Profit Margin GP Decimal Nobody will own up to this one Order Count Order Count integer Tom Smith Sales Manager Order Quantity Order Quantity Integer Tom Jones Director of Sales Bac J ov on EO ass HERR To filter the results in the table type in the name of the dictionary item to view Below we are filtering by the Average Sales Amount dictionary item 2013 Tallan All rights reserved 31 Installation and User Guide Metadata Framework Data Dictionary lolx Jee Ee lel f Dictionary Windows Internet Explorer we Favorites E E suooested Sites Web Slice Gallery Ee http localhost MetadataFrameworkDataDictionar y 3t Dictionary Dictionary a p Page Saf
11. 13 Installation and User Guide Metadata Framework Data Dictionary Reports Option The Measures Details screen under the Reports option is a read only screen that displays measure information for each of the cubes in the database Initially the Measures Details screen is blank awaiting options selections by the user as in the first screen The second screen shows measures details for the Discount Amount measure under the Adventure Works cube Notice that the drop down box is visible in the second screen showing the other measure names in the Adventure Works cube The technical and business information for the previously chosen Discount Amount is listed in the screen C Report Measure Details Windows Internet Explorer e 19 12 http localhost MetadataFrameworkDataDictionary 3 MeasureDetailsReport m hes ll X s Bing P z Lp Favorites v3 g Suggested Sites Web Slice Gallery Report Measure Details c X 1 Page Safety Tools e gt KE Glossary ce Measure Details gt 5 Mapping xe Explorer alj Reports Search by Cube Name F EAE Measure Name ma Details Measure Details RATA PSE ES IUE 2013 Tallan All rights reserved 14 Installation and User Guide Metadata Framework Data Dictionary G j v http localhost MetadataFrameworkDataDictionary MeasureDetailsReport x ol Bing og xy Favorites u Suggested Sites Web Slice Gallery v Report Measure D
12. A Total Gross Profit Dictionary Data Type Business Definition Integer d Bjelx fs 3 1 rJ t mp Page Safety Toolk The total gross retail sales amount by the total gross sales orders Done o KK Local intranet Protected Mode Off Fa R10 7 2013 Tallan All rights reserved 26 Installation and User Guide Data Options Metadata Framework Data Dictionary The Measures screen under the Data option allows you to filter view edit and map measures scraped from the databases in the organization The screen below shows the default view of the Measures screen showing all measures over twelve pages Data Measure Windows Internet Explorer http localhost MetadataFrameworkDataDictionary 3 Measure wr Favorites 3 g Suggested Sites Web Slice Gallery 7 E Data Measure Y Data Measures b ond Mapping gt we Explorer b J Reports Measures New Measure Measure Display Folder Format String AAAA Accrual Rate Active Cards x Adjusted Net Sales Currency Adjusted Net Sales Local Currency Currency ADs Issued ADs to be Issued Financial Amount Currency 00 Auth Count Average Rate Award Dividend Count Billable Closed Cards Brvmt Used Data Type string Double Integer Double Double Integer Integer Double Double Integer Double Integer Integer Double Double Double Integer Adventure Wo
13. Gross Profit Adjusted Net Sales iss dole Los Gross Profit Adjusted Net Sales Local Currency Description Gross Profit ADs to be Issued Dea IRE Decimal Gross Profit Decline Count ABE Net Sales Amount Product Cost Net o uL RERUM AAAA Business Definition Gabe Amo nt Gross Profit Margin Active Cards Gross Profit Margin Adjusted Net Sales Gross Profit Margin Adjusted Net Sales Local Currency Gross Profit Margin ADs Issued I4 4 Page 2 ofS Ph SS EE Rr a CREME To create a new mapping click the Dictionary Entries tab and drag a Dictionary Entry item over a Measure In the example below I have dragged the Average Sales Amount dictionary entry over the Amount measure The second screen shows the mapping information for this newly formed mapping 2013 Tallan All rights reserved 22 Installation and User Guide Metadata Framework Data Dictionary Mapping Dictionary Measure Windows Internet Explorer Of x Go http localhost MetadataFrameworkDataDictionary 3t DictionaryMeasureMap leli o ETE el r Favorites B u Suggested Sites Web Slice Gallery 7 Mapping Dictionary Measure Tu v e Page Safety Tools e b KC Glossary gt EC Data Dictionary Measure Mapping Dictionary Measure Mapping measure Amount to dictionary entry Average Sale Amount Success Dictionary Application Fields Create New Mapping View Existing Mappings gt gu Explorer Dictionary E
14. V Object VEW F SALES SKU LOC DAY T v Measure Group Daily Sales Cancel Local intranet Protected Mode Off a gt 100 7 Mappings can take place from this screen From the results table click the map hyperlink This is the mapping screen for the first item in the filtered results Adjusted Net Sales In the screen below we have filtered the dictionary names to only display any dictionary name that contains the word average whether or not it has been mapped all option selected To map the Adjusted Net Sales measure to the Average Sale Amount dictionary entry activate the checkbox to the right of the dictionary name and click the close button 2013 Tallan All rights reserved 29 Installation and User Guide Metadata Framework Data Dictionary Data Measure Windows Internet Explorer Go 12 http localhost MetadataFramew Ly Favorites vs P Suggested sites gj Web Slice Gallery orkDataDictionary Measure Mik x m 4 x fo Bing p Y Data Measure t Y mh Page Safety Tools e Adjusted Net Sales Search by Dictionary Name average Apply Filter Mapped Unmapped Q All Long Name Average Sale Amount Done NE m ion E Local intranet Protected Mode OFF fa R100 7 2013 Tallan All rights reserved 30 Installation and User Guide Metadata Framework Data Dictionary Glossary Option The Dictionary screen under the Glossary option
15. and it s information is listed in a child window below it On the right hand side there are three buttons edit add and delete i Clicking on the edit button we get the below screen The Save button becomes disabled until a change is made The cancel button is active ii Addis similar except that the Name and Description text boxes are blank ii Delete asks whether or not you would like to delete the record If you click yes the data is deleted otherwise the data is persisted Notice that you can also filter results in the table using the Search by Name box For example if you typed ERP and clicked the Filter button ERP would be the only item in the result table 2013 Tallan All rights reserved 11 Installation and User Guide Metadata Framework Data Dictionary mm SourceSystem Page Windows Internet Explorer Eje xi Go http localhost MetadataFrameworkDataDictionary 3t 5SourceSystem m X e Bing o zy Favorites v3 Y Suggested Sites web Slice Gallery SourceSystem Page fp gt d Page Safety Tools e b Glossary gt RC pets Source System gt e Mapping d Explorer Ed M b _ Reports I4 4 Page 1 of 1 l Name Description Cubes ERP Microsoft Dynamics AX Source System HR PeopleSoft Parse Database Source System Entry t xXx ne ip Microsoft Dynamics AX OD Re tocatintranet Protected Mode of va s 100 7 edit screen
16. etails r 272 Pagey Safety Tools e gt KC Glossary k Measure Details gt Is Explorer 3M Adventure Works Measure Name Discount Amount v Customer Count Measure Details d Admin End of Day Rate Extended Amount Measure Name Discount Amount Freight Cost Description Internet Extended Amount Data Steward Internet Freight Cost Internet Order Count Internet Order Quantity Data Cube Adventure Works Internet Sales Amount Database Adventure Works DW 2008 Internet Standard Product Cost Internet Tax Amount Measure Group Reseller Sales Internet Total Product Cost Display Folder Internet Transaction Count Measure Data Type Double Internet Unit Price System of Record Order Count Order Quantity Reseller Extended Amount Done Kk Localintanet Protected Mode Off Fa 100 7 2013 Tallan All rights reserved 15 Installation and User Guide Metadata Framework Data Dictionary Explorer Options The Measures screen within the Explorer option allows a read only view of the measures with the organization s databases in the form of a tree control that shows information in the following hierarchy i Database a Cube l Measure Group 1 Measure In the first screen below notice that the default view shows the tree structure containing the databases that have been scraped In the second screen we see the Contoso DW and Adventure Works DW 2008 databases have been
17. ety Tools e v KC Glossary E Dictionary Applications b Data E uA LAS Average Sale Amount Clear Filters gt Mapping NEW Deore l4 4 Page ofi rn p Long Name Short Name Data Type Data Steward Status Is Active Average Sale Amount Avg Sales Integer Cheryl Riggins Director of Finance P in ni aa IDEE e wn fms Below is the edit screen for the Average Sales Amount dictionary item Here you can edit all of the attributes of the dictionary item If you click cancel then the original data is persisted If you click on OK after making a change then the new information is persisted 2013 Tallan All rights reserved 32 Installation and User Guide Metadata Framework Data Dictionary mm Dictionary Windows Internet Explorer olx JS http localhost MetadataFrameworkDataDictionary Dictionary m X Bing Pi p Favorites 13 y Suggested Sites 4 Web Slice Gallery 7 Dictionary D D om Page Safety Toos Dictionary Entry Long Name Average Sale Amount Short Name Avg Sales Data Steward Cheryl Riggins Director of Finance Dictionary Data Type Integer Boundary Rules gt 0 Business Definition The total gross retail sales amount by the total gross sales orders Business Notes Returns adjustments and exchanges are not subtracted Business Rules Technical Definition tech test Is Active ga Approval Status P IO re L
18. lt Web Site MetadataFrameworkDataDictionary web config 2013 Tallan All rights reserved Installation and User Guide Metadata Framework Data Dictionary Open up SQL Management Studio and grant DB Owner rights to user MDR User as a security object inside the MetaDataRepository database a mall I Microsoft SQL Server Management Studio File Edit View Debug Tools Window Community Help T New Query iy c t Pn Lis 0 lel 3 Object Explorer Connect 32 49 m T E3 y Databases E System Databases gj Database Snapshots Select a page E ES Script Te Help EH r BaselineEdge gt General EventMonitoring Ey A l TEENS Ei I MetaDataRepository gt Extended Properties gj Database Diagrams Login name Bn Tables Certificate name Lj Views E Synonyms C Key name CE Programmability C without login E Service Broker Lg Storage Default schema db owner m E Lg Security Lg Users Schemas owned by this user dbo Owned Schemas guest db ddladmin INFORMATION SCHEMA db denydatareader M SS O db denydatawriter S 1 n 3X l User db securityadmin C Roles guest Lg Schemas gj Asymmetric Keys gj Certificates Server Database role membership d Symmetric Keys ny sqlazure Hie eit s CE Database Audit Specifications Connection db detamadal El ReportServer CORP zpleritis Reportserver TempbB 4j View connection properties pads a Tallan db ddladmin Lg Security db
19. ntries Measure List AAAA Filters v Dictionary Filters Gross Profit Accrual Rate Filter by Mapped Unmapped s Gross Profit Margin Active Cards d Pendi Denied Order Count Adjusted Net Sales do oes lm M T Order Quantity Adjusted Net Sales Local Currency ADs Issued v Measure Filters Auth Amt Filter by Mapped Unmapped a Auth Count Cube Average Rate Award Dividend Count LL aaa ea nna a al al an ESS Gee nnn PE ee 2013 Tallan All rights reserved 23 Installation and User Guide Metadata Framework Data Dictionary n Mapping Dictionary Measure Windows Internet Explorer Go v J http localhost MetadataFrameworkDataDictionary X DictionaryMeasureMap m ha X e Bing y X Ly Favorites 23 u Suggested Sites gt Web Slice Gallery amp Mapping Dictionary Measure TE Page gt Safety Tools e Dictionary Measure Dictionary Measure 1 Eu Drag items between lists to create Measure to Dictionary Entry mapping Dictionary Application Fields Create New Mapping View Existing Mappings gt uo Explorer gt a Reports Dictionary Entry Measure Name Mapping Details Average Sale Amount AAAA Average Sale Amount Accrual Rate Measure Data Type Double Average Sale Amount Active Cards pega This is the description Average Sale Amount ADs to be Issued Dei EP RETE Integer Average Sale Amount Amount es The total gross retail sales amount by the Average
20. o the system there is nothing in place to describe the metadata the metadata is the information about the information where it came from how it got to be there what does it mean Information may not match for example across some systems Profit from a sales perspective is different than the accounting aspect this application provides visibility to the entire data view with a user interface built in Silverlight Terminology relevant to the application The dictionary is the lump sum of the information it is the collection of terms that are agreed upon during the analysis The source systems are the external databases The measures are the cubes The applications are the ways to display the information Excel SharePoint There are screens in place that allow mapping of components to components you establish your entities you define them and then you map them together so that you can see the entire chain 2013 Tallan All rights reserved 1 Installation and User Guide Metadata Framework Data Dictionary mmm The parser application the Admin button automates the aspect of pulling the measures out of the data warehouse cube you can choose which terms to map or orphan those that you do not want to use This tool should be deployed as part of a Bl implementation as the user manual on the product you ve built something and the user can now see what has been delivered The diagram belo
21. ocal intranet Protected Mode Off A R10 5 The default Applications screen of the Glossary option is below It lists the master Application Group as the top level item in the tree structure 2013 Tallan All rights reserved 33 Installation and User Guide Metadata Framework Data Dictionary 2 Data Application Windows Internet Explorer g http localhost MetadataFrameworkDataDictionary 3t Applications x ha 4 x s Bing 2 z Lp Favorites w H suggested Sites web slice Gallery v Data Application tp p Page Safety Tool v IE Glossary GER Applications Applications gt E Data Application Group Mapping Enterprise Reports in E S S Drilling down we see the following hierarchy i Application Group a Application i Application Field Clicking on any object in the hierarchy brings up a summary box on the right hand side 2013 Tallan All rights reserved 34 Installation and User Guide Metadata Framework Data Dictionary f Data Application Windows Internet Explorer we Favorites p H suooested Sites Web Slice Gallery e Data Application Jels Em jer gl http localhost MetadataFrameworkDataDictionary 3t Applications 5 B8 v L v Page Safety Tools v KC ctossary GER Applications Applications gt Data Application Group gt Mapping B Enterprise Reports 3 i AN ath esi Total Numbe
22. r of Orders by Territory ppiication m Sales and Profit Summary by Territory Application Fietd Application Fiera Sales Application Field Details 8 Appi on Field Gross Profit Application Field Margin S I OS al el a eS a T To edit the information click on the edit button on the upper right and corner of the summary box You can edit the information in the text boxes below If you click on cancel the original information is persisted If you click OK after making a change the new information is persisted 2013 Tallan All rights reserved 35 Installation and User Guide Metadata Framework Data Dictionary Data Application Windows Internet Explorer CHE XI 3 Go gt http localhost MetadataFrameworkDataDictionary 3t Applications 1 we Favorites 3 Edi suocested Sites Web Slice Gallery pata Application a i D em z Pages Seek Took e KC Glossary EAT GER Applications Applications Application Field Details gt Data l Field Name Application Group gt Mapping B Enterprise Reports 3 n z ANS aha essai Total Number of Orders by Territory ippiication p 71 Explorer m Sales and Profit Summary by Territory Application Field Qty Application Field Sales Application Field Gross Profit Application Field Margin a al el al a eS eI RACE 2013 Tallan All rights reserved 36
23. rks Retail EBCube Retail Retail Retail Retail Adventure Works EBCube EBCube Adventure Works Retail EBCube Retail Retail Retail EBCube Database Adventure Works DW 2008 Clothing World EBAnalysis2 Clothing World Clothing World Clothing World Clothing World Adventure Works DW 2008 EBAnalysis2 EBAnalysis2 Adventure Works DW 2008 Clothing World EBAnalysis2 Clothing World Clothing World Clothing World EBAnalysis2 3 om Page Safety Tools e i4 4 Page 1 Done m E nj m a z a Local intranet Protected Mode Off Fa X 100 Z The following screen shows a subset of measures across all databases In the example below the letters adju have been entered into the search box and the filter was applied Adjusted and Unadjusted measures have been retrieved and displayed in the results table To clear the filter and view all measures as in the screen above click the clear filter button 2013 Tallan All rights reserved Installation and User Guide Metadata Framework Data Dictionary fo Data Measure Windows Internet Explorer S E http localhost MetadataFrameworkDataDictionary 3t Measure Lp Favorites VS u Suggested Sites Web Slice Gallery v ata Measure TTE om Pager Safety Tools b E Glossary apas Measures Measures d a Mapping Search by Measure Name Clear Filters gt M Explorer ia 4 Page 1 ofi bh gt Reports Mea
24. sure Display Folder Format String Data Type Database Adjusted Net Sales Double Retail Clothing World Adjusted Net Sales Local Currency Double Retail Clothing World Unadjusted Net Sales Double Retail Clothing World Unadjusted Net Sales Local Currency Double Retail Clothing World TUE LLL LM a VE The screen below shows the edit screen for the first item in the filtered list Adjusted Net Sales This screen allows you to modify any of the information related to the measure Some of the information that can be changes is the name and ID description whether or not it is active and which measure group it belongs to among other attributes If cancel is clicked then the original information is persisted If OK is clicked after changes have been made the new information will be persisted 2013 Tallan All rights reserved 28 Installation and User Guide Metadata Framework Data Dictionary lei E3 Data Measure Windows Internet Explorer M o5 v http localhost MetadataFrameworkDataDictionary Measure m X fo Bing Ly Favorites 3 u Suggested Sites Web Slice Gallery Data Measure uw mp Page Safety Toos Measure Entry Display Folder Measure Name Adjusted Net Sales Measure ID Adjusted Net Sales Format String Currency Measure Expression Measure Data Type Double Description System Of Record ERP Is Active o DS
25. sure Group Internet Sales Mined Customers Measure Group Internet Orders Measure Group Internet Customers Measure Group Sales Reasons Measure Group Exchange Rates Database EBAnalysis2 Database Clothing World Database ContosoRetailDW Cube Operation Cube 5 Strategy Plan Measure Group 5 Strategy Plan Measure Strategy Plan Amount Measure Gr Fact Exchange Rate ne TIRE UTE 2013 Tallan All rights reserved 18 Installation and User Guide Metadata Framework Data Dictionary S Explorer Measure Windows Internet Explorer Go we Favorites b Kl suosested Sites v dg Web Slice Gallery e Explorer Measure Jal Em ler g http localhost MetadataFrameworkDataDictionary 3t MeasureExplorer p E code Pape Safety Tons e gt E Glossary Measures gt SP Mapping Database Measures Adventure Works DW 2008 DW_Measure Cuba Strategy Plan Amount Adventure Works ContosoRetailDW Cube Strategy Plan E Mined Customers Strategy Plan Measure Group Strategy Plan Amount Internet Sales N A Measure Group Internet Orders Measure Group Internet Customers Measure Group Sales Reasons Measure Group Exchange Rates Database EBAnalysis2 Database Clothing World Database a ContosoRetailDW Cube Operation Cube Strategy Plan Measure Grou m Strategy Plan Measure Group Fact Exchange Rate TUO
26. te This is an IIS application It requires IIS to be running on the host server in order for it to run Windows Server 2008R2 supports booting into Safe Mode which does not allow the web services to run Therefore this application does not run in safe mode 2013 Tallan All rights reserved 3 Installation and User Guide T Computer Network e Recycle Bin Certification Tool System St ashraf Metadata Framework Data Dictionary i MetadataFramework Data Dictionary LS X Welcome to the MetadataFramework Data P Dictionary Setup Wizard N The installer will quide you through the steps required to install MetadataFramework Data Dictionary on your computer WARNING This computer program is protected by copyright law and international treaties Unauthorized duplication or distribution of this program or any portion of it may result in severe civil or criminal penalties and will be prosecuted to the maximum extent possible under the law Cancel lt Back GY P v3 h 2013 Tallan All rights reserved 4 12 37 PM 5 19 2011 Installation and User Guide Metadata Framework Data Dictionary Make certain to choose an App pool that is running the ASP NET v4 you can accept the default pool created when the NET 4 Framework was installed or create a new one T Computer Network Recycle Bin ji MetadataFramework Data Dictionary Select Installation Address Certification The installer will
27. te New Mapping View Existing Mappings Ts Explorer Dictionary Entries Application Field List Filters wl Reports Average Sale Amount Gross Profit v Dictionary Filters b Admin Gross Profit Margin dead Mapped Unmapped Approved Pending Denied Gross Profit Margin Orders Order Count Qty Order Quantity Sales v Application Field Filters Filter by Mapped Unmapped E Application Group Done KK Local intranet Protected Mode Off 4a amp 100 7 2013 Tallan All rights reserved 25 Installation and User Guide n Mapping Dictionary Application Field Windows Internet Explorer Go J http localhost MetadataFrameworkDataDictionary Dictionary ApplicationFieldMap Ly Favorites 3 u Suggested Sites gt Web Slice Gallery 7 c Mapping Dictionary Application Field b KC Glossary Dictionary Measure Dictionary Application Fields gt MK Explorer b a Reports Metadata Framework Data Dictionary Dictionary Application Fields Drag items between lists to create Application Field to Dictionary Entry mapping Create New Mapping Dictionary Entry a Average Sale Amount Average Sale Amount Average Sale Amount Gross Profit Gross Profit Gross Profit Margin Order Count Order Quantity View Existing Mappings Application Field Name Gross Profit Gross Profit Sales Gross Profit Margin Margin Orders Qty Mapping Details ACEA eL
28. tive Cards Order Count Adjusted Net Sales A eR LB Order Quantity Adjusted Net Sales Local Currency ADs Issued ADs to be Issued v Measure Filters Amount Auth Amt Filter by Mapped Unmapped Auth Count Cube Average Rate Award Dividend Count Done KK Local intranet Protected Mode Off 4a amp 100 7 To see existing mappings click on the View Existing Mappings tab This tab is a read only view of the mappings that exist between the Dictionary Entries and the Measure Names By clicking on a mapping its information is displayed on the right Notice that we are viewing the Gross Profit Margin dictionary entry Active Cards measure mapping information on the right 2013 Tallan All rights reserved 21 Installation and User Guide Metadata Framework Data Dictionary Mapping Dictionary Measure Windows Internet Explorer Gc X http localhost MetadataFrameworkDataDictionary 3t DictionaryMeasureMap zy Favorites p u Suggested Sites Web Slice Gallery v Mapping Dictionary Measure te 2 Pager Safety Tools e gt Glossary z gt RC ata Dictionary Measure S Mapping Dictionary Measure Cw Drag items between lists to create Measure to Dictionary Entry mapping Dictionary Application Fields Create New Mapping View Existing Mappings gt we Explorer gt a Reports Dictionary Entry Measure Name Mapping Details gt Admin Gross Profit AAAA
29. w explains the associations between the tool and the BI stack User Interface Data Warehouse SQL Reporting Parser SharePoint Portal Data Dictionary Source M HE Applications Systems 2013 Tallan All rights reserved 2 Installation and User Guide Metadata Framework Data Dictionary EH INSTALLATION On Windows Server 2008R2 with IIS installed and SQL 2008R2 installed also install the following e Microsoft NET v4 Framework http www microsoft com downloads details aspx familyidz9cfb2d51 5ff4 4491 bOe5 b386f32c0992 e Silverlight 4 0 SDK http www microsoft com downloads en details aspx FamilyID2298170d6 567c 4b90 9917 490ffcddba87 amp displaylangzen e Silverlight 4 developer runtime http go microsoft com fwlink LinkID 146060 Once completed run Setup exe The installer goes through a number of steps when run UN The installer checks to see if the correct version of Windows is running by checking the WindowsBuild Operating System Value being greater than 7100 http msdn microsoft com en us library aa370556 VS 85 aspx 2 Checks to see if the Event Log contains the event source name for the application If not create it under the raised privileges during install 3 Writes to the Event Log during setup when the database is installed and when the application is installed Installs the database in the local instance of SQL Server D Installs the application No
30. xpand the filtering options We are currently showing all mapped and unmapped dictionary entries with any status approved pending and denied We are also showing all mapped and unmapped measures from all cubes To view a subset of the dictionary entries information chose the filtering options that you would like to see to filter the results For example to only see approved status mappings turn off the pending and denied options To view mapped and or unmapped measures from a single cube selected either mapped unmapped or mapped unmapped in the filter by drop down and select the cube from which to pull this information 2013 Tallan All rights reserved 20 Installation and User Guide Metadata Framework Data Dictionary ae Mapping Dictionary Measure Windows Internet Explorer Go J http localhost MetadataFrameworkDataDictionary DictionaryMeasureMap m ha X e Bing o Lp Favorites 23 u Suggested Sites Web Slice Gallery v amp Mapping Dictionary Measure T gd Page Safety Toos Dictionary Measure Dictionary Measure 2 me Drag items between lists to create Measure to Dictionary Entry mapping Dictionary Application Fields Create New Mapping View Existing Mappings gt Z Explorer Dictionary Entries Measure List Filters alj Reports Average Sale Amount AAAA v Dictionary Filters gt Admin Gross Profit Accrual Rate s 4 mv uim riter by RR Gross Profit Margin Ac

data-dictionary

Contents

Download Pdf Manuals

Related Search

Related Contents