In other words, some data goes IN, then the function transforms them, and other data comes OUT. FunctionsĪ function is a mathematical or logical action that transforms data and then returns a modified version of data. MDX is a language and to use it for calculations it is enough to understand some base words (data types and functions) and how to use a dictionary (list of available functions). Don't worry you will get along quite well if you follow some ground rules. Mastering how to write MDX expressions is initially quite difficult. Calculated members and measures are defined using the MDX (multidimensional expressions) query language which is the main query language implemented by Mondrian ( ) What you should know The most common use cases for calculated members and measures are to group particular items of interest, dynamically change time according to the current date or selected period, and, most importantly, derive new measurements from existing data. MDX Used in eazyBIĬalculated members and calculated measures can be used to add business logic to a report and a data cube. MDX implementations vary, and many MDX documentation resources are specific to certain niche products or standards.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |