How To Create Consolidation In Microstrategy Web
Consolidation elements
Consolidation elements are attribute elements that define the consolidation. Consolidation elements can also be an expression of attribute elements that make up a consolidation. They can be defined from any of the following:
| • | Elements from the same attribute, such as two cities |
| • | Attribute elements from different levels of the same hierarchy, such as Region and Call Center in the Geography hierarchy |
| • | Elements from attributes in different hierarchies, such as Country (from the Geography hierarchy) and Year (from the Time hierarchy) |
| • | Existing consolidation elements, such as the ratio of Spring and Summer sales to Fall and Winter sales |
| • | Elements from any other consolidation in the project (elements imported from an existing consolidation into another one) |
You can combine the elements with simple mathematical expressions. For example, you can have an expression that adds attribute elements together, such as combining June, July, and August to get a Summer consolidation element. A consolidation element can also contain the logical operator AND. The following example demonstrates the use of mathematical expressions (addition and subtraction) and the AND operator.
Example of AND used in a consolidation element expression
You must report on the difference in revenues between the USA and Web for the winter of 2002. Create the following consolidation elements:
| • | USA: Winter 2002 |
({Month=Jan 02 AND Country=USA} + {Month=Feb 02 AND Country=USA} + {Month=Mar 02 AND Country=USA})
| • | Web: Winter 2002 |
({Month=Jan 02 AND Country=Web} + {Month=Feb 02 AND Country=Web} + {Month=Mar 02 AND Country=Web})
You cannot type AND into the expression. You must drag and drop an attribute element into the expression to trigger the AND operator. For more details, see the online help.
Create a consolidation element that uses the above elements to calculate the difference:
| • | USA - Web: Winter 2002 |
([USA: Winter 2002] - [Web: Winter 2002])
Finally, create a report with this consolidation and the Revenue metric. The report looks like the following:
Elements from the same attribute
A consolidation can contain elements from the same attribute, such as (March) and (April), both elements of the attribute Month of Year. With reference to the previous example, consolidation elements allow you to expand the consolidation to see the values for each month. For example, using elements from the same attribute, you can modify the report result set as follows by adding the following three elements to the consolidation:
| • | Element 1 (March) |
Month of Year=March
| • | Element 2 (April) |
Month of Year=April
| • | Element 3 (March-April) |
{March}-{April} With the use of consolidation elements, the report can now display the following.
A consolidation can contain any expression on the pairs of elements, such as (March - April). Using another example, an element expression can also be [DC, 2002] / [DC, 2003].
Elements from different levels of the same hierarchy
A consolidation can contain elements from different levels within the same hierarchy, such as Item and Subcategory from the Products hierarchy. For example, you may want to compare the contribution of different items to the Subcategory sales. Your consolidation, for the items Chocolate Roses and Chocolate Spoons, looks like:
| • | Element 1 (Roses percent) |
[{Item=Chocolate Roses} / {Subcategory=Chocolate}] | • | Element 2 (Spoons percent) |
[{Item=Chocolate Spoons} / {Subcategory=Chocolate}] With the use of consolidation elements, the report displays the following.
Elements from attributes in different hierarchies
A consolidation element can contain elements from attributes in different hierarchies. For example, you can calculate the difference between two different regions for a particular month. For the months March and April, the consolidation could contain the following elements:
| • | Element 1 (March Southeast - Southwest) |
[Month of Year=March AND Region=South-East]
- [Month of Year=March AND Region=South-West]
| • | Element 2 (April Southeast - Southwest) |
[Month of Year=April AND Region=South-East]
- [Month of Year=April AND Region=South-West]
The report now appears as follows:
Existing elements
Using existing elements allows you to perform row level math, as described previously. For an example, see Perform row level math.
Importing elements from other consolidations
You can import consolidation elements from an existing consolidation. When a consolidation element is imported, a new consolidation element is created and embedded into the consolidation.
Did you find this helpful?
Yes
x
Great!
Thanks for taking the time to give us some feedback.
No
x
Sorry about that
Why wasn't this helpful? (check all that apply)
Thanks for your feedback.
Want to tell us more? Send us an email to leave your feedback.
Email us
Waren Ihnen die Informationen hilfreich?
Ja
x
Großartig!
Vielen Dank, das Sie sich die Zeit genommen haben, uns Ihr Feedback mitzuteilen.
Nein
x
Das tut uns leid!
Warum waren diese Informationen nicht hilfreich? (Zutreffendes bitte auswählen)
Vielen Dank für Ihre Antworten.
möchten Sie uns noch etwas mitteilen? Senden Sie uns eine E-Mail mit Ihrem Feedback.
E-Mail an uns senden
Ces informations vous ont-elles été utiles ?
Oui
x
Superbe !
Merci de nous avoir accordé un peu de votre temps.
Non
x
Nous en sommes désolés
Pourquoi ne vous ont-elles pas été utiles ? (cochez tous les choix applicables)
Merci de vos commentaires.
Vous voulez nous en dire plus ? Envoyez-nous un e-mail pour nous laisser vos commentaires.
Envoyez-nous un e-mail
Questo contenuto ti è stato utile?
Sì
x
Perfetto!
Grazie per avere dedicato del tempo per fornirci un tuo commento.
No
x
Siamo spiacenti
Perché non è stato utile? (selezionare tutte le risposte adeguate)
Grazie per il feedback.
Vuoi inviarci un commento? Inviaci un'e-mail o lasciaci un commento.
Inviaci un'e-mail
¿Le ha resultado útil?
Sí
x
¡Genial!
Gracias por dedicar su tiempo a proporcionarnos sus comentarios.
No
x
Lo sentimos
¿Por qué no ha sido útil? (Marque todos los que correspondan)
Gracias por sus comentarios.
¿Desea informarnos de más cosas? Envíenos un correo electrónico para dejar sus comentarios.
Envíenos un correo electrónico
Você achou isso útil?
Sim
x
Ótimo!
Obrigado por aproveitar o tempo para nos dar alguns comentários.
Não
x
Desculpe por isso
Por que isso não foi útil? (marque todas as que se aplicam)
Obrigado pelos seus comentários.
Quer nos contar mais? Envie-nos um e-mail para deixar seus comentários.
Envie-nos um e-mail
役に立ちましたか?
はい
x
ありがとうございます。
お時間を割いてご意見をお寄せいただき誠にありがとうございます。
いいえ
x
それは残念です
役に立たなかった理由は何ですか? (該当するものをすべてチェックしてください)
ご意見をいただき誠にありがとうございます。
もっと詳しくお聞かせいただけますか? メールでご意見をお聞かせください。
メール
도움이 되었습니까?
예
x
수고하셨습니다.
피드백을 위해 시간 내 주셔서 감사합니다.
아니오
x
죄송합니다.
도움이 되지 않은 이유는 무엇입니까? (해당되는 모든 사항 선택)
Thanks for your feedback.
Want to tell us more? Send us an email to leave your feedback.
Email us
您觉得这篇文章有用吗？
否
x
我们对此感到抱歉
为什么您觉得没什么用？ （选中所有适用项）
感谢您的反馈。
希望告诉我们更多信息吗？ 请发送电子邮件给我们，留下您的反馈。
给我们发送电子邮件
How To Create Consolidation In Microstrategy Web
Source: https://doc-archives.microstrategy.com/producthelp/10.4/AdvancedReportingGuide/WebHelp/Lang_1033/Content/AdvancedReporting/Consolidation_elements.htm
Posted by: kangwassfy.blogspot.com
0 Response to "How To Create Consolidation In Microstrategy Web"
Post a Comment