Showing posts with label MicroStrategy. Show all posts
Showing posts with label MicroStrategy. Show all posts

Tuesday, May 12, 2009

How to hide Metric column in MicroStrategy

For hinding Metric column only in Web: (assuming that English language was the Locale.)
  1. On the Web Server machine, go to the default location of <>\Web ASPx\WEB-INF\classes\resources and open up the file called MessagesBundle_en_US.properties.
  2. Go to the line 'mstrWeb.1158'. For English language, 'Metrics' is the value.
  3. Delete the word 'Metrics' and leave one single space.
  4. Save the close the file.
  5. Restart Web server.

Note: If an environment is being accessed by users that may not be using the project default language, the administrator will need to go in and modify each MessageBundle properties file for that respective language and clear the mstrWeb.1158 Metrics reference.

-------------------------------------------------------------------------------------------------

For hiding Metric column in Desktop for Reports and RS documents.

1st method

  1. Goto Grid menu nad check that Automatic Column width is disabled.
  2. Place the mouse between the Metrics column and the first metric on the report. Then, drag the column to the left until it is no longer present on the report:.

2nd method

  1. Open Options under Grid menu.
  2. Open tab Columns and Rows.
  3. Select radio button Fixed.
  4. Select Metric from dropdown menu and set 0 as pixen as width.

MicroStrategy event in India

Finally, MicroStrategy Inc is going to host BI classes in India.

20th May: co-sponsored by Systech
22nd May: co-sponsored by InfoStep

Location are not specified, but looks like they would be hosted at Chennai and Mumabi respectively.

Tuesday, April 28, 2009

MicroStrategy license is Absolutely free now



Not within a month after the release of Free Reporting Suite (that's what MicroStrategy, Inc calls the free BI product), MicroStrategy, Inc. is giving away the must have features finally absolutely free. I user named rich Arriaga pointed out the same to me. First, I disbelieved, but I see that there are lot of change on the site itself. But one image showing that you need to pay for must have features still exist (check the image above). I thought I must have had done a mistaken in missing to read NOT INCLUDED during initial launch of Reporting Suite, but the site/license policy is indeed changed.

Also, now MicroStrategy explictly states that that technical support cost 18%, which I had posted earlier. Something that was missing from MicroStrategy, Inc site.

This will certainly help the MicroStrategy professionals community a lot and MicroStrategy clients in long run in easily hiring MicroStrategy professional readily and at good rate.

Sunday, April 26, 2009

1CPU installation on multi-core CPU machine

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.

Saturday, April 25, 2009

Free MicroStrategy license, should you really "Buy" that

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. Even my current client is looking for shifting some application to other BI tool.

Friday, April 24, 2009

MicroStrategy Basic for Dummies!

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.

Wednesday, April 22, 2009

Questions for Narrowcast Server Essentials

  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. 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. 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. 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

  1. A service must have at least one publication and at least one distribution set (a combination of subscription set(s) and schedule(s)).
    1. True
    2. False

  1. Service Editor does not allow a user to specify multiple publications while Service Wizard allows a user to specify multiple publications.
    1. True
    2. False

  1. ___________________ determines the number of recipients of a service.

  1. ______________________ allows the results of a single report to be parsed and personalized for individual subscribers.

    1. Personalized Page Execution
    2. Personalized Report Execution
    3. Personalized Content Execution
    4. Both a and b
    5. Both b and c
    6. a, b and c

  1. Which of the following is true?
    1. In Personalized report execution, Narrowcast Server gathers separate prompted report result for each group of subscriptions with the same personalization.
    2. In Personalized page execution, Narrowcast Server gathers report results from one report execution and applies personalization separately.
    3. In Personalized page execution, Narrowcast Server gathers separate prompted report result for each group of subscriptions with the same personalization.
    4. In Personalized report execution, Narrowcast Server gathers report results from one report execution and applies personalization separately.

Answer Choices

i. Only a and b

ii. Only c and d

iii. Only a and c

iv. Only b and d

  1. In Personalized page execution, preferences are indicated by answering prompts while in personalized report execution, preferences by selecting a specific page of the content.
    1. True
    2. False

  1. Event-based service can be achieved by
    1. Having an event table
    2. Having a temporary dummy table along with pre/post SQL statements
    3. Both a and b
    4. None of the above

  1. Personalization of dynamic content exists in different forms in Narrowcast Server namely
    1. Preferences
    2. Authentication
    3. Security
    4. Local Selection

Answer Choices

i. Only a and c

ii. a, b, c and d

iii. Only a, c and d

iv. Only a, b and d

  1. Subscription preference overrides default user preference for a subscription.
    1. True
    2. False

  1. The answers to question objects set at subscription level can be reused but the answers to question objects at user level cannot be reused.
    1. True
    2. False

  1. What is the object that determines the information from the information source a user is allowed to see?

  1. What is the object that determines the information from the information from the information source that a user wants to see?

  1. User can create a preference object without a question object.
    1. True
    2. False

  1. A security object prompt must be present in both the question object and the information object
    1. True
    2. False

  1. Scenario: Administrator adds a required security object prompt without default answer and additional required prompt object to the question object and information object. A user does not provide his preferences to this question object.
    1. Information object executes fine
    2. Information object fails since the required prompt objects go unanswered
    3. Information object executes and retrieves the complete result set
    4. None of the above


  1. Delivery Engine
  2. Subscription Portal
  3. SMTP and SMPP
  4. i
  5. c
  6. a
  7. E-mail subject, E-mail body (HTML) and E-mail attachment
  8. System Message Viewer
  9. iii
  10. iii
  11. a
  12. b
  13. Segment Size
  14. a
  15. i
  16. b
  17. c
  18. ii
  19. a
  20. b
  21. Security object
  22. Preference object
  23. b
  24. a
  25. b

Sunday, April 19, 2009

Free MicroStrategy license

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 ;-)

