Create Elements Prompt and add them into Report coming from Intelligent Cube.So how are we going to address having “Hierarchy Prompt” on top of Intelligent Cube ? Technically it allows only “Elements Prompt” & “Expression/Value Prompt” with “MicroStrategy Developer” interface Wacky Wednesday – What is the limitation we are talking here today ? Can we use all types of prompts within Datasets/reports created on top of Intelligent Cube ? If you’re an Tableau user, then you can treat this “ Prompt” object as “ Parameters” in Tableau. These prompt types are discussed individually later in this section.” There are many types of prompts, and each type allows a different type of question to be asked. Instead of building several different reports that each answer a different, single question, a set of questions can be asked just before a prompted report is executed. Here is detailed definition from MicroStrategy “Prompts allow you to determine how the report returns data from the data warehouse. Prompts are basically “allowing user to dynamically input user responses during the execution of report/document within MicroStrategy” (e.g.) Select Year during the execution of report to view “Revenue by Year” It is basically in-memory storage of WH/EDW(Warehouse/Enterprise Data Warehouse) data within MicroStrategy layer/server itself. Intelligent Cubes are multi-dimensional cubes (sets of data) that allow you to use OLAP Services features on reports, as well as share sets of data among multiple reports Credit: MicroStrategy for having this diagrammatic explanation Today i thought of sharing the experience of having “ Hierarchy prompt” within the Intelligent Cube based datasets/reports/grids.īefore i deep dive, let’s discuss some basics :
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |