g. Accept the other default values. KB16057: How to create customized metric expressions for MDX Cube data sources in MicroStrategy Engine. But, DESC has repeating values. UnderstandingFunctionsinMicroStrategy 5 TheBasicsofMicroStrategyObjects,ObjectDefinitions,andFunctions 6 FunctionSyntaxandFormulaComponents 9 You have 2 options. 1 and 10. The schema looks like the following diagram. MSTR has evolved. 21K. Choose attribute Call Center and use the Region Filter created in the previous step. Step 2) Create a metric using the following syntax, Sum(ApplySimple("#0", <Attribute Name>, 1)){~}. Microstrategy Dossiers With the release of MicroStrategy 10. How to set the maximum date from a warehouse table to be the maximum answer displayed when executing a prompted report in MicroStrategy. For more details on how to use ApplySimple() statements, refer to the following MicroStrategy Knowledge Base technical note:When exporting a report containing an image attribute form (using an ApplySimple statement) to PDF in MicroStrategy Web 9. The ApplySimple function is used with simple operators and functions. This section describes the date and time functions. 1 and 10. Create 2 derived attributes DA2 and DA3, both using DA1 as a child component. Whatever the final sql is (1) take the final sql, (2) Wrap. x, with the Intelligence Server running on Linux, the image in the exported PDF report appears as a. Field Name is called 'Group' There are certain 'Group' names that I want to put in a certain category using the CASE. Applysimple in Metric; Conditional metric and report filter interactions; Connection Mappings in Microstrategy;. The following example will walk through how to setup an attribute form that converts a default datetime value in Microsoft SQL Server 2000 into a NULL value. Click on 'Finish' and save the prompt. Follow the steps below to create a list of all groups and the users in each group: In MicroStrategy Developer 9. MyDate =. Split Hierarchy with M-M relationships: Explanation. Dynamic date qualifications are not supported against MDX cube data sources, but the same results can be achieved by using custom MDX expressions. Visit the data visualization and data dashboard galleries for inspiration. Applysimple in Metric; Conditional metric and report filter interactions; Connection Mappings in Microstrategy;. Examples of this category are simple mathematical. How to create a MicroStrategy connection file (. Trending Articles. png"). Fu nction Types. Concat is often used to combine related values, such as a first and last name. In MicroStrategy Developer, create a dummy metric with the following definition. When exporting a report containing an image attribute form (using an ApplySimple statement) to PDF in MicroStrategy Web 9. 1 and 10. , >, =, Like, In, etc) can be used. Depending on your MicroStrategy product and licensing, this function may not be available. ApplySimple. 1 and 10. Recommendation. This function evaluates multiple expressions until a condition is determined to be true, then returns a corresponding value. Trending Articles. x. 2 Can anyone tell me how to create a Filter using Applysimple in Microstrategy 7. Now, if I create an attribute on the DESC itself, I do get a unique list of values to be shown in the prompt , but, the report results get messed up. Select only Configuration Objects for documentation. KB35312: Attribute sorting does not get applied correctly on a selector when viewing a Report Services Document in DHTML mode in MicroStrategy Web 9. microstrategy. 4. Use of M03 in Microsoft SQL Server 2000 would result in DATEADD (DD, (1 - DAY (GetDate ())), GetDate ()). I hope this helps. x, with the Intelligence Server running on Linux, the. A user may want to create an attribute with an alternating expression depending on a certain condition, a conditional attribute. Create a numeric value prompt and name it P1. You might have to "trick" it by embedding applysimple inside your case statement to make it accept your "Y" and "N". An example of this behavior is as follows:Try using some of the date functions that are now available in 8. If you are looking to learn. x. Sum . The prompt may be used in the ApplySimple function, and will be substituted at runtime. x mixed case columns names for a DB2 database by default have SQL generated with quote characters enclosing the name . How to embed horizontal bar graphs into a column of a grid in Report Service Document in MicroStrategy Developer 9. This is a group-value function. December 07, 2018. The month names do not originally reside in the warehouse tables and the user does not want to manually input the values into the warehouse. Subscribed reports or documents for each. KB9585: How to create a Year to Day expression using an Applysimple function in MicroStrategy Developer How to create a Year to Day expression using an Applysimple function in MicroStrategy Developer In certain circumstances it is desirable for business purposes to compare data for one year ago on a day of the week basis (i. The recommended VLDB optimizations for Hive 0. MSTR has evolved dashboards to the point that they. . From the Database connection type drop-down, choose Snowflake. Unfortunately this is a "decode within a decode" and isn't. MyDate,sysdate,#0,#1)",Fact1,Fact2) OR. Then I ask how to compared two metric based on ApplySimple in Report limit. By design, however, MicroStrategy SQL Generation Engine 8. This true in any case where an explicit datatype is required. The syntax used in ApplySimple is incorrect for SQL Server 2012 database. Consult the following MicroStrategy Knowledgebase document for more information on Case() and CaseV(). Applysimple in Metric; Conditional metric and report filter interactions; Connection Mappings in Microstrategy;. Follow the next steps to create this type of metric. Users may need to list all objects (e. x using an Oracl… Number of Views 6. e. Microstrategy Dossiers With the release of MicroStrategy 10. Apply the filter Year=2002 to your report. Case ( (Category@ID = 1), Revenue, 0) Booksand Name it as Revenue for where 2 is Category ID for "Books" Report will display result. to MicroStrategy Experts. How to define an attribute form as an HTML tag in MicroStrategy Developer 9. The current logic I've found is below. The three dialog boxes are New Attribute, Create New Attribute Form, and Create New Attribute Form Expression. 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) From the MicroStrategy Developer File menu, point to New > Attribute. Example 1 Using an attribute ApplySimple is a function that allows users to send direct input to the warehouse without any assumption or special handling of what is inside the custom SQL by MicroStrategy. x-10. It is suggested to use quotes to get exact phrase when there is a space between. MicroStrategy recommends to have only one child at the lowest level. x and higher. Users need to change the expression accordingly based on the. Steps to create such a prompt in MicroStrategy Tutorial is given as follows. Pass-through expressions, also called Apply functions, provide access to special functions or syntactic constructs that are not standard in MicroStrategy, but can be obtained. Use ApplySimple in the form expression and change the date format to yyyy-mm-dd. If instead a “. For this example, assume we have a order_fact table has two dates, order_date and ship_date and an. 4. Phoenixier. The steps below give a detailed explanation on how to create a report that contains a metric based on another metric that will return a static string of data from the warehouse. 4. For basic information and examples of the ApplySimple function, see the Functions Reference. Microstrategy Dossiers With the release of MicroStrategy 10. 7x are listed below. In SQL Server, it would be as follows: Applysimple ("#0 + char (13) + #1 + char (13) + #2 + char (13) + #3" STREET, CITY, STATE, ZIP) where (13) is the ascii code for. This custom SQL can be used in the. using Sum (PaidAmt * Attribute Sales Year) works fine, valid expression, but not really what I want. KB419483: How to create a comparison operator prompt and use it in an applysimple function in MicroStrategy Developer Number of Views 1. 4. With a few additional applysimple statements this can also be used to create QTD and MTD. [MSTR User]. Reports that contain B or C will ignore filters on the other. For more information on creating an applysimple, refer to MicroStrategy Knowledge Base document, KB5700-007-0113 - How to implement attribute form expression using Apply Functions in MicroStrategy Desktop. Date and Time functions provide date and time information, such as current date, the day of week of a particular date, and so on. ", Arg1, Arg2). 0 workflow with Okta can be seen here. KB439226: How to create a filtered metric using a case statement in Visual Insight in MicroStrategy Web 10. {Select a Month} and ApplySimple("DateAdd('m',-11,#0)",{Select a Month})) Relate by System Default. ApplySimple ("case when #0 contains 'As Is' then 'As Is' when contains 'New' then 'New' ELSE 'Other' END", [NAME]) case. 4. 1 and 10. ApplyComparison The ApplyAgg function is used to define simple metrics or facts by using database-specific, group-value functions. When exporting a report containing an image attribute form (using an ApplySimple statement) to PDF in MicroStrategy Web 9. 4. Use the datetime format defined on warehouse database side in the ApplySimple statement. 00" format. Personally, I would use ApplySimple and let the database handle the work. Click OK in all three dialogs (Login, Connection, and Database Instance). Loading × Sorry to interruptKB42225: How to create a distinct count subtotal from base report in MicroStrategy Web Number of Views 6. MicroStrategy parser doesnt recognize NULL as a key word for null value. The Attribute Editor opens three dialog boxes, if the cascading dialog box option is enabled in the Developer Preference (as it is by default). KB4275: How to retrieve attribute form expressions using MicroStrategy Intelligence Server SDK. If your database does not include SQL syntax support for a date and time function, the function cannot be. Applysimple in Metric; Conditional metric and report filter interactions; Connection Mappings in Microstrategy;. The CASE function permits multiple comparisons. 3K. 1. that is used to table that contains column MyDate and force. You can use the ApplyComparison function to define custom filters. Depending on your MicroStrategy product and licensing. x does not have the inherent functionality to truncate numbers like this, it is possible to do it using the 'ApplySimple' function. Create a Report Services Document 2. When exporting a report containing an image attribute form (using an ApplySimple statement) to PDF in MicroStrategy Web 9. Save the prompt as "Call Center Prompt". The month names do not originally reside in the warehouse tables and the user does not want to manually input the values into the warehouse. x, with the Intelligence Server running on Linux, the image in the exported PDF report appears as a red "X" as shown below: However, the images in the report display properly when the report is. 1 and 10. A space where we get together to see curiosities, share experiences and pass tips to be the coolest and most knowledgeable consultants. x, open the Attribute Editor for the desired attribute and create a new form with the following syntax in the Form Expression section: ApplySimple ("#0 ',' #1", ,) NOTE: The ' ' in the above syntax is the Oracle. x and are instead displayed at the bottom of the page as shown in the image below:In MicroStrategy relational OLAP (ROLAP) reports, this would be done using dynamic date filters. Data files can be published as either an In-Memory Cube or a Live Connect Cube. Applysimple in Metric; Conditional metric and report filter interactions; Connection Mappings in Microstrategy;. The prompt may be used in the ApplySimple function, and will be substituted at runtime. The current year can be returned by putting: Year (CurrentDate ()) for your comparison. ApplySimple: ApplySimple is a function that allows users to send direct input to the warehouse without any assumption or special handling of what is inside the custom SQL by MicroStrategy. I just verified taking the SQL generated by MSTR back into SQL+ -- the SQL+ results work as they should; however, the report results are different. EXAMPLES: Using the Populate method: Set objMDFilter = mobjObjSource. Create a Fact using two expressions with ApplySimple() definitions as follows:KB14356: When exporting a report containing an image attribute form (using an ApplySimple statement) to PDF in MicroStrate… Number of Views 1. x, with the Intelligence Server running on Linux, the image in the exported PDF report appears as a red "X" as shown below: However, the images in the report display properly when the report is. Within a project, a security filter may be specified for any user. x pass-through function, in this case the ApplySimple function. Right-click on an existing environment and choose Properties. 3 – Enter the desired. Phoenixier. This is a single-value function. , Tuesday should. ApplySimple("CASE WHEN #0=1 THEN #1 ELSE NULL END", , ). Number of Views 2. 0. Microstrategy Dossiers With the release of MicroStrategy 10. ApplySimple("CASE WHEN #0=1 THEN #1 ELSE NULL END", , ). . The steps to use the JDBC driver to connect to Oracle are as follows: Download the Oracle JDBC thin driver. Download the following driver to the server hosting your Intelligence Server: TGZ for Linux. The goal is to create an image link that is used to export the grid, like shown below: Document in Edit Mode Follow the steps below: 1. Fu. In MicroStrategy, there are two settings that users can access to control Outer Join behavior : Formula Join Type and Metric Join Type . Complex functions that use combinations of metrics, attribute forms and facts as arguments must use an ApplyAgg. In a MicroStrategy environment with IBM DB2 as the Warehouse Database, a date attribute is created and defined using an ApplySimple statement containing the function 'CHAR' having 'LOCAL' as argument (which is a DB2 native syntaxWe use MicroStrategy Tutorial objects in the following steps. To provide a reasonable level of generality, the feature is based on a 'pattern and arguments'. To create an attribute form that allows the attribute to display a name in the format of 'Last_Name, First_Name' in MicroStrategy 10. In a cube containing data from the MicroStrategy Tutorial project, the following metric ranks over the lowest level attribute in the Product hierarchy used on the report. . g. if both conditions are met, then Red, else Green. Step 3) Create a report using the 'Region' attribute and the metric created in Step 2. Syntax. 4. In SQL Server, the CAST () function is used to convert data into a different data type and the ApplySimple () function in MicroStrategy can be used to incorporate the CAST () function. The following example is created within the MicroStrategy Tutorial project, specifically using the ORDER_DETAIL and ORDER_FACT tables. 2 – In the Form Expression window, select a Source table, in this case I am using the calendar dimension (LU_DAY) as the Source table. MSTr allows to dynamically specify the File Location and Backup File Location in a file device using macros. An example of such a need occurs when a modification had been made to the Relational Database Management System (RDBMS) so that the ApplySimple syntax should be changed to reflect the new. In threshold, use the condition as "Region_Test where DESC Exactly EMPTY", then threshold will be applied to those elements whose DESC is a space. You can use them in many different capacities, which include, creating or modifying both schema and user objects. The MicroStrategy Analytical Engine does not calculate date and time functions. How to write Pass-through filters using ApplySimple, ApplyAgg and ApplyComparison functions. Create a FreeForm SQL Report and add this nested prompt into it. 2. Relate tables store information about the relationship between two attributes when one a parent of the other or vice-versa. Depending on your MicroStrategy product and licensing. Details: MicroStrategy supports both Azure AD and Okta Authentication with Snowflake. ApplyComparison: where comparison operators (e. com) In the popup that opens, select ODBC. Comparison operator prompts can be used in ApplySimple functions with Case statements using the metric, (@nameofprompt(M1, M2)). Number of Views 2. From MicroStrategy 9. Database administrators can store HTML tag elements directly in the data warehouse, but MicroStrategy also has the ability to add HTML tagging to non HTML elements by using the ApplySimple database function. However, the ApplySimple statement is running a database-specific function(s), and with this example, changing the data type from Datetime to Char. This article describes a behavior observed when adding a new attribute form expression with Workstation, if the ApplySimple function is used. I want to create a new Metric, using MicroStrategy Metric Editor, to check two conditions: 1 is progress_days > complete_date 2 is Status column is = In Progress. Thus directly using NULL in formula will fail. arithmetic operators) are used. Instead, they are intended to enhance the MicroStrategy product by taking advantage of what the RDBMS platforms can offer. x, with the Intelligence Server running on Linux, the image in the exported PDF report appears as a red "X" as shown below: However, the images in the report display properly when the report is. Watch free 3-5 minutes tutorial videos, with subtitles available in 9 languages, to build product fluency! Start learning. Create a Fact using two expressions with ApplySimple() definitions as follows:KB14356: When exporting a report containing an image attribute form (using an ApplySimple statement) to PDF in MicroStrate… Number of Views 1. 다음의 예시 화면은 MicroStrategy Tutorial 프로젝트 안에서, 단순히 ORDER_DETAIL 과 ORDER_FACT 테이블을 사용해서 만들어졌습니다. 1 and 10. 1 and 10. For example, if you specify the File Location as. When exporting a report containing an image attribute form (using an ApplySimple statement) to PDF in MicroStrategy Web 9. Personally, I would use ApplySimple and let the database handle the work. MicroStrategy parser doesnt recognize NULL as a key word for null value. 4. x. This can be accomplished using a combination of ApplySimple() and ApplyAgg() functions at the Fact and Metric definitions, respectively. Since there are 7 days in each week and 52 weeks in each year, this calculation will always match each day of the week to the. x, with the Intelligence Server running on Linux,. Fu nction Types. Explanation. x-10. The MicroStrategy Tutorial project is used to explain how users can customize numbers from "1,000,000" to a "1. Applysimple in Metric; Conditional metric and report filter interactions; Connection Mappings in Microstrategy;. Create a report with Category, Subcategory and Revenue. Keep the form expression unchanged. The following example is created within the MicroStrategy Tutorial project, specifically using the ORDER_DETAIL and ORDER_FACT tables. Microstrategy Dossiers With the release of MicroStrategy 10. CurrentDateTime () For more information on the syntax used in your specific database, refer to the appropriate section in the Functions Reference. For information on the syntax used in your specific database, refer to the MicroStrategy Functions Reference. Insert an HTML container (and not an image) and insert the script below. Create a Custom Group Element using the Relationship filter created in step 3: 5. The following example uses MicroStrategy Tutorial to explain the construction of a Year-To-Date metric. x. XSTEPS TO IMPLEMENT. An inner join is created and a line representing the join appears in the Query Builder pane, running. KB485687: The bulk insert is not working which caused performance issue when running multi-source reports. 4. The apply functions act as containers for non-standard SQL expressions being passed to the database. Microstrategy - creating a simple percentage column. MicroStrategy will continue to investigate and post updates as soon as they are available. Since the Engine does not know what operations are there, it cannot determine the inverse formula on which the optimization depends. Case. If I select name1 from the prompt, I do need to show all the occurances of. Number of Views 3. The script inside the " " always depends on the type of database used and can vary from one database. As shown below, for a specific report, the 'Group By ID Attribute' VLDB property is set to 'Group by column' instead of 'Group by expression' to avoid using an ApplySimple. In MicroStrategy SQL Generation Engine, security filters prevent users from seeing certain data in the database. RE: DateTime to Month formatConcat (Concatenate) The Concat function combines two or more input strings into one continuous string and returns the result. Derived metric based on attribute values Here is how could create and display data correctly on using below simple steps. NewObject (DssTypeMDSecurityFilter) objMDFilter. In addition, MicroStrategy also allows a business user to design custom ANSI SQL queries with a live connection to leverage any database push-down optimization such as query. In short, some attribute elements don't have a relationship with their parent/child attribute. x using an Oracl… Number of Views 6. solutions Forum; YTD transformation. e. This is true whether the null checking is written into the metric formula using the MicroStrategy function NullToZero(My_Fact), or using a database pass-through function such as ApplySimple("NVL(#0, 0)", My_Fact) for Oracle. The same logical should apply for other databases, but the syntax will need to be changed. Examples of this category are simple mathematical. x use the Day attribute to qualify on a particular date. ApplySimple where simple (e. of distributed under each attribute element. 1M type format. Choose the Light Theme from the drop down menu and click the Apply button. The prompt "Choose from all elements of 'Category'" is also placed into the report. Perform the following steps to update the table structure. x, with the Intelligence Server running on Linux, the image in the exported PDF report appears as a red "X" as shown below: However, the images in the report display properly when the report is. MicroStrategy functions are classified into the following types: Single-value functions (also known as Non-grouping or Scalar functions): These functions operate on each individual component of an input variable or argument, resulting in an output element for each component. Examples of this category are simple mathematical. The datatype used to define columns in temporary tables for objects defined with multiple inputs such as an applysimple statement are determined by the datatype of the first object listed in the object definition in MicroStrategy. The ApplyComparison function is used with comparison operators such as >, Like, and In. This is a single-value function. 2. However, by taking advantage of the ApplySimple expression, the attribute sorting can get applied correctly in Microstrategy Desktop and Web 9. 4. Open the project in which a new column is added. These functions are not supported by the Analytical Engine, so they must be calculated by the database. These triggers do not need to be defined in advance. MicroStrategy with Google Big Query. In the sample cube here, the native IDs from the cube does contain the login: [MSTR User]. x . x adn 10. Using Prompts and ApplySimple Statements. 4. ; Distinct is a TRUE/FALSE parameter that allows you to. Plano, Texas, United States. These values are set by default when the "Hive 0. The function removes the fractional part of a real number so that only the integer part remains. A split hierarchy is one - that at the lowest level - has more than one child. MSTR has evolved. 1 and 10. I just verified taking the SQL generated by MSTR back into SQL+ -- the SQL+ results work as they should; however, the report results are different. ApplySimple where simple (e. The result does not. The apply functions act as containers for non-standard SQL expressions being passed to the database. snowflakecomputing. By contrast, IF() allows database side conditional functions to be leveraged without using ApplySimple() or ApplyAgg() functions. All articles. This is a comparison function. This technical article outlines the steps to create rolling time attributes in MicroStrategy Developer 9. Applysimple in Metric; Conditional metric and report filter interactions; Connection Mappings in Microstrategy;. arithmetic operators) can be used. Once the administrator sets it up, the end user has to just log in with their Okta or Azure AD email credentials to start using MicroStrategy with Snowflake. Outer Joins come into play when MicroStrategy Engine merges the results from all SQL passes into one report. However, MicroStrategy does have a method for providing database specific SQL to be passed directly to the database; this is accomplished with the ApplySimple statement. This filter must be applied in the final pass to find the correct store-region relationship, even though the final pass is a normal join instead of a downward join. Instead, they are intended to enhance the MicroStrategy product by taking advantage of what the RDBMS platforms can offer. Unable to use columns from different tables in a derived attribute in MicroStrategy Developer 9. User may have the requirement to limit the date range selection within a specified period based on a single date prompt. The syntax always follows the format Applyfunction ("#0. The ApplyAgg function is used with Basic functions such as Sum and Max. Hi all, I was wondering if anyone knew of a way to change the display value of a NULL attribute (usually comes up blank) to display something like "UNKNOWN" or "NULL". This article covers how to use passthrough expressions to write custom SQL inside of MicroStrategy. Case can be used for categorizing data based on multiple conditions. Save the filter as "Region Filter". , metrics or attributes) containing a particular function or operator (e. ApplySimple: where simple operators (e. All attributes used to group data in the report or document are shown in the Available Attributes list. x report for a specific attribute using an ApplySimple statement as one of its forms. Now your connection f. 1 and 10. Info. MSTR has evolved. 4. Applysimple in Metric; Conditional metric and report filter interactions; Connection Mappings in Microstrategy;. Thus, if a Dynamic Date is created based on today's date, in order to get 'Last Month' a specific number of days can be subtracted from the date. nction Types. x. In this article we will discuss the ApplySimple function. To ensure this prompt requires an answer, select the 'Prompt answer is required' check box. The ID is distinct. 0 database: Create a date value prompt named "End Date" Create a metric "metric1" with the following definition: ApplySimple("Extract(EPOCH FROM DATE #0)", ?) Create a metric "metric2" with the following definition: Min() Fu. From the MicroStrategy Developer File menu, point to New > Attribute. Refer to MicroStrategy Knowledge Base document KB5700-007-0107 for more. ) are used. Environment: Microstrategy. 4. Another way to accomplish this using ApplySimple instead of ApplyComparison would be to drag the Hour attribute to. KB484697: How to use the ApplyX function without the "Use FreeForm SQL Report" privilege. g. ApplyComparison where. 1. There are five predefined Apply functions, each belonging to a different function type - ApplySimple, ApplyAgg, ApplyOLAP, ApplyComparison, ApplyLogical. x, with the Intelligence Server running on Linux, the image in the exported PDF report appears as a red "X" as shown below: However, the images in the report display properly when the report is. This is a single-value function. When using OLAP Cube data sources, aggregation at multiple levels can be performed in two ways. The Apply function types are listed below, along with examples of the MicroStrategy functions that they can replace: ApplySimple: Simple single-value functions, including arithmetic operators such as + and -, date and string manipulation functions, and so on; ApplyAgg: Group-value (otherwise known as aggregate) functions such as Sum and MaxApply functions provide access to functionality that is not standard in MicroStrategy, but is available in the relational database. Ranked #1 for Enterprise Analytics in 2022 Gartner Critical Capabilities Report. Returns the sum of all numbers in a list of values. The script inside the " " always depends on the type of database used and. 9, we’ve taken a leap forward in our dashboarding capabilities by simplifying the user experience, adding storytelling, and collaboration. Microstrategy Report Services documents vs Dashboards. The following steps can be used to concatenate two attribute forms. CONTENTS 1. The index for referencing these objects begins with 0 and increases by for each successive object passed. Custom groups; A custom group is a special filter that can be placed on a template and is. The following example will walk through how to setup an attribute form that converts a default datetime value in Microsoft SQL Server 2000 into a NULL value. MicroStrategy functions are classified into the following types: Single-value functions (also known as Non-grouping or Scalar functions): These functions operate on each individual component of an input variable or argument, resulting in an output element for each component. Examples of this category are simple mathematical. double quotes around it, substitute the column names with #0 . &[cbecker] The ApplySimple string can build this ID by using a placeholder where the user login should appear:This article covers how to use passthrough expressions to write custom SQL inside of MicroStrategy. ApplyRelative where OLAP (ranking, etc. Using the ApplySimple function, you can include prompts in your MDX to provide dynamic analysis on your MDX cube data.