Category Archives: MicroStrategy

Questions for Narrowcast Server Essentials


Deprecated: Function get_magic_quotes_gpc() is deprecated in /home1/microoat/public_html/blog/wp-includes/formatting.php on line 3964
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 →

Metric Aliases


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

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.

Free MicroStrategy license


Deprecated: Function get_magic_quotes_gpc() is deprecated in /home1/microoat/public_html/blog/wp-includes/formatting.php on line 3964
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 😉

ScanMD for MicroStrategy 9 launched


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

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

The biggest problem with ScanMD is it would show you tons of errors even though there is just ONE discrepancy 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.

Search by ID v2


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

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.