Friday, April 03, 2009

A Good comparision betwwen MicroStrategy and Cognos

Ashish Shah, a friend, has posted comparison between MicroStrategy and Cognos, on my MicroStrategy forum. Have a look.

Wednesday, April 01, 2009

ScanMD for MicroStrategy 9 launched

even if you don't have version 9 of MicroStrategy, just get it. ScanMD update which has come up after ages (not like frequent HF, SP or GA of MicroStrategy). It is toooooo good, even though I have't used yet. Have a look at the tech-note to downlaod new version.

The biggest problem with ScanMD is it would show you tons of errors even though there is just ONE discrepiency in your metadata. So, weeding out one error is a mammoth task. If you fixed a false error, you schema would go for toss forever and even MicroStrategy can't repair it.

Look at the last screen shot in tech-note which says just 4 errors. My God! Just 4. I have ran ScanMD on fresh metadata and found 100+ error. Don't believe it. Just install a fresh v8 and run the older version of ScanMD and you will see. Good job Engine team.

MicroStrategy 9 doesn't work

Installed MicroStrategy 9 just now only to seee that it doesn't work for some file compitability issue. Screenshot attached. :-(
Will post images when have this error rectified.

Thursday, March 19, 2009

Scan MD and MD Doctor

While working on metadata, there are chances that MD may get corrupt. Only reason for corruption of MD is MicroStrategy programmers NOT you (No way), unless you have manually fiddled with the metadata. One small change can messed the metadata forever, some time impossible to recover.

There are two types of discrepancies in MicroStrategy
  • Logical
  • Physical
ScanMD is used to recover from Logical discrepancies, where as MD Doctor is used for Physical discrepancies. Why these discrepancies creep????? Like any software application, there are bugs in MicroStrategy, dandling code (a situation never programmed), etc. such a thing is the main reason behind discrepancies.

