Tag Archives: selector

Dropdown with multiple selections

Hello there,

Today I’m going to show a hack of  how to allow multiple selections using a dropdown.

Felipe César sent me that tip. Thank you, Felipe. I really appreciate that.

To create this dropdown you will need to:

  1. Create a Dropdown selector as usual;
  2. Right click on the selector and select Properties and formatting;
  3. Go the Layout and select from the DHTML style “Listbox” and check “Allow multiple selections”
  4. Go to Theme and select Light Theme
  5. Go back to Layout and select Dropdown
  6. Go back to Theme and select None
  7. Click OK and you will have something like this:

Hope it helps.

God bless you!

Difference between filter and slice in selectors

Hello there!

Today let’s talk about the difference between Filter and Slice when filtering in documents.

You can see the option to in Selector tab in Properties of the selector.

pic1

If you check Apply selection as filter all targets are going to be filtered using Filter, if you uncheck, all targets will use Slice.

You can also click on “Manual Targets” button and choose for each target, which kind of filter use.

pic2

 

Let’s keep it simple. If you select Slice, the aggregation is made when opening the document. If you select Filter, the aggregation is made when you change the filter. So…

When using Slice:

1. You have everything preprocessed and you won’t have delays when changing an element in a selector;

2. Your document runs slower than using Filter, because it creates all aggregations when the document is been processed. It stores all the content within the document, so it doesn’t need to create new aggregations when changing the selector element.

3. The aggregation is made using all the attributes of the source dataset instead of the attributes included in the grid/graph. So, if you have Region, Year and Cost in source dataset and in your grid you only have Region and Cost, MicroStrategy will aggregate it using Region, Year and Cost.

Here is an example:

Using Slice:

pic1

As you can see, I have Year and Cost in Grid and Region in the selector. MicroStrategy will not summarize all Regions by Year, it will repeat the years for every Region selected, because as I told before, the aggregation uses Region and Year. Think that you have an invisible Region in the grid template.

Using Filter:

pic1

Here MicroStrategy will aggregate the Cost metric only using Year and filter using Region. So, you will see a sum of all Regions by Year.

 

4. It’s good for caching and exporting. Because all data is included in your document. So, if you export a document in Flash, you will be able to change the selector without receiving an error message.

When using Filter:

1. Your document runs much faster because it only aggregates the data using the selected elements in the selectors. But, every time that you change a single element in a selector, MicroStrategy has to aggregate the data at runtime, so it can delay much more time to change element than using slice, that is already aggregated and runs instantly*;

2.  The size of your exported document is lighter than using slice, but it only stores data of the selected elements of the selectors;

3. It aggregates using the attributes of your grid/graph. So, if you have Region, Year and Cost in the source dataset and create a grid with Year and Cost, it will summarize Cost only by Year, as the image above shows;

4. It’s not so good for caching and exporting.  If you export to a Flash file, you won’t be able to change the selectors elements;

 

That’s it.

Hope it heps.

 

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!