All posts by Tiwari Ashish

1CPU installation on multi-core CPU machine

License, MicroStrategy

This is wrt Windows

As per the MicroStratey license, product can not be installed on a machine having more number of CPUs then licensed. OS system sees each core of CPU is seen as separate CPU. don’t know what’s the case with MicroStrategy. (As per the definitions document of MicroStrategy license)

But tech notes are very contradicting. MicroStrategy Intelligence Server is limited to the number of CPUs purchased, even if the machine hosting MicroStrategy Intelligence Server has more than this number of licensed CPUs. For example, if two CPUs have been purchased, even if a machine where MicroStrategy Intelligence Server is installed has four CPUs, MicroStrategy Intelligence Server will only use two CPUs on that machine.

The good thing is that tt is possible to configure four-processor machine to only use one processor. Likewise, a license for more than four CPUs would allow users to allocate from one to four processors on a four-processor machine.

If you have any information about the same, please share.

Free MicroStrategy license, should you really “Buy” that

License, MicroStrategy,

I would recommend you NOT jump from you seat by reading the word FREE. If you are a person who is a stakeholder for purchase decision of a BI product, you must be knowing it well that Nothing comes free in life.

Remember following things:

  1. The MicroStrategy Reporting Suite may only be used for new MicroStrategy projects. Thus, products downloaded as part of the MicroStrategy Reporting Suite may not be substituted for existing products in existing MicroStrategy installations. Also, MicroStrategy Reporting Suite Technical Support Services pricing is not available for Products in existing MicroStrategy installations.
  2. Free Reporting Suite is one and only for client who do NOT have a currently valid license. So don’t expect to upgrade your older version to v9 for free.
  3. Recipient shall hold all Confidential Information received during the term of this Agreement in confidence during the term of this Agreement and for four (4) years thereafter. This so called Confidential Information is nothing but rates at which software is licensed. Big corporates gets too much of discount due to volume. The 4 years is the reason no one ever gets the idea about the rates which it was licensed for someone negotiating best rates to license of MicroStrategy. When I’ve got a chances with meeting people who decided to buy MicroStrategy licenses, they all told about the way they negotiated but not rates.
  4. If you installed with 100 named user product key, you will have to purchase a 100 named user technical support even though your requirement may not be good enough for 25 named user. This is a very big headache for big companies specially.
  5. On each Order, MicroStrategy will state the price of Technical Support Services for a period of one year commencing on the date of delivery of the Products. This is about 17% of the product cost (similar in line with SAP).
  6. MicroStrategy Intelligence server send the license compliance information to MicroStrategy Server one a day. Today in the ear where each MicroStrategy machine is known by its unique installation activation, it is damn easy for them to find who is infringing on their licenses. I know in past they have gone suing client for non-compliance of licenses for a minor violation. The option to set time when to send license information is available in I-Server configuration. One can work around it by stop letting the machine access internet on which I-Server is installed. I some time really pity on those clients of MicroStrategy.
  7. MicroStrategy’s Roles based (named user based) licensing strategy is very tricky for clients.
  8. MicroStrategy has time bomb within the Software that shall prevent use of the Software. This time bomb can be triggered by them based on the free license serial key. We don’t know if these time bombs attached with free licenses. Sound funny. Read the full license agreement.
  9. There is not guarantee of free upgrades anywhere. What if MicroStrategy ask for obscene amount for future upgrades.
  10. MicroStrategy is notorious for arm twisting hooked customers with rigid pricing. I personally know of many companies who have drifted from MicroStrategy to other BI tools only because of licensing issues, very costly support, making vital “Named User” license exorbitantly costly.

MicroStrategy Basic for Dummies!

Education, MicroStrategy,

5 very informative online videos to learn basics of MicroStrategy. Deserve a dekho.

  1. Set Up and Configure the Server
  2. Design Attributes and Hierarchies
  3. Design Metrics, Filters, and Prompts
  4. Add Users
  5. Go Live on the Web

Check out all videos here.

There is a Chines proverb – A Picture can say 1000 words
and Indian upgrade – video can say 1000000 words 😉

Last but not least, you can learn MicroStrategy of you own provided you have it installed and go though the online tutorials religiously. They rock! Real MicroStrategy Education USD 650 a day tutorials for free reading. If anyone know any method to store them offline, please share. Finally MicroStrategy is serious about having more number of MicroStrategy professionals in world. Hope to see the MicroStrategy books on Amazon too, not with USD 650 tag as charged currently by MicroStrategy Education.

