All posts by Tiwari Ashish

MicroStrategy Custom Groups by Sushil Muzumdar


Deprecated: Function get_magic_quotes_gpc() is deprecated in /home1/microoat/public_html/blog/wp-includes/formatting.php on line 3964
3rd Party, MicroStrategy

Look at following video on YouTube.

This is crazy to see what we’ve got done from 3i on YouTube. As video is off poor quality, let me tell you what is it. Currently there is no option to create Custom Group in MicroStrategy Web. This MicroStrategy 8.1.1 Web SDK customization made it possible. But wait! let me tell you something about this. We (my employer) were the first and probably only buyer of this. 3i employee Sushil (happens to be uploader of this video too) was the man behind this request (web CG) that some (of employer’s) client were asking for long.

About this application, this is not even fully made. This guy simply disappeared when he was wanted to fix the bugs. It doesn’t provide the option to set the level (none, report, custom) for a filter based on Metric, so that option is still not exposed to clients. Person who did QA of this application (she declared everything Pass) was fired. Sushil, we are facing the heat of your half hearted application. Specially we feel bad cause my employer paid from nose for this highly unstable application. Because of this we had to almost remade this application by someone else. You specifically didn’t provide any code documentation.

This CG customization runs into a problem every now and then. Last but not least, this works only and only in 8.1.1 and up and is not forward complaint to MicroStrategy 9.0, to be released soon. I don’t know if being forward complaint was something looked at during planning phase. BTW, MicroStrategy 9.0 provides in-memory CGs. ASAIK, as per licensing condition, he can not re-sell it and he is trying to sell it. You may land in soup for this.

What should you ask your future employer


Deprecated: Function get_magic_quotes_gpc() is deprecated in /home1/microoat/public_html/blog/wp-includes/formatting.php on line 3964
Interview
  1. Work days in week? 4 days 5 days or 6 days?
  2. How many hours a day?
  3. How is salary credited and what day of month?
  4. Position/Designation offered?
  5. Do they provide free food? Do they have in-house kitchen?
  6. Do you give Meal vouchers as part of CTC? How much can I avail? Is there any cap due to position? How and when it is disbursed?
  7. Does the job require travel and what if yes what percent?
  8. To whom I’ll be reporting to and his designation?
  9. Relocation reimbursement and the upper limit? T&C.
  10. Initial accommodation in a new city? How many days?
  11. Dress code? (For me most important question)
  12. Number of leaves in a year. Leave policy in detail.
  13. How long is probation period?
  14. Entitlement of leaves during probation period?
  15. Anytime they mentioned year ask about financial or calendar?
  16. Joining date?
  17. Am I insured by new employer? Are you insured from day 1?
  18. Does your parent get Insurance protection (even if it is paid)?
  19. Do let them know the time you need to deny/accept the offer.
  20. Is LTA an optional component of CTC? If NOT opted, would it be given every month?
  21. Do I get an independent extension or shared? If shared among how many people do I need to share?
  22. Do I need to work from Home? What’s company policy regarding this? Do you provide laptop/ reimbursement Broadband charges?
  23. Do I get unrestricted internet access in office?
  24. Can I carry forward my MicroStrategy account?
  25. Are you MicroStrategy Inc listed partner/reseller/support provider?

Migrating a 2 tier project source to a 3 tier source


Deprecated: Function get_magic_quotes_gpc() is deprecated in /home1/microoat/public_html/blog/wp-includes/formatting.php on line 3964
Administration, MicroStrategy

Technically, you don’t really require anything to make a 2 tier, just configure it using configuration manager (your access file). 2 Tier connection is also possible for a Oracle, SQL Server, or any other database.

There are two ways one can migrate a 2 tier (access) based project to Excel.

1. Project duplicate using Project duplication wizard or Object manager.
2. Import the access database into your relational database (Using ETL)

Types of objects in MicroStrategy


Deprecated: Function get_magic_quotes_gpc() is deprecated in /home1/microoat/public_html/blog/wp-includes/formatting.php on line 3964
MicroStrategy

There are only and only three types of object in MicroStrategy. they are same follows:

  1. Schema
  2. Application
  3. Configuration

Note: Public objects is just a folder in metadata which “mainly” holds application objects, it is not a type of objects. Security Filter is a configuration object even though it is created the way application objects are created.

Keys and Levels in MicroStrategy


Deprecated: Function get_magic_quotes_gpc() is deprecated in /home1/microoat/public_html/blog/wp-includes/formatting.php on line 3964
Administration, Architect, MicroStrategy, ,

Table keys are the lowest level attributes in their respective hierarchies that are present in the logical table.

Fact entry levels are the lowest attribute levels at which a fact exists. The fact entry levels correspond to the lowest-level table key attributes for all the tables that define the fact.

A fact is only extended if a join does not exist between a fact table and the attribute to which the fact will extend to, i.e. the fact does not exist at the level of that attribute.

MicroStrategy SQL Generation Engine is sensitive to differences between its internal state and the states of metadata objects, there is a risk of SQL generation failures if schema modifications take place during normal user activity. In general, it is not recommended to perform schema updates during periods of normal or high usage. Schema changes should normally be reserved for periods of little to no user activity.