Monthly Archives: March 2015

Removing Auto Apply changes in Page-by

Hello there!

Today I’m going to show you how to remove the auto apply changes made in a Page-by in a report for Web.

When you put an attribute in a page-by section of your report, and changes to a different element, it will automatically apply that change.

To change that behavior inserting an apply button, you just have to:

1. Enter in you project in MicroStrategy Web;

2. Go to Preferences;

pic

3. Go to Project Defaults -> Grid Display -> Uncheck “Automatic page-by”.

pic

Now when you put an attribute in Page-by you will see a button like this:

pic

Hope it helps!

God bless you!

How to change the default messages for blank rows in grid/graphs

Hello there!

Today I’m going to show you have to change the default blank message: No data returned for this view. This might be because the applied filter excludes all data.

You just have to:

1. Go to Desktop/Developer;

2. Log using Administrator;

3. Right click on the project and go to Project Configuration

pic

4. Go to Report Definition -> Advanced;

5. Fill the text Area with some text. This text is going to be used when you don’t have rows for a grid/graph.

pic

You can also hide the document grid if you want.

Restart your Intelligence Server and Web Server.

That’s it.

Hope it helps!

God bless you!

4.

Try Big Data now

Hello there!

If you want to try Cloudera, Hive, Pig, HBase you can try if for free with no installation in:

http://go.cloudera.com/cloudera-live.html

You just have to fill a form with you corporate email and you will be able to some Big Data features right on your browser for free.

Hope it helps!

God bless you!

 

Erasing custom formats

Hello there!

Today I’m going to talk about how to remove custom formats that you created to format the values.

When you add a new custom format in MicroStrategy it says there until you remove in regedit.

pic

To remove those custom formats, you just have to:

1. Go to regedit (Start -> Execute -> write regedit and hit enter)

2. Go to:  HKEY_CURRENT_USER\Software\MicroStrategy\DSS Agent\Formatting Properties Dialog in the Custom_Formatting_X Key

3. Erase the Custom_formatting_x registries.

pic

Now when you won’t see that custom format in MicroStrategy anymore.

pic2

That’s it.

Hope it helps!

God bless you!

PHP Function for get a session using TASK API with IIS

Hello there!

I’ve created a PHP function to help you create a session using TASK API for PHP with IIS.

Here is the code:

<?php

function authenticationMSTR($server, $project, $user, $pass, $documentId, $dashboardMode) {
$projectUrl = str_replace(" ","%20",$project);
$projectTask = str_replace(" ","+",$project);
$username = 'username';
$password = 'password';

$context = stream_context_create(array(
'http' => array(
'header' => "Authorization: Basic " . base64_encode("$username:$password")
)
));

$url = file_get_contents("http://$server/MicroStrategy/asp/TaskAdmin.aspx?
taskId=getSessionState&taskEnv=xml&taskContentType=xml&server=$server&project=$
projectTask&uid=$user&pwd=$pass");

$data=simplexml_load_string($url);

foreach($data->children() as $child) {
foreach($child->children() as $child1) {
$sessionmstr = $child1;
break;
}
}

echo "http://$server/MicroStrategy/asp/Main.aspx?evt=2048001&src=Main.aspx.2048001&visMode=0&currentViewMedia=$dashboardMode&documentID=$documentId&server=$server&Project=$projectUrl&port=0&share=1&hiddensections=header,path,dockTop,dockLeft,footer&usrSmgr=$sessionmstr";
}
}
?>

Where:

$server: is your server ip/dns
$project: Name of the project
$user: MicroStrategy Username
$pass: MicroStrategy Username Password 
$documentId: Document ID
$dashboardMode: View media. Example: Use 8 for flash and 2 for DHTML.
$username = Put the Username for login in your TaskAdmin page. 
$password = Put the password for the Username used to login in TaskAdmin page.

Just save this in a file as Authentication.php. Now create another file like this:

<?php
include "Authentication.php";
?>
<html>
<head>
<title>Title</title>
<?php header("Content-Type: text/html; charset=ISO-8859-1",true);?>
</head>

</html>

Just use your own info in those above parameters.

Save this file as test.php in the same folder that you saved your Authentication.php.
Those files must be saved inside your Apache PHP folder. If you use Xampp, is must be saved inside the htdocs folder.

Open test.php in your browser and you will see your dashboard!

 

Hope it helps!

God bless you!

How to show the parameters set in metrics

Hello there!

Today I’m going to teach you a quick tip that can help you see the parameters that were set in a metric.

The default behavior of MicroStrategy is the hide all parameters set for your metrics. it’s much better to see everything that you are using.

To do that you just have to:

1. Open Developer/Desktop and edit a metric

2. Go to Views -> Show Function Parameters

pic

Now you will see every parameter that you metric have.

pic

 

Hope it helps!

God bless you!

Configuring Google Maps for MicroStrategy

Hello there!

Today I’m going to teach you how to configure Google Maps API for MicroStrategy.

To do that you have to:

1. Go to: https://code.google.com/apis/console

2. Click on API and Authentication and click on APIs

pic

* Sorry because mine is in Portuguese.

3. Look for: Google Maps JavaScript API v3

4. Click on Google Maps JavaScript API v3 and Enable it

pic

5. Click on Credentials in the API and Authentication menu

pic

6. Click on the button: Create new key

pic

7. Use the browse key

pic

8. If you use ASP.NET you must insert this URL:

  • http://SERVERNAME/MicroStrategy/asp/Main.aspx*

If you use J2EE:

  • http://SERVERNAME:PORTNUMBER/MicroStrategy/servlet/mstrWeb*

In my case I’ve used for ASP.NET:

And for J2EE:

Now you have an API KEY!

9. Go to C:\Program Files (x86)\MicroStrategy\GISConnectors\GoogleMap (default MSTR Installation folder)

10. If you use ASP.NET open the ConnectorForGoogleMap_ASP folder and copy the folder: ConnectorForGoogleMap to your plugin folder of your Web ASPx folder.

In my case:

C:\Program Files (x86)\MicroStrategy\Web ASPx\plugins

pic

If  you use Tomcat, use the ConnectorForGoogleMap folder that is inside the ConnectorForGoogleMap folder. Paste this second ConnectorForGoogleMap folder inside your Webapps/MicroStrategy/plugin folder.

11. Open this pasted Google Maps plugin folder and browse to: ConnectorForGoogleMap\WEB-INF\xml\config\google

12. Edit the googleConfig.xml file

13. Change the tag:

<mk isPremier=”true”>InvalidPremierKey</mk> 

to:

<mk isPremier=”false”>YOUR GOOGLE MAPS API KEY</mk>

Example:

<mk isPremier=”false”>AIzGSCird6Wo5TFLASD2_UoVfembPd4</mk>  (it is not a valid key)

14. Restart your IIS or J2EE Web Server.

Now you can use Google Maps for MicroStrategy.

Hope it helps!

God bless you!