Deprecated: Function get_magic_quotes_gpc() is deprecated in /home1/microoat/public_html/blog/wp-includes/load.php on line 607
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 2042 Senthilraj | MicroStrategy101 | Page 5 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
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
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
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
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
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
View 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 DefectSenthilraj
Critical Issue Alert: MicroStrategy 9.0.0 Hotfix 2 can cause instability or folder access problems
Please refer to the following technical notes for more details:
TN 31747 – In MicroStrategy 9.0.0 HF2, when trying to open a folder, M8MulPrc_32 or MJMulPrc are continuously spawned and the client application hangs
TN 31658 – “Invalid procedure call or argument” error message appears when trying to access a folder in MicroStrategy 9.0.0 after a migration with Object Manager 9.0.0 HF2
Both issues are corrected in MicroStrategy 9.0.0 Hotfix 3. Customers who are on 9.x are urged to upgrade to this latest Hotfix that is available on the MicroStrategy Download Site.
MicroStrategy Product Releases
MicroStrategy 9.0.0 Hotfix 3
MicroStrategy 9.0.0 Hotfix 3 is now generally available on the MicroStrategy Download Site to licensed customers. This is a maintenance release for customers currently running the 9.0.x version of the software. This release contains new issue corrections, as well as all corrections provided in the earlier 9.0.0 Hotfix 1 and 9.0.0 Hotfix 2 releases. In particular, Hotfix 3 addresses the two critical issues that may affect the stability and folder accessibility of the MicroStrategy environment as described in the technical notes TN 31747 and TN 31658. The Readme is available in the MicroStrategy Knowledge Base.
Deprecated: Function get_magic_quotes_gpc() is deprecated in /home1/microoat/public_html/blog/wp-includes/formatting.php on line 3964 Narrowcast ServerSenthilraj
In Narrowcast Server, when you use report in EXCEL document, instead of normal report output; you can customize the output result based on your own design by modifying default Narrowcast XSLT.
In order to design Narrowcast XSLT, first we need to understand the Report XML and its content present in XML file.
How to get the get the report xml:
Run the corresponding report in the WEB.
In the Address Bar, enter ‘&XML=1’ at the end of the URL as shown below.
Right click in Browser and Select the ‘ViewSource’ option.
Search for ‘<mi’ in the Source and starting from the ‘<mi’ tag copy till end tag (i.e) ‘mi>’.
Paste the copied text in notepad and save it in ‘.xml’ file.
Note: Report data Tag starts with <RH>
Narrowcast XSLT’s and Tags specific to spreadsheet
Note: All aspects of this XML specification, including element (tag) names, attribute names, and attribute values are case sensitive. •
The pt-container is the root level of every Excel XML document element that contains the table tag. This tag is required.
The table tag contains both content and formatting tags for turning data into a well-formatted grid. The resulting grid overwrites a contiguous rectangle of cells in an Excel workbook when an Excel document is rendered. An Excel XML document element can contain only one table tag.
The fonts tag contains the set font definitions that control the font characteristics of cells written into the Excel workbook. Font definitions include font type, color, size, weight, and modifiers like italic. An Excel XML document element can contain only one fonts tag.
The font tag contains the definition of a specific font used for this document element. Zero or more font tags are required.
The styles tag contains the set style definitions that control cell formatting for cells written into the Excel workbook. Style definitions include all font characteristics as well as background color, orientation, alignment, and borders. An Excel XML document element can contain only one styles tag.
The style tag contains the definition of a specific style that is used for this document element. Zero or more style tags are required.
The formats tag contains the set of format strings that are used to format date, time, and numeric cell contents. An Excel XML document element can contain only one formats tag.
The format tag contains the definition of a specific format string that is used for this document element. Zero or more format tags are required.
Each row in a table contains cells. A blank row can be represented by the inclusion of a row containing an empty cell. One or more row tags are required.
Each cell in a row contains the data that should be placed into the corresponding cell in the resulting grid. One or more cell tags are required.
Sample Report output and used to design the XSL
Country
Region
Revenue
USA
Northeast
$2,334,864
Mid-Atlantic
$3,413,340
Southeast
$2,016,186
Central
$1,773,270
South
$1,380,991
Northwest
$1,485,182
Southwest
$2,816,334
Web
Web
$1,716,267
Sample XSL created for the above Report (you can take default Narrowcast XSL and Modify the content except parent tags)
Output for the above Report along with the XSL
1) Save the above XSLT
2) Insert the XSLT as XSL file in Narrowcast Server
3) In the documents, while mapping report in EXCEL document; Map this XSLT for the particular report
4) complete the service (as we do normally)
5) Run the service, you will get the customized output
Deprecated: Function get_magic_quotes_gpc() is deprecated in /home1/microoat/public_html/blog/wp-includes/formatting.php on line 3964 ArchitectSenthilraj
Error: Cannot save or move object `System Hierarchy` with id ‘xxxx’ and type ‘Hierarchy’.
Symptoms: When try to create/modify new attribute the above error occurs.
Solution: Download ScanMD (8x), You can use the ScanMD (8x) for version 9 also.
1. Start ScanMD
2. Go to Step 3, and click “Add test”
3. Select TQMS357866.dll
And continue the ScanMD process, Now the above error will get fixed.
Suggestions: Don’t create/modify Schema object in parallel.
Notice: compact(): Undefined variable: groupby in /home1/microoat/public_html/blog/wp-includes/class-wp-comment-query.php on line 821
Warning: count(): Parameter must be an array or an object that implements Countable in /home1/microoat/public_html/blog/wp-includes/class-wp-comment-query.php on line 399
Notice: compact(): Undefined variable: limits in /home1/microoat/public_html/blog/wp-includes/class-wp-comment-query.php on line 821
Notice: compact(): Undefined variable: groupby in /home1/microoat/public_html/blog/wp-includes/class-wp-comment-query.php on line 821
Deprecated: Function get_magic_quotes_gpc() is deprecated in /home1/microoat/public_html/blog/wp-includes/formatting.php on line 3964
Notice: compact(): Undefined variable: limits in /home1/microoat/public_html/blog/wp-includes/class-wp-comment-query.php on line 821
Notice: compact(): Undefined variable: groupby in /home1/microoat/public_html/blog/wp-includes/class-wp-comment-query.php on line 821
Deprecated: Function get_magic_quotes_gpc() is deprecated in /home1/microoat/public_html/blog/wp-includes/formatting.php on line 3964
Notice: compact(): Undefined variable: limits in /home1/microoat/public_html/blog/wp-includes/class-wp-comment-query.php on line 821
Notice: compact(): Undefined variable: groupby in /home1/microoat/public_html/blog/wp-includes/class-wp-comment-query.php on line 821
Deprecated: Function get_magic_quotes_gpc() is deprecated in /home1/microoat/public_html/blog/wp-includes/formatting.php on line 3964
Notice: compact(): Undefined variable: limits in /home1/microoat/public_html/blog/wp-includes/class-wp-comment-query.php on line 821
Notice: compact(): Undefined variable: groupby in /home1/microoat/public_html/blog/wp-includes/class-wp-comment-query.php on line 821
Deprecated: Function get_magic_quotes_gpc() is deprecated in /home1/microoat/public_html/blog/wp-includes/formatting.php on line 3964
Notice: compact(): Undefined variable: limits in /home1/microoat/public_html/blog/wp-includes/class-wp-comment-query.php on line 821
Notice: compact(): Undefined variable: groupby in /home1/microoat/public_html/blog/wp-includes/class-wp-comment-query.php on line 821
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
Deprecated: Function get_magic_quotes_gpc() is deprecated in /home1/microoat/public_html/blog/wp-includes/formatting.php on line 3964