Me, My life and MicroStrategy & ++

We have moved the blog to own domain: http://www.microstrategy101.com

Change your Feedburner and Google Friend Connect.

Also the MicroStrategy Forum can be found here.

Comments are blocked on this blog now.

In a previous post I’ve warned about the not so automatically behavior of the automatic mapping. However, I can’t blame the manual mapping for the same degree of inconsistency. I mean, boy, that’s as manual as it gets!

Take a manually mapped attribute and have a look at its source tables. Now drop the attribute from one of these tables (on database and Catalog level) and try to run a report which used that table.

On the one hand, MSTR knows from the attribute definition that it can include that table into the SQL. On the other hand, it should know from the table definition, as updated in the Warehouse Catalog, that the column is no longer there, but such a small detail doesn’t have enough force to deter the SQL Engine. So it simply writes the SQL as if nothing had happened, and the only error you get is from the database (i.e. a11.attribute_id does not exist).

So, if you aren’t doing this already, don’t forget to inform the manually mapped attribute that one of its source tables decided to discontinue their relationship, next time you indulge in such data model changes.

Dashboard Features:
 Easy to add Tabs and report layouts(Panels)
 Default templates available to choose the number of reports per tab
 Tab adding is just clicking plus sign(+)
 Drilling is possible in AJAX or DHTML mode
 All, Total features are introduced and bugs are fixed
 Many graph issues in 8 are fixed in 9

Prompt & Filter
 Prompt and Filter can be created in WEB
 New web options for prompt values display, Search in list view, drop down box and many new web options for filter and prompt