Logical discrepancies: Using desktop you can create/delete several objects. Sometime deletion of the objects doesn’t get reflected in metadata and they get deleted in metadata but still available in front-end. Now such a mis-match in case of schema objects is simply killing, because it won’t let you update schema at all. Imagine not having ability to update schema. Using ScanMD is not an easy task. ScanMD shows 95% for false errors as discrepancies. Engine team of MicroStrategy, Inc. needs to update the tool. For one error, you may have to go through 100+ errors. You can verify the error easily by having project opened side by side. NEVER EVER FIX A FALSE ERROR.

Physical discrepancies: There are not just 10 DSS tables that make metadata, there are several more database objects that are created for metadata; e.g., triggers, views. If any of these objects are messed up, you have a physical discrepancy in your project. I’ve never worked on MD Doctor and look forward some information from you.

This blog is not exhaustive and 100% as I certainly do not believe the bugs in MicroStrategy are only source of discrepancies in metadata.

Tuesday, March 10, 2009

MicroStrategy Interview questions 101 - II

77. Can you update a table in Warehouse using MicroStrategy?

78. attribute role, Security role, security filter and access control ?

79. How will you resolve an issue when (by chance) a aggregate table at higher level has a higher LTS than an aggregate table at lower level? What happens if LTS is high for a hight level table?

80. What are the criteria used by the MicroStrategy SQL Engine to build the join tree of a report's SQL?

81. When a WH Primary key doesn't appear as keys in MicroStrategy table editor OR Can MicroStrategy logical primary keys and the true (warehouse) primary keys differ?

82. Oracle has a pseudo column named ROWID which is not "directly" exposed to frone-end?Can this table be used in MicroStrategy? Why one would do that?

83. Can you enable/disable the thresholds based on some condition/prompt answers?

84. In a Document, there are 5 reports and 3 out of them need to have a prompt so that 20 user can select first day of the week for which user want to execute the report. How many promts would be required to be made?

85. Can you make a floating window in MicroStrategy Web?

86. What's XML Cache?

87. Can you apply themes to MicroStrategy Web? How to create a one?

88. Can MicroStrategy be installed on Solaris or UNIX w/o Root access? Can such a server be (re)started?

89. If you have a Quad core CPU and MSTR license to use CPUS, can you set to use two particular cores dedicately for I-Server (As other core may have been programed for some other dedicated work)

90. What's a System call error? Have you seen Object variable error?

91. Drawbacks on 4GT switch?

92. Can you create Schema objects in 2 tier connection? IS it recomended?

93. What's a Bulk export report?

94. After a bulk export report is run, NCS puts it on an ftp location? Can this location be directly made available in MSTR web?

95. Can you cap the number of reports run at a time by users? What happens when this limit is breached?

96. What's the use of Monitor? What kind of error are captured in it?

97. Have you evre manualy edited the metadata? why?

98. Can you have a pronpt in free form sql report?

99. What will happen when the network connection between the webserver and one of the clustered I-server is lost? Will report run smoothly?

100. Can you priotorize report execution?

101. You have Clustered I-Servers? Can you some how disable Web users to use only one
I-Server?

More to come, but not before a 6 months gap.

Monday, February 16, 2009

Report filter, View filter and Report limit

Comparison of various types of MicroStrategy filters.



1 – Main reason to use Report Limit, else it doesn’t give any performance improvement compared to Report Filter (Metric based) in case of big data set to be SQLed.

Friday, February 13, 2009

MSTR Object Tracking Tool

Dear All,
I have created MSTR Object Tracking Tool (beta) for easy preparation of tracking sheet in a Excel. you can customize by selecting date (creation, modification, from , to date, select number of object types, etc.) I'm looking for some one who like to test the same. Pls let me know if you are interested to to test the same, Thanks.

Email: senthil.raj.u@gmail.com

Sunday, February 08, 2009

Is MicroStategy BI implementaion recession proof

This question I had all the time I've been working on MicroStrategy, but with an exception that I had not seen recession.

Prima facie, the answer is Big NO. Most of my friends, who are working on different clients in varied domain, are not working on any important projects or not working at all (including me). All of a sudden the clients have deferred further implementation of MicroStrategy project(s). Around 14 friends of mine have changed job in last 6 months and none of them is actually working on a MicroStrategy project, so one can easily imagine the situation in developed countries, mainly USA.

