What should you ask your future employer

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?

Migrating a 2 tier project source to a 3 tier source

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

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.

Teradata India - a sorry picture inside

Teradata is said to be the best back-end as far as MicroStrategy is concerned. Most of MSTR people I know, they have Teradata as the back-end. FYI, Walmart has the biggest implementation of MicroStrategy with more than 100 boxes of Teradata.

Now cut short to Teradata India, which is mainly involved in selling the Teradata boxes and then co-selling its consulting services (After all database requires some front-end to make use of it). My several freinds who are client side from Teradata have bitter experience. Teradata is just concerned about selling their boxes and letting employee "manage" things at client side of it own. Lots of people are working under duress.

They keep on advertising about MSTR position almost round the year but I fail to understand why their experience MSTR resources are working on different technology or worse on bench.

Last and the serious bomb. There is set targets for employees about Teradata certification. Obviously you need not pay for it. But, if you do not achieve it, you may get no raise at all. One of my friend's friend was so busy with the work (he did a great job) that it was impossible for him to remove time and do the certification. You get a bomb that there is no raise as you have not completed any certification.

If you are planning to join Teradata, do a good due diligence.

Keys and Levels in MicroStrategy

Some notes and a tip:

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.

3rd Compnay to purchase MicroStrategy in India

There are just two compnay taht use MicroStrategy. Wipro ePeripherals (Not Wipro Software) and Ashok Layland. Wipro license is of 7.2 and it is expired and they are not sure to purchase latest version of MicroStrategy. ALL is stil using MicroStrategy.

Now Pentaloon Retail is the latest purchasere of MicroStrategy and Mudra Garment is an unconfirmed buyer. I'll update the information as and when avaiable.

A new MicroStrategy forum

I've started a forum on MicroStrategy. Take a look.

http://microstrategy.co.in/phpBB3/index.php

What's new in next version of MicroStrategy 9.0 (Orion)

1. Connect to two different warehouse in same report but Free form SQL report won't be having this feature.
2. RS document not to lose derived metric or object prompt in the included report.
3. Track object changes by user name, from which machine, IP address, etc. (change audit)
4. Drilling in RS document. A new mode for RS document to accomplish this feature.
5. Drill to multiple objects.
6. ACL control in web but not so well as in desktop.
7. Prompt and filter creation in web.
8. In web, when drilled to a template, prompt in template will be executed. Currently, it happens only in Desktop.
9. I-Server metadata and NCS metadata will be part of same database.
10. Intelligent cube can be controlled by end user.
11. On-fly custom group creation feature called Derived Element.
12. **Monitor** cache, projects, cluster, jobs, user connection, and similarly. These users can't edit, modify or create.
13. Rules creation "what to do" when History List is full.
14. Explicit RS Document **caching** not just containing reports