Total, Sub Total
 Advanced totaling, Display options (What ever available in Desktop, same features are now available in WEB

Derived Elements
 After report execution; kind of consolidation and partial custom group is possible (but actual cons and cus grp) and derived element can be saved and reuse the same.
 Example: Jan+feb or making Jan& Feb row together as ‘Winter’ and or total of MAR+APR
Threshold
 Threshold is possible in WEB on the fly. It’s just slider bar…you can set many thresholds with different color just on the fly.

Document Report
 Reports can be placed parallel in document report

Back & Forward button
 In MSTR-8, if you click on IE back button, session will be expired. But in MSTR-9, inside the MSTR-9 web there is option for back & forward.
 Suppose you applied some total, formatting, formula on the fly and if like to switch to old one, you can just click on back button

Preferences, Notes, Screens
 Extra preference like web colors, etc
 Different screen in MSTR 8, like menus and icons
 Folders/objects can be viewed in tree view (expand like windows explorer)

Delivery Service in WEB (new feature like Narrowcast server):
 It looks in the upcoming MSTR version, Narrowcast component won’t be there
 Delivery service: you can subscribe reports for email or folder, or you email reports directly.
 You add many email IDs, subscription
 Everything in WEB
Note: you cannot import LDAP or SMTP server emails from server, its has been raised as enhancement request, may be in 9.x we can expect.
Note: Dynamic subscription not possible in delivery service, next version may have (Not sure)

CUBE (New very big feature)
 Cube is kind of Cognos Cube. You can pull many attributes and metrics into metrics as cube report. And when you link other normal reports with cube report, it will fetch data from cube report.
 Cube report can scheduled
 Cube object deleted, reports linked to cube report won’t work.
 There cube at user level, grp level and many things are there…you can find more details in website or help in MSTR-9.

CUBE Advisor: (Another big feature)
 If I have to say in one line: it will advise you to make how many reports can be converted to cube link report

Admin:
 Many new features in MSTR 9 Admin
 Special one: Users, Grps, Sec.Filters can be created in WEB under Admin login.

Architect: (New component in MSTR DESKTOP)
 Like BO, OBIEE tools here you can make table level relationships.
 No need to add key attributes as a child/parent.
 Its good component, this is what we were looking from MSTR.
 Still doing many testing, investigation on some of the scenarios, so will post more once I complete the analysis.

Multiple Sources:
 Multiple source can used, differentiae the tables with colors……
Metric name can be removed (no more “Metric” name in reports)

Other features;
 New data types (like NCHAR, Binary data type)
 New SQL tuning properties
 New OLAP functions
 New forecasting functions
 Temp table indexing
 Data mining functions
 Linking websites in dashboard
 Banding
 Portlet to portlet (web linking feature)
 Multi select rows, columns on the fly and do manipulations.
 Watermark in documents, reports background
 Linking report from dashboard
 Personalized Prompt Answers
 Metadata and Data can be in same DB
 Importing delivery service from NCAST to Delivery service
 64 bit-Windows supported
 64 bit web server supported
 Command manager, Object manager, Project merge, desktop license are separate now.
 Eclipse can be linked to WEB files and easy to customize the MSTR WEB 9
 Now Caching can be done at EXCEL, WORD,XML, HTML CSV format (means when you export report it can be cached at excel level)
 AND many more new features……will post when ever come across……

Email if any queries: senthil.raj.u@gmail.com

For hinding Metric column only in Web: (assuming that English language was the Locale.)

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.
Go to the line 'mstrWeb.1158'. For English language, 'Metrics' is the value.
Delete the word 'Metrics' and leave one single space.
Save the close the file.
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

Goto Grid menu nad check that Automatic Column width is disabled.
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

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

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.

It appears that someone at MicroStrategy was receptive enough to come up with the idea of including a search by ID function in version 9. It’s called… “Search by ID” (act surprised now) and it can be found under the Tools menu of the “Search for Objects” window.

This, and the new “Translate” function in MicroStrategy 9 render my “Search by ID v2” application almost obsolete. I refrain from calling it completely obsolete for the sole reason that it still offers the direct and recurring dependents export to Excel function. To the date I still haven’t found a recurring dependents search function in MicroStrategy Desktop.

By the way, since I was confronted with a case when this tool was not able to find an object, I feel compelled to add a small tech note. If the user you log in with doesn’t have the right to “see” a particular object, then of course this object won’t be found by Search by ID v2. This may happen if the object you are looking for is placed in a colleague’s personal folder, or if that object has some kind of “Deny all” permission set for your user/usergroup.

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.

Scenario:
Attribute1 is a compound key attribute with a ginormous number of values. In fact, there are so many values that when you attempt to see all its elements, you get a spool space error.

You also have a list of a few hundred elements (ID1 and ID2) belonging to this attribute and you somehow must build a report that would only show results for these elements.

Deal breaker:
As mentioned before, manually selecting the elements is out of the question. Not only does the spool space error occurs, but just imagine handpicking hundreds of values.

Having two filters, one for each ID, in which the appropriate values are entered using the “In List” option is also a bad idea. You will get much more than you expect, regardless if there is an “AND” or an “OR” operator between the two filters.

Solution:
As far as I tested, qualifying on multiple IDs of the same attribute is not possible in MicroStrategy, not even in version 9. Theoretically the element qualification is what we are looking for, but as stated before there are certain limitations.

The only solution that I can think of is to create a FreeForm SQL Report. Writing the WHERE block should be no problem, as you can generate it in MS Excel based on the two columns… something like =CONCATENATE("OR (a11.Attribute_ID1 = ",A1," AND a11.Attribute_ID2= ",B1,")").

If you know of better/faster ways, please share.

Update:
A better solution was presented to me by AK.
Simply create an additional attribute DESC form as a concatenation between the two IDs, separated by a pipeline character. From here on it gets much simpler.

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.

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:

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.
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.
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.
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.
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).
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.
MicroStrategy's Roles based (named user based) licensing strategy is very tricky for clients.
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.
There is not guarantee of free upgrades anywhere. What if MicroStrategy ask for obscene amount for future upgrades.
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.

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

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.

__________________ is responsible for the creation, formatting, transmission and administration of information services.

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

Narrowcast Server information transmitters transmit services using _________ and _________.

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

Narrowcast Administrator
Delivery Engine
Portal Administrator
Subscription Engine
Subscription Portal
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

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.

