{"id":274,"date":"2018-02-14T10:58:06","date_gmt":"2018-02-14T05:28:06","guid":{"rendered":"http:\/\/blog.tenthplanet.in\/?p=274"},"modified":"2026-03-03T10:15:34","modified_gmt":"2026-03-03T10:15:34","slug":"pentaho-metadata-editor-creates-business-model-users","status":"publish","type":"post","link":"https:\/\/tenthplanet.in\/blogs\/pentaho-metadata-editor-creates-business-model-users\/","title":{"rendered":"Pentaho+ Metadata editor creates Business Model for users"},"content":{"rendered":"<p><b>Pentaho+ Metadata Editor<\/b>\u00a0(PME) is a tool that allows you to build\u00a0<b>Pentaho+ metadata<\/b>\u00a0domains and relational data models. A\u00a0<b>Pentaho Metadata<\/b>\u00a0Model maps the physical structure of your database into a logical business model<\/p>\n<ul>\n<li>Create business-language definitions for complex or cryptic database tables<\/li>\n<li>Decrease the cost and impact associated with low-level database changes<\/li>\n<li>Set security parameters limiting user&#8217;s report access to data<\/li>\n<li>Drive formatting on text, date, and numeric data improving report maintenance<\/li>\n<li>Localize the information to the user&#8217;s regional settings<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-275\" src=\"https:\/\/tenthplanet.in\/blogs\/wp-content\/uploads\/sites\/21\/2018\/02\/blog1-1-1.png\" alt=\"\" width=\"425\" height=\"188\" srcset=\"https:\/\/tenthplanet.in\/blogs\/wp-content\/uploads\/sites\/21\/2018\/02\/blog1-1-1.png 425w, https:\/\/tenthplanet.in\/blogs\/wp-content\/uploads\/sites\/21\/2018\/02\/blog1-1-1-300x133.png 300w\" sizes=\"auto, (max-width: 425px) 100vw, 425px\" \/><\/p>\n<h3 class=\"western\">Build a Metadata model with Pentaho+ Server<\/h3>\n<p>Follow the instructions build the metadata model with Pentaho+ metadata editor<\/p>\n<h4>1. Start the Pentaho+ Metadata Editor<\/h4>\n<h4>2. Environment Setup<\/h4>\n<p>tables for which ad-hoc model need to be build<\/p>\n<p style=\"padding-left: 30px\">a. Right-click on Connections -&gt; choose New Connection<\/p>\n<p style=\"padding-left: 30px\">b. Provide required database credentials and test for the connectivity<\/p>\n<p style=\"padding-left: 30px\">c. Select tables to Import option will appear, choose the required tables for which adhoc model need to be build<\/p>\n<p style=\"padding-left: 30px\">d. Either it can be done in above step or right-click on the Datasource being created and choose Import Table option<\/p>\n<p style=\"padding-left: 30px\">e. If required change the name of the table by right-click and choose Edit option. Change the name in the String field under Name and Description<\/p>\n<p>Once all the tables are imported, now create the business model, map the relationship between the tables and choose the required attributes from each model<\/p>\n<h4>3. Business Model<\/h4>\n<p style=\"padding-left: 30px\">a. Right click on the Business Model and choose &#8216;New Business Model&#8217;<\/p>\n<p style=\"padding-left: 30px\">b. Enter the name for the business model in String field under Name and Description<\/p>\n<p style=\"padding-left: 30px\">c. Under the business model, there will be 3 options,<\/p>\n<p style=\"padding-left: 30px\"><b>Business Tables:<\/b> List of tables for which model is to be build<\/p>\n<p style=\"padding-left: 30px\"><b>Relationships:<\/b> Mapping between each table, primary and foreign key relationships<\/p>\n<p style=\"padding-left: 30px\"><b>Business View:<\/b> Choose the required attributes from each model and sequence and format it<\/p>\n<p style=\"padding-left: 30px\">d. Right click on the Business Table and choose New Business Table<\/p>\n<p style=\"padding-left: 30px\">e. Make selection dialog box appears, select required table one at a time and click OK<\/p>\n<p style=\"padding-left: 30px\">f. selected tables will appear on the Graphical View (right side of the screen)<\/p>\n<p style=\"padding-left: 30px\">g. After choosing all the tables, in the graphical view right click and select &#8216;New Relationship&#8217;<\/p>\n<p style=\"padding-left: 30px\">h. Select the Source and Destination tables and its corresponding fields, Relationship should be chosen as 0: N, click ok. Likewise do the same for all the required tables<\/p>\n<h4 style=\"padding-left: 30px\">In Business view<\/h4>\n<p style=\"padding-left: 30px\">i. Right click and choose &#8216;manage categories&#8217;, dialog box appears.<\/p>\n<p style=\"padding-left: 30px\">j. Move the required tables into Business View Categories section, use the up and down arrows for changing the sequence<\/p>\n<p style=\"padding-left: 30px\">k. Choose the necessary fields from a table and remove other fields, click close<\/p>\n<p style=\"padding-left: 30px\">l. For dimensions, make sure data type is String.<\/p>\n<p style=\"padding-left: 30px\">m. For any measure related fields, its data type, format, aggregation options can be defined in business view area<\/p>\n<p style=\"padding-left: 30px\">n. Right click on the required field to be formatted. In the &#8216;Available&#8217; section, choose Default Aggregation to select the required aggregations, then data type<\/p>\n<p style=\"padding-left: 30px\">o. For specifying the number formats like # or #,###.00 etc,. Click on the &#8216;+&#8217; symbol under &#8216;Available&#8217; and choose &#8216;Mask for Number or Date&#8217;. In its value, specify the above formats<\/p>\n<p style=\"padding-left: 30px\">p. Save the model by entering some name<\/p>\n<p style=\"padding-left: 30px\">q. This model can be exported to a XML file from File Menu -&gt; Export to XMI file, specify the name for the file<\/p>\n<p style=\"padding-left: 30px\">r. It can be imported into BI server from Manage Data Source<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Create business-language definitions for complex or cryptic database tables<\/p>\n","protected":false},"author":23,"featured_media":1133,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[424],"tags":[427,425],"class_list":["post-274","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-pentaho","tag-metadata","tag-pentaho-etl"],"acf":[],"_links":{"self":[{"href":"https:\/\/tenthplanet.in\/blogs\/wp-json\/wp\/v2\/posts\/274","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/tenthplanet.in\/blogs\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/tenthplanet.in\/blogs\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/tenthplanet.in\/blogs\/wp-json\/wp\/v2\/users\/23"}],"replies":[{"embeddable":true,"href":"https:\/\/tenthplanet.in\/blogs\/wp-json\/wp\/v2\/comments?post=274"}],"version-history":[{"count":0,"href":"https:\/\/tenthplanet.in\/blogs\/wp-json\/wp\/v2\/posts\/274\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/tenthplanet.in\/blogs\/wp-json\/wp\/v2\/media\/1133"}],"wp:attachment":[{"href":"https:\/\/tenthplanet.in\/blogs\/wp-json\/wp\/v2\/media?parent=274"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/tenthplanet.in\/blogs\/wp-json\/wp\/v2\/categories?post=274"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/tenthplanet.in\/blogs\/wp-json\/wp\/v2\/tags?post=274"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}