Answer / adarsh katiyar

please get familiar with the basic concept of MicroStrategy Intelligent Cubes. There are certain limitation to MicroStrategy functionality when using Intelligent Cubes. You already mentioned Consolidations and Custom Groups... but there are further features to consider like Level metrics and so on...




Let me pick Custom Groups as example. A custom Group allows you to combine unrelated "queries" with each other. For example you can determine Top 20 customers, report the revenue of all customes with M, and add some regional figures in a single custom group. Technically this will result is different queries on the database, due to the fact that each calculation level is different. Most likely several, different fact tables are uses for each query.




When using an Intelligent Cube, you already have an in memory dataset. This dataset needs to contain all data in the required granularity. When you need data outside of the cube to perform certain calculations, this is not possible.... these data are missing.




My assumption is that certain features can simply not be used with cubes to avoid bad user experiences and reduce complexity.

what are the nulls on microstrategy report and how to mask them.

1 Answers   iGate, TCS,

---

1.Have u logical models in project? If s which logical model used? 2.how do u connect to production server? 3. how do u test the data in report is same as in DWH? 4. u created one report but there is no data in the attribute. But how can u extract the data from ware house? 5. u have two tables having different ids how do u merge those table in MSTR? 6. have u faced challenging situation in u r project? Give me one example?

0 Answers  

---

Explain snowflake schema?

0 Answers  

---

Your application mode has crashed. A.) How would you run your i-server? B.) How would you get the instance back?

0 Answers  

---

Can you explain surrogate key?

0 Answers  

---

what is subqueary and what is temporary tables?

3 Answers   BirlaSoft,

---

I want to get sales data for the last (suppose 10) dates dynamically using value prompt how can i do it and drag it onto report editor.

6 Answers   Target, TCS,

---

static prompt in microstrategy.

2 Answers   iGate,

---

How does microstrategy object manager determine if two projects are related?

0 Answers  

---

Can a record be inserted and updated in database using microstartegy?

0 Answers  

---

What is non-aggregate metric?

0 Answers  

---

Is it possible to apply themes to microstrategy web? How?

0 Answers  

---