TARP is yet to come into picture. Scene is going to be same for next 2 months, the time taken for TARP to show effect.

This time clients are simply trying to optimize the current BI not trying any new BI implementation. Few MicroStrategy or other core BI vendors are moving/thing to Open source BI.

MicroStrategy commands a loyal customer base but repeat business or sale of Orion will be something hard to see in near future.

Saturday, February 07, 2009

Cease and Desist Letter received from MicroStrategy, Inc

I've just received a Cease & Desist letter for having registering domain names "microstrategy.co.in" and "microstrategy.in". The reason behind this is

1. Using companies trademark, illegally.
2. Domain names made in bad faith since you are not using domain names for any legitimate purpose.
3. abusive registration of domain names

Pretty much pissed off against MicroStrategy, Inc as I love the company for which I've worked (though outsourcer) and I receive this kind of letter.

microstrategy.in
directs to microstrategy.co.in which is a MicroSteategy forum.

Can't comment legally, but I do not use anything that can be trademark violation. Site is fully operational and happening so nothing can be bad taste and I need to know what's an abusive registration of domain name.

If you have any legal/para-legal advice to let me know.

If they would have had asked politely or tried to contact though common acquaintances, I would have had given to them. But this D&C is torturous. Nothing is illegal on site or site itself is not illegal. I would contest the domain name ownership in Indian court under Indian IT Act 2000.
---------------------

Update 9th Feb 6:30 pm IST

Indian IT Act 2000 doesn't define anything like cybersquatter. Such case can be only fought in court of law or can be settled by Arbitrator of .IN Registry (which still can be challenged in court, extremely tedious and slow process).

One can check the list of domain that were awarded to the Complainant here. I've been though most of them and found that the Registrars were indeed cybersqatters and it was pretty easy for rightful owners to get back the domain (this includes monster.in, pizzahut.in, sonyericsson.co.in, gmail.co.in, morganstanley.in, youtube.in, kfc.co.in, franklintempleton.in).

If one reads the case document on the link above, one would come to know that there were people who had simply parked the domain or had opened shell/ad site not hosting anything actually. But I have a strong case and I would be fighting tooth and nail for the hard work I've done in setting up the forum and bringing some good people knowing MicroStrategy.

Wednesday, January 14, 2009

Multiple Intelligent Server on single machine

A common question asked (and twisted) and newbie are trapped if answered incorrect. :-)

Answer is Yes in case of All UNIX/Linux (AIX, Solaris, UX, RH Linux, Suse Linux) and NO for Windows.

One thing to be taken care of. Can't run both servers on same port number. :-)

Tuesday, December 23, 2008

MicroStrategy 9.0 release

MicroStrategy 9.0 codenamed Orion will go GA by Q1 2009, which is still like 3-4 months behind schedule. It is too good as far as some stupid bug fixes that I wanted for long time and some dashboard stuff.

My suggestion - If you are non-English user wait till 9.0 SP1 to be released, or at least HF1. You will not regret your decision.

Sunday, December 21, 2008

Report Service Documents

Every time we rename an object, MicroStrategy updates that object’s name in all of its dependants. That’s true, right?… Or is it?
Well, it’s almost true. This fails when the object whose name we change is referenced as a data field in a Document.

Tip. A data field is a text field that is created either by dragging it from the Dataset Objects area into the Layout area, or by creating it manually and then typing the object’s name. The name should appear between braces ({}) and should be also surrounded by brackets ([]) if it contains spaces or special characters. 

Now, because the data field does not have an object ID, MicroStrategy is completely oblivious if the object referenced in it is renamed, thus the document will not run. Strangely enough, it performs fine if the object was moved to a different folder.

The way to avoid such mishaps is to do a dependence check when renaming a Metric or Attribute and see if they are being used as data fields inside a Document. All it takes then is typing the new name into the text box. 

Of course, if the object is used in the Document as part of a grid, then the Metadata does its job very well.