Monthly Archives: August 2014

Performance in Reports (Part III)

Hello there!

Today I’m going to talk about a simple technique to reduce the amount of cache used in your project.

As you may know, Microstrategy is able to cache the reports to run it much faster than normal. It’s stored in memory ram and disk. So, it reduces the amount of space of your Hard Disk and Memory RAM of your Intelligence Server machine.

The idea is pretty simple:

Create a single report to be used in more than one document.

For example, if you have to bring: category and subcategory in one report and region and city in another one, you can create 1 report that contains all of those attributes and use this report for a dashboard that contains region and city and another one that contains category and subcategory.

So, always think about creating 1 report to cover more dashboards instead of creating one report for each document.

Hope it helps.

God bless you!

Passing multiple selections to prompt

Hello there!

Today let’s talk about how to pass multiple selections to a prompt answer. I don’t know if you already tried to pass multiple values from a checkbox selector, for example, to another document/report, that not possible. You need to use URL API and answer a prompt to accomplish that.

So, to do that, you have to:

1. Create an element prompt in a report (you can create another kinds of prompt, if you want);

pic1

2. Create a non-prompt report;

pic2

3. Create a document using the non-prompt report;

pic3

4. Create a multiple selector using the check box selector, for example;

pic16

5. Create a panel stack and insert an html container inside of it;

pic5

pic6

6. Save your document and open it in MicroStrategy Web in Interactive Mode;

pic7

I always remove the title bar to help the next step. To do that, just edit the selector and in General tab, uncheck the Show title bar option:

pic8

7. Get the ID of the <span> tag. To do that, I prefer Firefox or Chrome browser. You just have to right click on the check box selector, select INSPECT ELEMENT and look for it’s <span> tag and copy the ID.

There is a pattern, first a <span> then a <div> and then a <div>, just like the image below:

pic9

In that case, the ID is K46.

<span id="K46" ty="obj" rl="3" sec="-1" name="K46" class="K46" slid="0" sty="111" sos="-1">

8. Get the link of your report/document with the prompt;

Just right click on the report/document that has the report prompt, click on Share and click on Show link. Copy that link.

pic1- pic11

In my case the link is:

http://FELIPE/MicroStrategy/asp/Main.aspx?evt=4001&src=Main.aspx.4001&reportID=1A8E595D4A765687E8DA5484F7EAFCFF&visMode=0&reportViewMode=1&server=FELIPE&Project=MicroStrategy%20Tutorial&port=0&share=1

9. Copy the link and insert one of the parameters below at the end of your link:

Parameters:

elementsPromptAnswers={&AttributeName@GUID};{&CurrentSelectionElementID:IDofSpan&}

or
elementsPromptAnswers=AttributeID;{&CurrentSelectionElementID:IDofSpan&}

10. The link should be like this:

http://FELIPE/MicroStrategy/asp/Main.aspx?evt=4001&src=Main.aspx.4001&reportID=1A8E595D4A765687E8DA5484F7EAFCFF&visMode=0&reportViewMode=1&server=FELIPE&Project=MicroStrategy%20Tutorial&port=0&share=1&elementsPromptAnswers={&[Call Center]@GUID};{&CurrentSelectionElementID:K46&}

or

http://FELIPE/MicroStrategy/asp/Main.aspx?evt=4001&src=Main.aspx.4001&reportID=1A8E595D4A765687E8DA5484F7EAFCFF&visMode=0&reportViewMode=1&server=FELIPE&Project=MicroStrategy%20Tutorial&port=0&share=1&elementsPromptAnswers=8D679D3511D3E4981000E787EC6DE8A4;{&CurrentSelectionElementID:K46&}

To get the ID of the attribute, just go to Developer/Desktop -> Right click on the attribute -> Properties and copy the ID value:

pic12

11. Now just insert an <a> tag to your link like this:

<a href=”http://FELIPE/MicroStrategy/asp/Main.aspx?evt=4001&src=Main.aspx.4001&reportID=1A8E595D4A765687E8DA5484F7EAFCFF&visMode=0&reportViewMode=1&server=FELIPE&Project=MicroStrategy%20Tutorial&port=0&share=1&elementsPromptAnswers=8D679D3511D3E4981000E787EC6DE8A4;{&CurrentSelectionElementID:K46&}target=’_blank’>Link</a>

Where:

target=’_blank’  – is responsible to open this link in a new window. If you don’t need that, just remove this parameter.

Link – Is the name that is going to be displayed in your HTML Container.

12. Double click on your HTML Container and paste the link with the <a> tag;

pic13

12. Run your dashboad in interactive mode, for example, and choose more than one element in the selector.  Click on the link!

pic14

Your report should be like this:

pic15

 

Hope it helps!

God bless you!

 

Icons!

Hello there!

Today… A quick tip!

Do you ever needed a good icon to set as your threshold and you didn’t know where to find it?

I always use  https://www.iconfinder.com/  to search for good icons. There are a lot of free and premium, if you want to buy.

That’s it. If you use other website to search for icons, please share in the comments below!

Hope it helps.

God bless you.

Beta Community

Hello there!

MicroStrategy is creating a new community and is gathering subscriptions to the beta version.

If you would like to participate, just click on the link below and send an email to them or reply the topic.

https://resource.microstrategy.com/forum/ReplyListPage.aspx?id=39399

 

God bless you!