All posts by Senthilraj


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

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

About Senthilraj

DW BI Architect and BI Project Management (Specialized in MicroStrategy). Hobbies/Passion about photography, tennis, music, travel-trekking. Website: www.b-diamonds.com www.facebook.com/SENRAJ81 www.linkedin.com/in/senraj

Object Prompt in RS Document


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

Have you ever checked placing a report with object prompt in report service document? if so, then the object prompt won’t appear in document.

Tips:

  1. Place all the attributes (which present in object prompt) in to the report
  2. Add as a data set into report service document.
  3. Drag and drop the report(grid) into the document.
  4. Save and close the document.
  5. Open the report, remove all the attributes and place the object prompt into the same place (column or row) where attributes are placed.
  6. Save and close the report.
  7. Now, execute the document.

No wonder, it will ask you to select the attributes from the list.

Customize the ‘Total’ in MicroStrategy


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

How to customize the Total, for those present in the report?

Here is solution:

After placing required attributes and metrics in to report, run the report and once you get data go to Data Menu –> sub Totals –> Advanced –> New — > Type ‘#A total’ then do the normal total selection (like subtotal by row, etc, etc).

Now, the total appear as ‘ Attributename Total’ for each total.

Some more tips on custom totals:

#A
The name of the attribute under which the subtotal appears.
#P
The name of the attribute to the left of, or above the attribute under which the subtotal appears.
#0
All the forms of the parent element.
#1
The first form of the parent element reading from left to right or from top to bottom.
#2
The second form of the parent element reading from left to right or from top to bottom.
#3
The third form of the parent element reading from left to right or from top to bottom.
#4
The fourth form of the parent element reading from left to right or from top to bottom.

Note: single Quotes to highlight, dont give the same in report :)

MicroStrategy Object Tracking Tool


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

I have created MicroStrategy Object Tracking Tool (beta) for easy preparation of tracking sheet in a Excel. You can customize it by selecting date (creation, modification, from , to date, select number of object type. This toll is still beta. I made it as there are not way to achieve Version control in MicroStrategy. Looking for your suggestion to improve it and add more features. You can send me your comment by email or this blog. Utmost care is taken that this application doesn’t mess up with your metadata. I’ve used this application with production system in past.

This is a read only application. Using it will cause no changes to your Metadata.

Note:  This application is provided “as is” and I disclaim all warranties, whether express or implied, with respect to all provided items, including all warranties of merchantability, fitness for a particular purpose, accuracy, systems integration, title, satisfactory quality and non-infringement. I do not warrant that use of the provided items or any portion thereof will be uninterrupted or error-free, or that the provided items or any portion thereof will meet any need or requirement of licensee.