You must create a compound attributes when an attribute requires two or more columns to uniquely identify its elements. . location_path is the folder where the attribute is to be placed, of type string,. One of the component metrics that makes up the Compound metric is made with the Count() function and has the Metric Guide changed from "Automatic" to an attribute. In the attributes list, right-click the Commute Distance attribute and then select New Attribute Relationship. Click ( ) in the operator bar. When columns are added to the Selections pane, Query Builder automatically maps the column to an attribute or metric object, based on the column name. A percent-to-total shortcut metric displays the percent in relation to a selected total of each item affected by the metric. Count Compound Attribute is an advanced property that is hidden by default. The following procedure describes how to achieve this: Create the highest level filter. Steps to Create Smart Attributes. Open any folder page (for example, click Shared Folders on the home page). Do not set any additioThe Profit metric is a simple sum of the Profit fact. From the Source table drop-down list, select a table which contains the columns of data for the attribute. 1. Shorter data types are faster to join than longer. Do not set any additioMicrostrategy Dossiers With the release of MicroStrategy 10. Click Add, select the elements, then click OK. An in-line many-to-many relationship involves an attribute with at least one parent and one child. Open a report in MicroStrategy Developer. Attribute T contains an element t1. Here is the workaround to achieve the attribute left outer join on MicroStrategy Web. You must create a compound attributes when an attribute requires two or more columns to uniquely identify its elements. 'Customer Birthdate' is used in this example. How to Create a Composite Key? Creating a composite key involves selecting the appropriate columns in a table and defining them as a unique identifier for each record. Set the qualification type to 'Custom'. x-10. Create a filter on the attribute "Year. ". Attribute T contains a form called "email" whose values are email addresses that will be used in the dynamic subscription in Narrowcast. Workaround / Solution. This is a filter which contains a prompt on an attribute element list. Here the many-to-many relationship is converted into a compound attribute relationship. Use the Object Browser on the left to locate the prompt to add to the metric's definition. Double-click the Column Set name to rename the set. A derived attribute works the same as any other attribute. The hyperlinks based on an attribute form compound by Applysimple no longer work when exporting to MHT in MicroStrategy 9. An empty filter appears in the dossier. The formula of a compound metric is based on arithmetic operators and non-group functions. Let's add the custom visualization to the Gallery. Writing the WHERE block should be no problem, as you can generate it in MS Excel based on the two columns… something like =CONCATENATE(“OR (a11. Save the report as “Email Bursting”. Drag an attribute from the object browser into the text box next to the qualification type or enter the attribute name and its form according to the following format: attribute_name@form_name. Click "Prepare data" to enter Data Preview page. A compound attribute is an attribute with multiple columns specified as the ID column. You can use the Custom Visualization API to create tooltip functionality using third-party plotting libraries like D3. The New Grid dialog box opens. The steps below use objects from the MicroStrategy Tutorial project as an example. Insert a derived metric 'M01' with expression 'Max(Region@DESC) {~+} '. Add 'AliasMonth' to the report template as shown in the image below: Create a. Press and hold the Ctrl key to select multiple attributes or metrics. Since by changing the ID form of the attribute (compound to single key), the attribute has become a new attribute, personalizations based on that attribute may no longer continue to work and should be recreated. The Group Editor opens. Select the attributes and facts from that table. Using the MicroStrategy Project Tutorial, create a report with the attributes Category, Subcategory and the metric Revenue. Select "DESC" from the 'Qualify On' drop down options and change the operator to "Contains", as shown below:In MicroStrategy Developer, to create a list of the individual fact entries for an attribute in a scenario where the attribute has a fact table as its lookup table Very Large Database (VLDB) 'Distinct/Group By option (when no aggregation and not table key)', users can create an attribute 'Year' that uses the YR_CATEGORY_SLS fact table in. Create and Edit a Visualization-Based Filter. 4. This implies that more than one ID column is needed to uniquely identify the elements of that attribute. The following auto text codes allow you to add document variable information to your document. more columns. The primary key should be compact (avoid the use of long data types). However, before changing the way MicroStrategy products look or behave, it is helpful to understand how the application is built. Add the “Component Object” attribute to the filter panel and filter on the metric that is of interest. 0 if there are multiple join paths between two or more One-to-Many relationship tables in a multi-table data import cube, rather than using the first available table join path, the analytical engine will look for the path with the least number of tables and the smallest table base on the following order/criteria:If it is desired to have SQL generated that specifies a distribution key on all columns that are used in the intermediate table (and not just attribute ID columns), the same combination of VLDB settings may be used as above, except for replacing the wildcard !a by !!! as below: Create Post String = DISTRIBUTE ON (!!!)This issue is being investigated by the MicroStrategy Technology team. When exporting a report containing an image attribute form (using an ApplySimple statement) to PDF in MicroStrategy Web 9. Surrogate Key. Execute the report and notice the report only shows the subtotal of the attribute Region, as illustrated below:In SQL View look at where the cross join appears, and between which tables the cross join appears. Turn off the Platform Analytics Consumer. Note that only the naming convention has changed, as the functionality remains the same. The algorithm that calculates the table sizes performs the following steps: Calculate the number of levels per hierarchy: Hierarchy 1: 3. KB42704: When adding an attribute to a hierarchy, the attribute is not showing up in the MicroStrategy Developer 9. This type of passthrough can be used to create flexible filters. Consider the sales figures of your company. Shorter data types are faster to join than longer. Metric Guide; Compound Metric; Steps to Reproduce. In MicroStrategy Web, on the Home page, click New Prompt. I'm working on a dossier and I have a dataset that includes customer types. A dialog used to create and edit MicroStrategy Objects. Create a compound metric based on the previous two metrics, "Revenue" (Call Center Level) and "Revenue_by_Region" (Region Level). 0. Do not set any additio In the relational database, a compound key is a primary key that consists of more than one database column. 1) create a metric of your date value and force it to be at the=. Create a filter on the attribute "Year. SUBCAT_ID. Use the same steps as specified in the help menu: Open attribute editor (right-click on attribute and select 'Edit') Select the forms that will make up the compound key. Report will display result as below. Steps to Reproduce. Create a filter on the attribute "Year. Use the Ctrl key to select multiple attributes and metrics. Select the Source Table that contains the desired attribute ID, and drag the attribute ID into the Form Expression window. There are no restrictions on the names for the columns used in the expressions of a given attribute form. English Deutsch Français Español Português Italiano Român Nederlands Latina Dansk Svenska Norsk Magyar Bahasa Indonesia Türkçe Suomi Latvian Lithuanian česk. Visit the data visualization and data dashboard galleries for inspiration. desc is the description of the attribute, of type string, between double quotes ("). To create a list of attribute elements from which users can choose, select Use a predefined list of elements. Follow the steps below. The attribute level follows a consecutive order from. Click 'Browsing Options' and check the 'Display hidden objects' checkbox and click OK twice. In MicroStrategy Developer 9. The 'Set as key' option is used for defining the lookup table primary key for the attributes when generating SQL with MicroStrategy Engine. Ans: In Microstrategy, facts are the numeric data and attributes are contextual data for the facts which. A compound key attribute is an attribute that has two or more IDs. Launch the Prompt Generation Wizard in MicroStrategy Developer by going to File menu > New and choosing 'Prompt'. 5. zip, select it, and click . Candidate Key – is a set of attributes that uniquely. Select the attribute form to filter report data from the drop-down list. " Click "prompt on attribute element list" and click "Next" through the rest of the screens to accept the default values. The derived attribute can be developed based on an object. Want to learn more?There may be instances when it is necessary to include an attribute form in a derived or a compound metric in order to carry out calculations based on the form. Choose File > New Attribute. Find centralized, trusted content and collaborate around the technologies you use most. The following steps describes how to create such derived metric. In MicroStrategy Agent, go to Schema Objects > Attributes. This is often confused with a composite key whereby even though this is also a key that consists of 2 or more attributes that. 2. Right-click the group and choose Set as key. Use the Ctrl key to select multiple attributes and metrics. How to convert a . Create a new consolidation with three elements - Winter, Spring and Winter + Spring, as illustrated below: Create a report with the above created consolidation and three metrics - 'Revenue',. Select an operator, such as Equals or Less Than, from the next drop-down. (in my example: table_id, start_date) 2) create a 2nd metric for your date value at your desired=. In-line M-M Relationships: Explanation. xa) Attribute form qualification Filters data related to a business attribute’s form(s), such as ID or description. For information on compound attributes, see Attributes with multiple ID columns: Compound attributes. " Click "prompt on attribute element list" and click "Next" through the rest of the screens to accept the default values. Press and hold the Ctrl key to select multiple columns. Double-click the security role you want to assign to the user or group. Drag from the middle of the attribute to an. x. During our 10+ years of work with MicroStrategy we often encountered overlapping cube and cache questions and what are the best practices in order to manage them. You cannot change the join types of. The derived attribute can be a string, number, or date. Once you create. Click Save and Update Schema. Composite Key: A composite key is made by the combination of two or more columns in a table that can be used to uniquely identify each row in the table when the columns are combined uniqueness of a row is guaranteed, but when it is taken individually it does not guarantee uniqueness, or it can also be understood as a primary key made by. New user and application. The Attribute element prompt is the most restrictive, allowing users to choose from the fewest number of attribute elements to define their filter criteria. We use MicroStrategy Tutorial tables that have the Month Id attribute and. To create a visualization filter. You then create a new metric based on the new fact and attempt to use it in a report, together with the compound key attribute. You can also create new attributes, based on existing attributes in your dataset, while viewing a dossier. The following steps can be used to concatenate two attribute forms. Composite Key. Create a metric that is defined as Max(Promotion Type @ DESC). " Click "prompt on attribute element list" and click "Next" through the rest of the screens to accept the default values. The MicroStrategy SDK allows you to customize the standard MicroStrategy Web interface, and extend and integrate the MicroStrategy business intelligence functionality into other applications. To Create an Attribute-To-Attribute Qualification that Compares the Call Center and Customer City Attributes In MicroStrategy Web, log in to a project. Typically, dimensional hierarchies are presented as independent of time, e. for that attribute ( say a dimension table). The metric can also show a total by page, show a total for each value of the attribute, or show the grand. To allow the user to choose attributes from a list of attributes that you specify, select . Open the dossier you want to modify. Drag the prompt onto the Definition pane at the bottom right, as shown in the image below:For example, the attributes Year, Quarter, Month of Year, Month, and Day in the MicroStrategy Tutorial project are gathered close together in the Hierarchy View, as shown below. Type RunningAvg in the Definition pane. Architect allows you to create and modify attributes in most of the same ways as the Attribute Editor. Use "Access External Data" feature in MicroStrategy Web 10 to import data. You then create a new metric based on the new fact and attempt to use it in a report, together with the compound key attribute. Create a compound ID attribute based on multiple data sets. Apply Filter Changes. 78K. The types of keys that can be assigned to a table include: •. Select the Relationships tab. If the user defines more than one expression for a given form, heterogeneous mapping will automatically take place when tables and column names require it. Create three reports named A (with attribute A), A&B (with attribute A and B),A&C (with attribute A and C) Create a dashboard based on the three reports created in last step. This is a filter which contains a prompt on an attribute element list. An input box will be displayed with a list of recommended questions based. Select the attribute to be masked. In the visualization, select the attribute elements to use in the group. Do not set any additioHow to include an attribute form in a compound or derived metric in MicroStrategy Developer 9. Save the new metric as "Sum of Compound Metric". KB17619: How to create a conditional attribute in MicroStrategy Desktop 8. For information on training metrics and creating predictive. It can be set at the project and. To create an Attribute Qualification prompt. In the Create New Form Expression window in the Attribute Editor, select the. 10?; Knowledge Base: How can I filter a visualization on a dossier that users can’t view or manipulate?;. In the Datasets panel, click More next to the dataset to add the attribute to and choose Create Attribute. To Create a Combination Graph. In this case, only one form exists for each, as shown below:Natural Language Query (NLQ) allows end users to build dossiers and get insights just by typing questions. 4. This article notes a limitation of mapping MDX attributes to schema mapped attributes Let’s say you need to create a new table that should contain the compound key attribute and a new fact. Follow the steps below to reproduce it: Create report with consolidation Create project models from MicroStrategy Developer Create ad-hoc models from MicroStrategy Web; Workflow. Simultaneously creating multiple attributes. In a relational database, each row in a table must have a unique identifier, which is used for indexing and searching the table efficiently. Create and Edit a Visualization-Based Filter. Save the. x?. This condition may be implemented through an ApplySimple statement such as the following: The user will find that the CASE statement. This visualization allows you to create a grid that analyzes different aspects of data across a common dimensions or attributes in rows. 3. For instance, the attribute City may be defined in the data model as a combination of COUNTRY_ID and. Workaround Since the Offsets are handled by the MicroStrategy Services Broker, you should reset the Broker List ID to make all newly submitted transactions unique from the transactions existing in the ecosystem. Click Add New Form. 1 and… Number of Views 618 KB14936: When drilling across to a hierarchy in. Compound key requires multiple columns to identify a unique record. In Microstrategy Developer, create a new attribute by navigating to File > New > Attribute. Select 'Region' and click OK. 16K KB41943: How to create a metric that calculates the distinct count of an attribute. From the Insert menu, select New Metric. " Click "prompt on attribute element list" and click "Next" through the rest of the screens to accept the default values. For information on training metrics and creating predictive. Add an attribute and a metric to both Column Set 1 and Column Set 2. J2EE environment:To create a derived metric. ACTION: Ensure that there is another attribute that has a common column in their lookup table with the attribute you are working with. To create an attribute filter Open the dossier you want to modify. In general, ApplySimple can be used to create the following objects: Attribute form. 1. The table now appears in bold as shown below. This attribute join type is the default setting. This compound metric will be a "Percent to Regional Total" and created as follows:The algorithm that calculates the table sizes performs the following steps: Calculate the number of levels per hierarchy: Hierarchy 1: 3. Compound Metrics. Create three reports named A (with attribute A), A&B (with attribute A and B),A&C (with attribute A and C) Create a dashboard based on the three reports created in last step. For example, a transformation metric can help a user compare last month's revenue to this month's revenue. 1 and 10. In MicroStrategy Developer, open Architect. An Attribute Qualification prompt can be used in an Attribute form qualification. It can be set at the project and. From the Object browser, select an attribute and drag it on the filter pane on the right. Do not set any additioWhy MicroStrategy Why MicroStrategy; Customer Stories; PlatformThe ApplySimple function is a single-value function. Slowly changing dimensions (SCDs) are a common characteristic in many business intelligence environments. This is a filter which contains a prompt on an attribute element list. Interact with the engaged MicroStrategy Community to get answers to all your questions and collaborate for solutions. when you define attributes you set a lookup table. In Visual Insight in MicroStrategy Web 9. Hierarchy 2: 4. On the toolbar, click the drop-down arrow on the Create a New Object icon, and select the type of object to create. Defining the partition for Super Cubes. This visualization allows you to create a grid that analyzes different aspects of data across a common dimensions or attributes in rows. Consider the following scenerio: A user wants to create a metric which ranks the Regions according to Revenue at a company-wide level. Create a report that makes use of the metric. Then, click 'OK'. Drag an attribute or metric from the Datasets panel to the Columns Set area in the Editor Panel. Use the same. Might need to play with formatting to make sure. Drag the attributes or metrics for filtering from the Datasets panel to the empty filter. During your initial project design effort or later in a project's life cycle, you can create multiple attributes using the Attribute Creation Wizard. In the Create New Form Expression window in the Attribute Editor, select the above table as the source table and use the following ApplySimple statement to define the expression: Applysimple( "#0 '-' #1 '-' #2", ID, Quarter, Year)Here the many-to-many relationship is converted into a compound attribute relationship. This attribute join type is the default setting. Watch free 3-5 minutes tutorial videos, with subtitles available in 9 languages, to build product fluency! Start learning. After migrating to MicroStrategy 9. This is a filter which contains a prompt on an attribute element list. Can you update a table in Warehouse using MicroStrategy? How will you resolve an issue when (by chance) an aggregate table at higher level has a higher LTS than an aggregate table at lower level?. Turn off the Platform Analytics Consumer. To uniquely identify a distribution center, one must know two details about the distribution center: the ID. Click Qualify. The MicroStrategy SDK allows you to customize the standard MicroStrategy Web interface, and extend and integrate the MicroStrategy business intelligence functionality into other applications. The primary key is made up of the lowest level attributes. Select the function to use to calculate data in the metric. insufficient. Create a report with Attribute "Year", custom group "Category" and Metric Revenue; Click in the Metric Revenue in Report Object and go to Insert Tab; Percent to Total; Total for each;A derived attribute has its value determined by an expression which combines two or more columns in a database to create a new column. Create a new metric based on the OLAP function RunningCount: 3. Derived Attributes A derived attribute has its value determined by an expression which combines two or more columns in a database to create a new column. In general, ApplySimple can be used to create the following objects: •. Which key structure you use to identify a unique attribute in a table depends on the nature of your data and business requirements. 4. An attribute on a dossier serves as a label for a group of metrics. The following procedure describes how to achieve this: Create the highest level filter. If the user defines more than one expression for a given form, heterogeneous mapping will automatically take place when tables and column names require it. The three dialog boxes are New Attribute, Create New Attribute Form, and Create New Attribute Form Expression. Create a new dossier or open an existing one. Which key structure you use to identify a unique attribute in a table depends on the nature of your data and business requirements. Create three reports named A (with attribute A), A&B (with attribute A and B),A&C (with attribute A and C) Create a dashboard based on the three reports created in last step. Click OK. However, before changing the way MicroStrategy products look or behave, it is helpful to understand how the application is built. Select 'Yes or 'No' from the drop down list. Ans: A Compound key attribute is a primary key that is made up of two or more columns and these columns are joined with other attributes. RMC on Revenue and choose Insert -> Percent to Total -> Grand Total to create the Contribution (%) metric;Passing prompt answers for an element prompt when the attribute has a compound ID. NOTE: If the above drop down list is disabled, the metric is not a compound metric and so smart totaling does not apply. " Click. For any Apply function, the attribute form in the arguments should be a single form—not a form. Also, you add both attribute IDs, in this case Item_ID and Color_ID, to the fact table as shown in the following diagram. For detailed information on attribute roles, refer to Attributes that use the same lookup table: Attribute roles. They are therefore all logical keys for that table. Create and schedule incremental reports when the cube can be partially. Simple key requires only one column to identify a record uniquely within a table. x, if there are any compound metrics included in the interface, users may click on the word Metrics, and that will break down all compound metrics into its constituent simple metrics. What is Compound Key Attribute? Give example from your project. Place the 'max month' metric created in step 4 in the Report objects window. Ans: In Microstrategy, facts are the numeric data and attributes are contextual data for the facts which. x-10. To achieve this, the users can make use of an Apply Simple statement through a new attribute form in the attribute form expression editor. Note: The two IDs must come from multiple source tables, and one of them should have the format type of Text. You must create a compound attributes when an attribute requires two or more columns to uniquely identify its elements. 1. An example showing a control key value of F59 is shown below: Follow the URL syntax in KB38841 to create the hyperlink for passing selections. 4. After loading, MicroStrategy will present a window like this. For example, for the Customer attribute, Customer Email, Customer First Name, and Customer Last Name are examples of attribute forms. Now to fix this create a new Derived metric on Category attribute first with formula as Max (Category) {~ } and calling Books. Click an object to add it to the definition. In-line M-M Relationships: Explanation. This level of control can ensure consistent Engine behavior. To show data valuable for any analysis, the map visualization requires at least one Attribute (including Geo Attribute) and at least one Metric. Double-click the Column Set name to rename the set. Click on the 'Subtotals' tab. This implies that more than one ID column is needed to uniquely identify the elements of. Ensure that the project schema for your new attribute is available for editing. This design may look strange, but in most cases there are. When exporting a report containing an image attribute form (using an ApplySimple statement) to PDF in MicroStrategy Web 9. You treat one attribute as a child of the other and have a compound key for the lower level attribute. In the Object Browser, locate and double-click the metric Cost. A joint child is Microstrategy way of handling Composite Keys. Attributes can have multiple attribute forms. Right-click the table, point to Recognize, and then select Attributes. In the Attribute Editor, create a new form expression. Rather than creating attributes by manually creating an attribute expression, you can allow Architect to automatically create simple attributes defined on one column. 1. Drag the attributes and metrics for filtering from the Datasets panel to the empty filter. Metric A has corresponding value for element t1 while B does not. Therefore, if a metric is specified to calculate to an explicit attribute level and the attribute is not on the report template or in the Report Objects window, it will not calculate to that level, but. The ApplySimple function is a single-value function. Compound keys add complexity to SQL. It causes the SQL Engine to calculate for only the attribute elements that exist in both the lookup and fact tables. This can be done during the database design process or by altering an existing table. Writing the WHERE block should be no problem, as you can generate it in MS Excel based on the two columns… something like =CONCATENATE (“OR (a11. Metrics are quantitative measures used to analyze the data in the particular context. Go to Smart Attribute blade on the Attributes Editor. The Attribute Creation Wizard opens, as shown below. 0. Compound Key Attribute A compound key attribute is an attribute whose primary key is made up by the combination of two or more columns. (The use of brackets around compound object names is standard for many objects in MicroStrategy and is not restricted to custom expressions and Apply. Make B and C parents of a new compound attribute using both columns as its ID with A B and C as its parents. Attributes are the business concepts reflected in your data. Create the highest level filter. When you create a form expression using a custom expression or multiple columns (as discussed in Attribute form expressions), the column alias for the attribute. This article explains how to create a metric which counts only a single key of a compound key attribute n this brief video tutorial, Stephen Goodson, a senior instructor from our Customer Education team explains what compound attributes are and demonstrates how. The following procedure describes how to achieve this: Create the highest level filter. The multiple columns are joined with other attributes, typically in a many-to-many relationship. Related articles from the Community: Knowledge Base: Is it possible to pass filter panel values from one chapter to another using Microstrategy Dossier version 10. In the Create Attribute Relationship dialog box, the Source Attribute is Commute Distance. Create Custom Tooltips. Each table must have an ID form. Logical Views allows application architects to create any desired view using MicroStrategy, without DBA involvement. the attribute definition window. Open the registry key at HKEY_LOCAL_MACHINE]\SOFTWARE\MicroStrategy\DSS Server\Castor. Create a filter on the attribute "Year. The primary key should be compact (avoid the use of long data types). In MicroStrategy, users can create compound metrics belonging to MDX Cubes imported from multidimensional data sources such as SAP BW, Microsoft Analysis Services, or Hyperion Essbase. 6. For more information regarding the MicroStrategy products or the process of customizing MicroStrategy products, please refer to MicroStrategy Developer Zone (to Create Smart Attributes. For information on defining the primary key for tables included in a MicroStrategy project, see Defining the primary key for a table. In Name, enter a descriptive name for the attribute. Choose one of the following: Save the metric. Beginning in MicroStrategy 11. Each custom format can have up to four. KB20000: How to create dynamic dates using MicroStrategy Developer 9. This is because the key attribute should always be unique in the warehouse table or it should not be used as the key for the table. The following procedure describes how to achieve this: Create the highest level filter. This tutorial shows how to create derived attributes and metrics in a dossier. STEPS TO REPRODUCE: 1 - In the MicroStrategy Tutorial project create a new attribute form in the Category attribute with the following expression: Multiple elements are highlighted when using an attribute with compound key as a selector in Visual Insight and MicroStrategy Web 9. To access the Date Editor to create dynamic dates, execute the following steps: In the Filter Editor, choose to add an attribute qualification. A compound attribute is an attribute with multiple columns specified as the ID column. Create another dynamic date filter 'OBJ2 - Last Month' Create a Metric 'OBJ3 - Max Day No Filter' that returns the day value in a metric for a given day. For information on how to display this property, see Viewing and Changing Advanced VLDB Properties. Select the chapter that contains the visualization to filter. A compound key is a primary key made up of two or more attributes (fields) that uniquely identify a row in a table. There are several ways to create and apply filters to individual chapters, multiple chapters, or across an entire dossier. Create a new consolidation with three elements - Winter, Spring and Winter + Spring, as illustrated below: Create a report with the above created consolidation and three metrics - 'Revenue',. The object's editor or wizard opens. Drag the attributes and metrics for filtering from the Datasets panel to the empty filter. Do not set any additioA list of security roles in the project source opens in the main Developer pane. To create an attribute filter Open the dossier you want to modify. Select the data set and click Prepare Data. Add 'AliasMonth' to the report template as shown in the image below: Create a. " Click "prompt on attribute element list" and click "Next" through the rest of the screens to accept the default values. Simple key requires only one column to identify a record uniquely within a table. The derived metric's value is 12. Even though all the ID forms of a compound key attribute do not exist on the fact table, that attribute is seen in the fact entry level of that fact table. Continue with the previous Steps 2 and 3 above. Create 2 datasets. The report should looks like: 2. The key attributes are determined solely by attribute mappings to the table and attribute relationships, where the logical table keys. The attribute level follows a consecutive order from. Workaround / Solution. To create attributes with the Attribute Creation Wizard, follow the steps outlined in Simultaneously creating multiple attributes.