Thursday, August 30, 2012

What is the command to start/stop IS and Listener?



Create a script file like below to stop and start the Intelligence Server and the Microstrategy Listener and save it as "services.scp".

/*For the Intelligence Server*/
 
STOP SERVER IN "<machine name>";
 
START SERVER IN "<machine name>";
 
/* For the Listener*/
 
STOP SERVICE "MAPING" IN "<machine name>";
 
START SERVICE "MAPING" IN "<machine name>"
Construct the following command with the above script file and save it as "services.bat"

cmdmgr -n "MicroStrategy Analytics Modules" -u "Administrator" -p "password" -f 

"C:\Documents and Settings\machine\Desktop\Services.scp" -o "C:\Documents and Settings\machine\Desktop\Services.log"And you can use this .bat file to start and stop the Intelligence Server and the Listener.

Wednesday, August 29, 2012

How to enable thresholds on data markers in line graphs?

Create a report say with Year attribute and Revenue metric.
Create a threshold say if Revenue between 3500000 and 400000 then select background color as red.
Then enable the button on top left Enable thresholds on graphs.
See screenshot below

Output


How to enable/disable change journaling for a project?


The following procedure describes how administrators can enable or disable change 
journaling for all projects within a project source:

  1. In Desktop, log into a project source. The user logging in to Desktop must be granted the "Audit Change Journal" privilege.
  2. Expand Administration, and then expand System Monitors.
  3. Right-click Change Journal Transactions and select Manage Change Journal. 
  4. To enable or disable change journaling for this project source, select or clear the Enable change journaling check box.
  5. To enable or disable change journaling for all projects in the project source, select the Apply to all projects check box.
  1. If the desired action is to disable for all, but "Enable change journaling" is unchecked, 
  2. perform the following actions in this order:
    1. Check "Enable change journal" and "Apply to all projects".
    2. Click OK.
    3. Return to the Change Journal Manager.
    4. Uncheck "Enable change journal" and check "Apply to all projects"
    5. Click OK again. This will disable the change journaling for all projects if 
  3. "Enable change journaling" was not checked to begin with.
  4. Click OK. Change journaling should be enabled/disabled for each project,
depending on whether the option has been checked or unchecked.

How to create a button in a dashboard that opens another dashboard or page?

In dashboard go to Insert->HtmL Container. Inside the container paste the below code

<FORM>
<INPUT TYPE="button" value="Link" onClick="parent.location='http://www.microstrategy.com'">
</FORM>
<FORM>
<INPUT TYPE="button" value="Link" onClick="parent.location='http://www.microstrategy.com'">
</FORM>

Value - Give name of the Button here.


You can open another dashboard by placing it in the location properties.

http://localhost/microstrategy/asp/Main.aspx?evt=2048001&src=Main.aspx.2048001&visualization
Mode=0&documentID=A57512884317A663EAF10BB250C4BE09

where you need to replace the localhost by the server name and document id 

Tuesday, August 28, 2012

How to limit the number of records in a report?

1. Create a metric with definition Max(1) - Max
2. Create another metric on top of this metric Max- RunningSum(Max)
3.With the report open, add a report limit against the Running Sum metric so it only returns top five row's records.
To achieve this, go to Data > Report Data Options > Report Limit> Modify to specify the report limit definition -Rank(RunningSum) Top 5

Saturday, August 25, 2012

What is the life time of an element cache?

The Element cache is always saved in MicroStrategy Intelligence Server memory. When
 MicroStrategy Intelligence Server is restarted, this cache is purged. When the maximum memory for the element cache is full during run time, the least recently used cache is removed to make way for the newer elements added to the element cache generated cache. Also, it is possible to purge the element caches manually by using the option 'Purge Element Caches' available under the Administration -> Projects menu.

Also element caches are created per pass through login.

How to format a legends position in a flash widget?

Question:

Whenever I create a flash guage  widget, the legend is too far to the right.  Even when I horizontally expand my panel, the legend gets cut off.  Is it possible to format the position of the legend in the flash gauge widget?

Solution:

Go to the actual grid report and change to graph mode->Advanced Options->Select gauge. Then go to graph options and do the settings as per the screesnshot then you will be manually able to move the legend around in the chart.

Then use it in the document and select flash type as gauge wid
get.

Null values in metrics used in cube reports

Question:

A cube consists of 10 attributes and 10 metrics out of which few are simple metrics and few are compound metrics. When the compound metric is used in the intelligent cube report along with only 2 attributes from the cube it does not show up data but when all the 10 attributes from the cube are used they show up the right data. What needs to be done to fix this issue?


Solution:
In the metric definition edit->Subtotals/Dynamic Aggregation. Set dynamic aggregation to sum and then check

Thursday, August 23, 2012

How to hide column headers for a grid report in a document?

Go to Grid->Options. In General Tab->Header->Uncheck show column headers