a à i, b à ii, c à iii
a à ii, b à i, c à iii
a à iii, b à i, c à ii
a à iii, b à ii, c à i

A service can have different publications each supporting a different language.

True
False

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

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

Which of the following are true?

Content information object pulls dynamic data from an information source.
Document is a complete formatted object which can have both static content and dynamic content
Document can contain only one information object
Publication is a collection of documents specifying the content of a service
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

Which of the following are true?

Information transmission module sets the rules for the types of documents supported by a publication
Locale specifies regional characteristics like Language, number, date and time formats
Device sets the formatting and transmission properties such as cell padding and embedding image support
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

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

True
False

Service Editor does not allow a user to specify multiple publications while Service Wizard allows a user to specify multiple publications.

True
False

___________________ determines the number of recipients of a service.

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

Personalized Page Execution
Personalized Report Execution
Personalized Content Execution
Both a and b
Both b and c
a, b and c

Which of the following is true?

In Personalized report execution, Narrowcast Server gathers separate prompted report result for each group of subscriptions with the same personalization.
In Personalized page execution, Narrowcast Server gathers report results from one report execution and applies personalization separately.
In Personalized page execution, Narrowcast Server gathers separate prompted report result for each group of subscriptions with the same personalization.
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

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

True
False

Event-based service can be achieved by

Having an event table
Having a temporary dummy table along with pre/post SQL statements
Both a and b
None of the above

Personalization of dynamic content exists in different forms in Narrowcast Server namely

Preferences
Authentication
Security
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

Subscription preference overrides default user preference for a subscription.

True
False

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

True
False

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

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

User can create a preference object without a question object.

True
False

A security object prompt must be present in both the question object and the information object

True
False

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.

Information object executes fine
Information object fails since the required prompt objects go unanswered
Information object executes and retrieves the complete result set
None of the above

Delivery Engine
Subscription Portal
SMTP and SMPP
i
c
a
E-mail subject, E-mail body (HTML) and E-mail attachment
System Message Viewer
iii
iii
a
b
Segment Size
a
i
b
c
ii
a
b
Security object
Preference object
b
a
b

This is a little “don’t” that I stumbled upon recently.

Don’t create metric aliases that contain operators such as “-“, “+”, and so long. Although MicroStrategy allows you to do so, the database application (Oracle, Teradata,…) will nag you about expecting “something between – and ,” and of course, the report will stop executing.

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

I've created a LinkedIn poll to know what's the most significant role you are playing in the current MicroStrategy project you are working on. Poll here.

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

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.

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.

Join and Post only MicroStrategy Jobs related news, openings in this group

microstrategyjobs@googlegroups.com

So, what’s new?
You can now export direct and recurring dependents of an object. That’s all.

Now for some background…

Direct dependents are the dependents found in MicroStrategy by right clicking on an object and selecting “Search for Dependents…”. The main difference is that Search By ID v2 exports them to an Excel file, whereas Desktop only allows the export to a non user friendly txt file.

Recurring dependents are the objects that use the source object directly or indirectly. If a metric is being used by a prompt and that prompt is being used by a report, then the prompt is a direct dependent and the report is an indirect dependent of the metric. A similar kind of search is offered by the Object Manager, if only as an indirect consequence of its use. Search by ID v2 should be easier to use for this particular feature.

Please be aware that finding and exporting recurring dependents can be a lengthy process.

You can download Search by ID v2 here.

Sunday, May 24, 2009

Friday, May 22, 2009

Friday, May 15, 2009

Tuesday, May 12, 2009

Thursday, May 07, 2009

Tuesday, April 28, 2009

Sunday, April 26, 2009

Saturday, April 25, 2009

Friday, April 24, 2009

Wednesday, April 22, 2009

Sunday, April 19, 2009

Friday, April 03, 2009

Wednesday, April 01, 2009

Tuesday, March 31, 2009

Monday, March 30, 2009

We have moved

Contributors

Quick Links

Followers

Recent Comments

Catch us on LinkedIn

Blog Archive