Monthly Archives: October 2014

Color graphs

Hello there!

Today let’s talk about a quick fix while colorizing a graph. When you try to specify the colors of the bars in a horizontal bar graph, for example, it doesn’t change to those selected colors.

Let reproduce to problem.

1- Create a new report with Year and Cost;

pic1

2- Create a document using this report as dataset and create a Vertical Bar Graph;

pic1

3- Change the color mode to “Color by Categories“;

pic1

4- Change the color of the graph to Apex;

pic1

5- Run your document and you will see that your graph didn’t get those selected colors;

pic1

So, to make it works, you have to:

1- Change the color mode to “Color By Series“;

pic1

2- Edit your graph in Desktop/Developer and choose “Set Series by Row“;

pic1

Now when you run your document, you will see that it got the selected colors.

pic1

 

Hope it helps!

 

God bless you!

Integrating a KML/Shapefile with ESRI

Hello there!

This is going to be a quick post. I just want to paste the TN that explains how to integrate a custom shape file to ESRI in MicroStrategy 9.4.1.

This is the link: http://community.microstrategy.com/t5/Web/TN47442-How-to-create-Custom-Shapes-for-ESRI-Maps-in/ta-p/197077

Hope it helps!

 

God bless you!

Adding Outline mode to a Document in DHTML mode

Hello there!

My friend Edmar Machado sent me a cool hack to enable Outline mode in documents using Interactive Mode!

To make it works, you just have to:

1-  Edit the file styleCatalog.xml in Microstrategy Web:

For IIS: C:\Program Files (x86)\MicroStrategy\Web-Inf\XML\styleCatalog.xml

For Tomcat: C:\Program Files\Apache Software Foundation\Tomcat 7.0\webapps\MicroStrategy\WEB-INF\xml

Note that this is the default installation folder. You might have installed in a different folder.

2- Search for the style ReportOutlineModeStyle_forRW 

3- Inside this style, look for staticOutlineMode

4- Change the value parameter to False

<Style description="Style: Display Grid in outline mode within RWD"
 name="ReportOutlineModeStyle_forRW" transform="ReportOutlineModeTransform">
 <ActualParameters>
 <ActualParameter name="iframeEnabled" type="4"
 value="true" />
 <ActualParameter name="generateJSForDrillCheckBoxesForIncFetch"
 type="4" value="false" />
 <ActualParameter name="staticOutlineMode" type="4"
 value="false" />
 <ActualParameter name="showDescriptionAsTooltip"
 type="2" source="preference" value="showDescriptionAsTooltip" />
 <ActualParameter name="showSubtitle" type="1"
 source="preference" value="showSubtitle" />
 <ActualParameter name="useImagesForOutlineMode"
 type="4" source="preference" value="useImagesForOutlineMode" />
 <ActualParameter name="contextMenus" type="1"
 value="/WEB-INF/xml/config/reportCellContextMenus.xml" />
 <ActualParameter name="drillRetainParent" type="1"
 source="preference" value="drillRetainParent" />
 <ActualParameter name="drillRetainThresholds" type="1"
 source="preference" value="drillRetainThresholds" />
 <ActualParameter name="advancedDrillingContextMenuDisplay"
 type="2" value="2" />
 <ActualParameter name="sortSetNamesAndDrillPaths"
 type="4" source="preference" value="sortSetNamesAndDrillPaths" />
 <ActualParameter name="groupContextMenuDrillPathsByType"
 type="4" source="preference" value="groupContextMenuDrillPathsByType" />
 </ActualParameters>
 <Layouts>
 <Layout layout_source="AppLayoutSourceFile" order="1"><![CDATA[/WEB-INF/xml/layouts/ReportGridOnlyLayout.xml]]></Layout>
 </Layouts>
 </Style>

5- Restart your Web Server

Now you will be able to use Outline in Interactive mode!

pic

 

Hope it helps!
God bless you!

In list import in report

Hello there!

Today let’s talk about a simple but good tip: Import a list to filter a report!

Let’s suppose that you have to filter 100 elements in a report and you have those elements in a txt, csv or .xls file. To import those values you just have to:

1- Open report filter and on qualify on field choose the specific form attribute that you want to filter;

pic

2- In Operator choose In List;

pic

3- Click on Import… button and select your input file. The elements should appears like this:

pic

 

That’s it! Now you can import a list that contains all elements to filter a report.

Hope it helps!

 

God bless you!

OLAP Functions: Lag and Lead

Hello there!

Today let’s talk about two cool OLAP Functions that can help you a lot: Lag and Lead.

Let’s think that you need to divide current month / last month. Those functions can help you do that. So…

1- Create a new Metric using the Function Lag using Cost like this:

pic1

Hit Next > button.

pic1

Where the ValueList is the Cost metric, Offset is how many previous data that we want to display, so it is the relative position,  and DefaultValue is the value that you want to show when there is no data for that specific row.

Hit Next > button.

pic1

In that case, we don’t want to Break-by any attribute.

Hit Next > button.

pic1

We need to sort by Year and Month to display the correct relative data.

Hit Finish button.

The formula must be something like this: Lag<SortBy= (Year, Month) >(Cost; 1,0; 1,0)

Then, save your metric and name it as Cost Last Month.

2- Create a report with Year, MonthCost and Cost Last Month;

pic1

As you can see, we have created an Offset of 1, and now, we can divide current month / last month.

3- Create a Derived Metric using this formula: (Cost / [Cost Last Month])

pic1

Format your new metric with Fixed with 2 decimals and you will have something like this:

pic1

If you use the Lead function, it will display the next value, like this:

pic1

That’s it. Lag is for previous relative data and Lead is for the next relative value.

 

Hope it helps!

 

God bless you!

Exporting Windows System DSNs

Hello there!

Today I’m going to teach you how to backup System DSNs.

When you migrate MicroStrategy to a new machine, for example, you have to recreate all system DSNs that you had in the old machine to MicroStrategy connect to DWs and Metadata databases.

If you have a lot of DSNs configured, it could be boring create one-by-one again.

To make it easier, you can backup the System DSNs and import it to the new machines.

To do that you just have to:

1. Click Start -> Run -> type: regedit

pic1

2. Browse to: “HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\ODBC\ODBC.INI”

pic2

3. Select ODBC.INI and click “File” and then Export.

pic3

Save in a known place and paste this reg file in the new machine.

Open regedit again and click on File -> Import. Choose your .reg file and every DSN that you had will be created in target machine.

 

That’s it.

Hope it helps.

God bless you!

iOS crashing Intelligence Server

Hello there!

Today I will talk about a serious problem that I had with MicroStrategy 9.3.1 and the later version of MicroStrategy 9.4.1 iOS update 4.

I was collecting statistics for mobile in every project that I had. So, the problem is the combination of MicroStrategy 9.3.1, MicroStrategy 9.4.1 iOS update 4 and Enterprise Manager collecting mobile statistics.

When any user using iPhone or iPad tried to connect to a project, MicroStrategy Intelligence Server crashed…

To solve this problem you have to update to MicroStrategy 9.4.1 or do a workaround.

Edit the project configuration of all projects that you have, go to statistics and uncheck mobile clients (mobile clients manipulations and mobile clients location).

pic1

Restart your Intelligence Server and it will be good!

Hope it helps!

God bless you!