How to order an Attribute in a custom fashion

Question:

I have a Month attribute which has only a desc form having values Jan, Feb, mar...These months are not getting properly ordered in the report from Jan to Dec. How to achieve this?


Solution:

Add the grid to the dashboard. Double click the grid and perform custom sorting by right clicking on the attribute->Sort option (based on MSTR version)

or 
Create another form for the attribute with the following expression

ApplySimple("case when  #='Jan' then 1 when #2='Feb' then 2 when #3='Mar' then 4....
when #0='Dec' then 12 end",Month@ID)


Then in Data->advanced sorting->Sort by the form created.

Use of a report Limit

Question:

I have a report with several filters one of which is metric is not null. I am also applying a bottom 5 ranking metric on the report.Unfortunately one of the bottom 5 is one that is filtered out because of the first filter (it's null on a particular metric). This wouldn't be a problem but my bottom 5 filter only now shows 4 values. How do I make the report to filter out the null values and then apply the rank.

Solution

Move the Bottom 5 ranking filter from report filter to a report limit. A report Filter places a where clause in the query but a report limit places a having clause.


The report limit can be applied at Data->Report Data options->Report Limit.

Wednesday, August 22, 2012

Why does group by not work in some queries with attributes and metrics?

Question:

Requirement is that I need to create a report with two attributes and 1 metric from two different tables. I created a Logical table by unioning both the tables and took out the three columns from the UNION query. I then created 2 attrubutes and 1 fact (this was eventually converted into a Sum metric). Now when I create the report, the group by for the metric works when I add one attribute and 1 metric, but does not group by when I add the second attribute. Everything works, but the group by is removed and the sum part of the metric itself is removed from the sql (in the SQL View).

Solution:

Check if in both the tables "The key specified is the true key for the warehouse table" option has been checked. IF checked then uncheck it and update the schema and then try.



This setting is applicable only when all the attributes listed as table keys in the 
logical view of the fact table.

Therefore, when checked, this setting forces to not aggregate the data and to pull only 
from the fact tables directly. 




How to find the day difference between two dates in MicroStrategy?

Create a metric and place the following definition there

sum(ApplySimple("datediff(dd,#0,#1)",[Date1],[Date2]))


where Date 1 and Date 2 are attributes

Tuesday, August 21, 2012

How do you find out the reason why a report is not being used for dynamic sourcing?


VLDB properties may be enabled in Intelligent Cube reports and user reports to include 

Dynamic Sourcing diagnostic messages in SQL View. Report designers can then view the 

messages immediately without accessing the Intelligence Server machine.

In an Intelligent Cube report, the following log is available for SQL View:
  • Cube Parse Log
In user reports, the following logs are available for SQL View:
  • Report Parse Log
  • Mismatch Log
  • Extended Mismatch Log
If the Cube Parse Log is enabled in SQL View and the Intelligent Cube is fully available for 

Dynamic Sourcing, the following will be seen at the bottom of the cube report's SQL View:

Dynamic Sourcing Logs:

Cube Parse Log:

Intelligent Cube is eligible for Dynamic Sourcing

The Cube Parse Log may identify reasons why the cube, or certain metrics within the cube, are 

not available for Dynamic Sourcing. Here, one of the required outer join properties was not 

configured:

Cube Parse Log:

Intelligent Cube is ineligible for Dynamic Sourcing

CMI_VLDB_INCOMPLETE_LOOKUP_PROBLEM
_______________________________________________________________

Error code legend:
CMI_VLDB_INCOMPLETE_LOOKUP_PROBLEM - The Intelligent Cube cannot be used for 

dynamic sourcing because of lookup table problems

To illustrate report parsing and mismatch messages, consider an Intelligent Cube containing 

the Month attribute and Revenue metric. If a user report includes Month, Revenue and Profit, 

the three logs together produce the following messages, explaining that Profit in the user 

report could not be found in any eligible cube.

Dynamic Sourcing Logs:

Report Parse Log:

Report is eligible for Dynamic Sourcing

_______________________________________________________________
Mismatch Log:
The report parsed OK, but no cubes were found to match
________________________
Could not use cube: Cube with transformation Error:
Report Metric vs Cube checks failed.
Error code: CMI_NO_GOOD_CANDIDATE_METRICS_FOUND
_______________________________________________________________
Extended Mismatch Log:
The report parsed OK, but no cubes were found to match


Monday, August 20, 2012

How does the different document sections work in MicroStrategy


I have created a sample document with year , month and the required metrics. 

In detail header I have created text boxes which is available in insert tab and typed the required column names.

In the detail section I just drag dropped the attributes and metrics from the dataset on the left and placed them correctly aligned below the static headers.
The detail section gives you one row for every attribute element 

next for the subtotals or grand totals , it needs to be placed in the detail footer. Drag drop the metrics alone in teh detail footer
and add a static text box to the left called Total.

Refer screenshots of the output.(first 3)





















Next is an example where I placed year in the group and when you do that a header and footer gets created for year apart from detail footer.

So now when I place the metrics in the year footer it creates subtotal for every year and  the metrics placed in the document footer calculates the grand total.

See screenshot 4 and 5






Rule of Thumb

1. When a metric is placed in detail section then it displays values for every row.
2. When metric is palced in document header/footer or detail header/footer then it gives grandtotals.
3. When placed in page header or footer gives page totals.
4. When metrics are placed in group header or footer it gives group subtotals

How to Enable Advanced Qualification Filter in Desktop?


Advanced qualifications allow you to create the following:

  1. Custom expressions, which are customized filter expressions. You can use Apply functions and you can create relationship filters.
  2. Joint element lists, which join attribute elements and then filter the result sets.By default, the Advanced Qualifications option is not displayed in the Filter Editor.


It can be enabled at Tools->My Preferences->Editors->Filter->Show Advanced Qualification.






Friday, August 17, 2012

How do you handle report overflow in pdf?

Question:

I have 3 datasets in which 2 of them are small reports which I placed at top portion of the document where as the third dataset is a big one and I placed this at the bottom of first two reports. All the three datasets fetch data for last 7 days. When I run this documnet in desktop and view this in pdf view the third report is overflowing to the next page, is there a way we can limit this so that it would fit in one page per a day. Third report has 150- 200 rows per a given day. In web we can scroll down the report to see all the rows but looking for a way to restrict the overflow in pdf. This document has to be delivered through email as a pdf attachment to the users.

Solution

Following are the options

1.Make the fit to 1 page setting in Page Setup of the document but this will fit all the three grids in one page. 
(Screenshot 1)

or

2. Keep 2 grids in one section. Then insert section below and place the third grid in the second section. Then force new page after first section (Screenshot 2). That way the third grid will be in another page and also make the page 1 setting.

or

3. If you want the  third grid alone to dispkay per day in pdf. Place 2 grids in one layout then Create new layout. IN that place day in grouping section as I have placed year in the grouping section of the layout(3 screenshot). Right Click on group and set the properties to page break between groups








Is it possible to view the Metadata 's schema ?

You can export the schema of Enterprise Manager by going to Schema->Export Project Schema

Attached is the screenshot.



Also you can use the architect on the Enterprise Manager to view the metadata tables and relationships

Tuesday, August 14, 2012

In Architect - what is the difference between a bold attribute and non-bold attribute in a table?

When for an attribute the corresponding table in which its bold is a lookup table then that attribute is highlighted in that table.

Is there is any way to replace a new metric in more than 1 reports by single activity?

First enable the privilege for obejcts and Project Configuration->Advanced ->Dependent Object action-Check Enable find and replace object dependencies.
Next select find and replace from Tools->Find and Replae.
Select Object dependencies
Select object to be replaced. and in type select metric.Select TEST
Select set of reports to be modified
Update Summary
Select object to be replaced with.Then give replace. Its a one shot process and very helpful 




Dashboard should show the corresponding graph according to prompt selection

Scenario:

I have a scenario where 

> The dashboard should show the corresponding graph according to prompt selection and should hide the rest of the graphs for which prompt is not selected.This should be achieved on ths same layout.
> Suppose say i have a prompt on Customer(A,B,C,....) and there is a dummy metric (1,2,3.....),

    - when customer 'A' is selecten in the prompt i have to see graph coresponding to metric1 
    - when customer 'B' is selecten in the prompt i have to see only graph coresponding to metric2 and rest of the graph should be hidden


Solution

The conditional formatting does not work on the graph itself. It works on sections for hiding an object.
Please perform the following steps

1. Add the graph to say for eg: Detail Header
2. Right click on the section and insert section below. Now the section will split into detail header 1 and detail header 2(For your eg you can split it into one more so that you get 3 sections)
3.Copy the same graph and paste it  in the section 2 within the detail header.
4. Now right click on detail header 1 i.e section 1  and place the conditional formatting and hide the object.
5.Similarly perform on all 3 sections.
6. When you run the report based on condition 2 graphs will be hidden and one will be shown but the placeholder for graph might be shown so right click on the sectio properties and check the property height can shrink.






Monday, August 13, 2012

How to search for SQL Pass-through functions and freeform sql reports?

For Free form SQL Reports:

  1. Log in to the project from Desktop and click the search button
  2. Go to Tools > Options > Enable "Show 'Contains' and 'Contained by ' tabs"
  3. Click OK > Go to "Contains" tab and select Logical Table for "Contains any object of this type" 
  4. Then go to Object Types tab and select Report as the object
  5. Click Find Now and all Freeform SQL Reports will be displayed.



For SQL Pass through function reports:

 You can look for the Applysimple function in MicroStrategy (object in Desktop and dearch for dependent objects)