Questions for Narrowcast Server Essentials

Education, MicroStrategy, Narrowcast Server,
  1. __________________ is responsible for the creation, formatting, transmission and administration of information services.

  1. ________________ is responsible for the gathering of user profiles and preferences through a web-based subscription site.

  1. Narrowcast Server information transmitters transmit services using _________ and _________.

  1. Which of the following are the featured components of Narrowcast server –

  1.  
    1. Narrowcast Administrator
    2. Delivery Engine
    3. Portal Administrator
    4. Subscription Engine
    5. Subscription Portal
    6. Alerts Engine

Answer Choices

i. a, b, c, d, e

ii. a, b, c, e, f

iii. a, b, d, e, f

iv. a, b, c, d, e, f

  1. Match the following –

Module

Function

a. Information Source

i. Connect to local or remote systems such as SMTP, SMS, WAP servers to deliver formatted content

b. Information Transmission

ii. Transforms raw data provided by information source into formatted message, output formats supported being text, HTML and Excel by default

c. Document Formatting

iii. Used to retrieve personalized information from local or remote systems such as Intelligence Server.

  1.  
    1. a à i, b à ii, c à iii
    2. a à ii, b à i, c à iii
    3. a à iii, b à i, c à ii
    4. a à iii, b à ii, c à i

  1. A service can have different publications each supporting a different language.
    1. True
    2. False

  1. The three different information to defined for an e-mail (SMTP) content are _____________________, ______________________ and ______________________.

  1. ________________________ is used to view the log when a service is run.

  1. Which of the following are true?

  1.  
    1. Content information object pulls dynamic data from an information source.
    2. Document is a complete formatted object which can have both static content and dynamic content
    3. Document can contain only one information object
    4. Publication is a collection of documents specifying the content of a service
    5. Publications specify information transmission module, locale and devices

Answer Choices

i. Only a, c and d

ii. Only a, b and d

iii. Only a, b, d and e

iv. a, b, c, d and e

  1. Which of the following are true?
    1. Information transmission module sets the rules for the types of documents supported by a publication
    2. Locale specifies regional characteristics like Language, number, date and time formats
    3. Device sets the formatting and transmission properties such as cell padding and embedding image support
    4. The device specified in the publication MUST match the device in the subscription set for a recipient

Answer Choices

i. Only a, b and d

ii. Only a, b and c

iii. a, b, c and d

iv. Only b, c and d Continue reading →

Free MicroStrategy license

License, MicroStrategy,

Finally MicroStrategy has woken up the truth and I must say my blog is definitely a contributor for them (MicroStrategy employees form a very good amount of user of this blog, specially the tech support).

One needs to create a MicroStrategy account before downloading. Account creation is 100% free, no need to have purchased MicroStrategy. (If you are a MicroStrategy professional, you can create a free account and access MicroStrategy tech support unlimited. You just need to use official email address. But don’t think that you can migrate your account to your new employer)

After having created your account, click here for your free license key.

You can get free license for up-to 100 named user with 1 CPU restriction. Broadly, MicroStrategy have two types of licensing. Named user and CPU based.

Various support options are here.

But don’t expect ability to create hi-fi reporting as this is a scaled down version which doesn’t include Reporting Services (dashboard), in-memory BI, Multiple Warehouse and many more. To know instantly know what is in and what is out in this free license, have a look at this illustration.

I don’t know what MicroStrategy plans by giving a half hearted version. Pretty frustrating. Why don’t they think of SME license like SAP or country specific differential licensing. They are just interested in big corps and satisfying the reporting requirements of them. (MicroStrategy future development is mainly concentrated to top 50 clients. They decide and direct the development, thet’s what they call or feel the world by beta program) and MicroStrategy, Inc thinks what suites them (beta program users) will suit all.

MicroStrategy is a very good employer and the most of top employees are like full time MicroStrategy veterans, but I think it a time they should get some fresh recruit to get some fresh ideas for a better future of them and mine too. On whole, I pity on this idea of free MicroStrategy because they have removed the juice out of MicroStrategy in free version. IT would take a quite longer time for compnaies to decide going for purchasing an add-on.
—–

I’m not well for last 3 weeks, hence no posts. Not fully recovered. Hope to get well soon and post periodically. So bad that I dozed off in office last Monday 😉