<!DOCTYPE HTML PUBLIC "-//IETF//DTD HTML//EN">
<html>
<head>
    <title>Intelligencia Knowledge Base</title>
    <style type="text/css">
        h1
        {
            font-family: Verdana;
            font-size: 12pt;
            font-weight: bold;
        }
        body
        {
            font-family: Verdana;
            font-size: 9pt;
        }
        .title
        {
            font-family: Verdana;
            font-size: 11pt;
            color: Blue;
        }
        .abstract
        {
            font-family: Verdana;
            font-size: 9pt;
        }
        .link
        {
            font-family: Verdana;
            font-size: 9pt;
            color: Green;
        }
    </style>
</head>

<script type="text/javascript">
<!--
    var fActiveMenu = false;
    var oOverMenu = false;

    function mouseSelect(e) {
        if (fActiveMenu) {
            if (oOverMenu == false) {
                oOverMenu = false;
                document.getElementById(fActiveMenu).style.display = "none";
                fActiveMenu = false;
                return false;
            }
            return false;
        }
        return true;
    }

    function menuActivate(idEdit, idMenu, idSel) {
        if (fActiveMenu) return mouseSelect(0);

        oMenu = document.getElementById(idMenu);
        oEdit = document.getElementById(idEdit);
        nTop = oEdit.offsetTop + oEdit.offsetHeight;
        nLeft = oEdit.offsetLeft;
        while (oEdit.offsetParent != document.body) {
            oEdit = oEdit.offsetParent;
            nTop += oEdit.offsetTop;
            nLeft += oEdit.offsetLeft;
        }
        oMenu.style.left = nLeft;
        oMenu.style.top = nTop;
        oMenu.style.display = "";
        fActiveMenu = idMenu;
        document.getElementById(idSel).focus();
        return false;
    }

    function textSet(idEdit, text) {
        document.getElementById(idEdit).value = text;
        oOverMenu = false;
        mouseSelect(0);
        document.getElementById(idEdit).focus();
    }

    function comboKey(idEdit, idSel) {
        if (window.event.keyCode == 13 || window.event.keyCode == 32)
            textSet(idEdit, idSel.value);
        else if (window.event.keyCode == 27) {
            mouseSelect(0);
            document.getElementById(idEdit).focus();
        }
    }

    function search() {

        for (i = 0; i < searchtable.childNodes(0).childNodes.length; i++) {
        
            element = searchtable.childNodes(0).childNodes(i);
            element.style.display = "none"; // start by hiding the element

            index = element.id;
            prodsearch = false;
            levelsearch = false;
            keywordsearch = false;

            // Product Search
            if (prodcombotext.value != null && prodcombotext.value.length > 0) {
                prodsearch = true;
                products = document.getElementById("products" + index).value;
                switch (prodcombotext.value) {
                    case "All Products (Query Builder)":
                        if (products.indexOf("ALL") >= 0) {
                            element.style.display = "";
                        }
                        break;
                    case "Intelligencia for Office":
                        if (products.indexOf("I4W") >= 0 | products.indexOf("I4XL") >= 0) {
                            element.style.display = "";
                        }
                        break;
                    case "Intelligencia for Word":
                        if (products.indexOf("I4W") >= 0) {
                            element.style.display = "";
                        }
                        break;
                    case "Intelligencia for Excel":
                        if (products.indexOf("I4XL") >= 0) {
                            element.style.display = "";
                        }
                        break;
                    case "Developer Tools":
                        if (products.indexOf("IQ") >= 0 | products.indexOf("IDC") >= 0 | products.indexOf("IOC") >= 0) {
                            element.style.display = "";
                        }
                        break;
                    case "Intelligencia Query":
                        if (products.indexOf("IQ") >= 0) {
                            element.style.display = "";
                        }
                        break;
                    case "Intelligencia Desktop Client":
                        if (products.indexOf("IDC") >= 0) {
                            element.style.display = "";
                        }
                        break;
                    case "Intelligencia Olap Controls":
                        if (products.indexOf("IOC") >= 0) {
                            element.style.display = "";
                        }
                        break;
                }
            }

            // Level Search
            if (levelcombotext.value != null & levelcombotext.value.length > 0) {
                levelsearch = true;
                levels = document.getElementById("level" + index).value;
                switch (levelcombotext.value) {
                    case "Basic":
                        if (levels == "basic")
                            element.style.display = "";
                        else
                            element.style.display = "none";
                            break;
                    case "Intermediate":
                        if (levels == "intermediate")
                            element.style.display = "";
                        else
                            element.style.display = "none";
                        break;
                    case "Advanced":
                        if (levels == "advanced")
                            element.style.display = "";
                        else
                            element.style.display = "none";
                        break;
                    default:
                        element.style.display = "none";
                        break;
                }
            }

            // String Search
            if (searchtext.value != null & searchtext.value.length > 0) {
                keywordsearch = true;
                
                // If we are doing a product or level search and the item was not found then bail
                if (((prodcombotext.value != null && prodcombotext.value.length > 0) |
                    (levelcombotext.value != null & levelcombotext.value.length > 0)) &
                    element.style.display == "none") {
                    // do nothing
                }
                else {
                    s = searchtext.value.split(" ");
                    found = false;
                    for (j = 0; j < s.length; j++) {
                        if (document.getElementById("title" + index).outerText.toLowerCase().indexOf(s[j].toLowerCase()) >= 0)
                            found = true;
                        else if (document.getElementById("abstract" + index).outerText.toLowerCase().indexOf(s[j].toLowerCase()) >= 0)
                            found = true;

                        if (found) {
                            if (element.style.display != "")
                                element.style.display = "";
                        }
                        else {
                            if (element.style.display == "")
                                element.style.display = "none";
                        }
                    }
                }
            }
            
            if(prodsearch == false & levelsearch == false & keywordsearch == false)
            element.style.display = "";
        }
    }
    document.onmousedown = mouseSelect;
//--></script>

<body>
    <table>
        <tr>
            <td style="text-align: right"><img alt="" src="../images/3DLogoLight.png" style="border: 0" /></td>
        </tr>
    </table>
    <h1>Intelligencia Knowledge Base</h1>
    <p>Search the knowledge base for articles and videos on how to use Intelligencia software. 
        From this page you can select your product, level of expertise and enter search 
        criteria</p>
    <table align="center" style="border: solid 1 black; border-collapse: collapse; width: 90%; background-color: #EEFFFF;">
        <tr>
            <td>
                <table style="border-collapse: collapse; margin-left: 6px; padding: 0">
                    <tr style="height: 6px">
                        <td colspan="4" style="font-size: 1pt">
                        &nbsp;
                        </td>
                    </tr>
                    <tr>
                        <td style="vertical-align: middle">
                            <span style="font-family: sans-serif; font-size: 10pt">Product:&nbsp;</span>
                        </td>
                        <td>
                            <input type="text" id="prodcombotext" size="20" style="width: 200; border: solid 1 darkgray" /><input
                                type="button" value="▼" style="height: 20; width: 20; font-family: helvetica;
                                font-size: 8pt; border: solid 1 darkgray" onclick="JavaScript:menuActivate('prodcombotext', 'prodcombodiv', 'prodcombosel')" />
                            <div id="prodcombodiv" style="position: absolute; display: none; top: 0px; left: 0px;
                                z-index: 10000" onmouseover="javascript:oOverMenu='prodcombodiv';" onmouseout="javascript:oOverMenu=false;">
                                <select size="5" id="prodcombosel" style="width: 220; border-style: none" onclick="JavaScript:textSet('prodcombotext',this.value);"
                                    onkeypress="JavaScript:comboKey('prodcombotext', this);">
                                    <option value=""></option>
                                    <option value="All Products (Query Builder)">All Products (Query Builder)</option>
                                    <option value="Intelligencia for Office">Intelligencia for Office</option>
                                    <option value="Intelligencia for Word">&nbsp;&nbsp;Intelligencia for Word</option>
                                    <option value="Intelligencia for Excel">&nbsp;&nbsp;Intelligencia for Excel</option>
                                    <option value="Intelligencia Query">Developer tools</option>
                                    <option value="Intelligencia Query">&nbsp;&nbsp;Intelligencia Query</option>
                                    <option value="Intelligencia Desktop Client">&nbsp;&nbsp;Intelligencia Desktop Client</option>
                                    <option value="Intelligencia Desktop Client">&nbsp;&nbsp;Intelligencia Olap Controls</option>
                                </select>
                            </div>
                        </td>
                        <td style="vertical-align: middle">
                            <span style="font-family: sans-serif; font-size: 10pt">Level:&nbsp;</span>
                        </td>
                        <td>
                            <input type="text" id="levelcombotext" size="20" style="width: 200; border: solid 1 darkgray" /><input
                                type="button" value="▼" style="height: 20; width: 20; font-family: helvetica;
                                font-size: 8pt; border: solid 1 darkgray" onclick="JavaScript:menuActivate('levelcombotext', 'levelcombodiv', 'levelcombosel')" />
                            <div id="levelcombodiv" style="position: absolute; display: none; top: 0px; left: 0px;
                                z-index: 10000" onmouseover="javascript:oOverMenu='levelcombodiv';" onmouseout="javascript:oOverMenu=false;">
                                <select size="5" id="levelcombosel" style="width: 220; border-style: none" onclick="JavaScript:textSet('levelcombotext',this.value);"
                                    onkeypress="JavaScript:comboKey('levelcombotext', this);">
                                    <option value=""></option>
                                    <option value="Basic">Basic</option>
                                    <option value="Intermediate">Intermediate</option>
                                    <option value="Advanced">Advanced</option>
                                </select>
                            </div>
                        </td>
                    </tr>
                    <tr style="height: 4px">
                        <td colspan="4" style="font-size: 1pt">
                        &nbsp;
                        </td>
                    </tr>
                    <tr>
                        <td>
                            <span style="font-family: sans-serif; font-size: 10pt">Search for:&nbsp;</span>
                        </td>
                        <td colspan="2">
                            <input type="text" id="searchtext" size="20" style="width: 400; border: solid 1 darkgray" />
                        </td>
                        <td style="text-align: right">
                                <input type="button" value="Search" style="height: 20; width: 100; font-family: helvetica;
                                    font-size: 10pt; border: solid 1 darkgray" onclick="JavaScript:search()" />
                        </td>
                    </tr>
                    <tr style="height: 6px">
                        <td colspan="4" style="font-size: 1pt">
                        &nbsp;
                        </td>
                    </tr>
                </table>
            </td>
        </tr>
    </table>
    <br />
    <br />
    <table id="searchtable" align="center" style="width: 90%">
        <tr id="0" style="display: none">
            <td>
                <table>
                    <tr>
                        <td id="title0" class="title">
                            Asymmetric Query - Grand Total
                            <input id="products0" type="hidden" value="ALL" />
                            <input id="level0" type="hidden" value="intermediate" />
                        </td>
                    </tr>
                    <tr>
                        <td id="abstract0" class="abstract">
                            Product: All Products<br />
                            Level: Intermediate<br />
                            Keywords: asymmetric, hide, suppress, total<br />
                            <br />
                            This example describes how to create a grand total for a report which contains 2 or more nested hierarchies on an axis.<br />
                        </td>
                    </tr>
                    <tr>
                        <td id="link0">
                            <table>
                                <tr>
                                    <td><a href="documents/AsymmetricQuery_GrandTotal.pdf" target="_blank"><img alt="" src="../images/pdf.gif" style="border: none" /></a></td>
                                    <td><a href="documents/AsymmetricQuery_GrandTotal.pdf" class="link" target="_blank">AsymmetricQuery_GrandTotal.pdf</a></td>
                                </tr>
                            </table>
                        </td>
                    </tr>
                </table>
            </td>
        </tr>
        <tr id="1" style="display: none">
            <td>
                <table>
                    <tr>
                        <td id="title1" class="title">
                            Expander
                            <input id="products1" type="hidden" value="IQ" />
                            <input id="level1" type="hidden" value="intermediate" />
                        </td>
                    </tr>
                    <tr>
                        <td id="abstract1" class="abstract">
                            Product: Intelligencia Query<br />
                            Level: Intermediate<br />
                            Keywords: IQ, expand, collapse, drilldown<br />
                            <br />
                            Example showing how to create a report which allows the end user to navigate data by expanding/collapsing.
                        </td>
                    </tr>
                    <tr>
                        <td id="link1">
                            <table>
                                <tr>
                                    <td><a href="documents/Expander.pdf" target="_blank"><img alt="" src="../images/pdf.gif" style="border: none" /></a></td>
                                    <td><a href="documents/Expander.pdf" class="link" target="_blank">Expander.pdf</a></td>
                                </tr>
                            </table>
                        </td>
                    </tr>
                </table>
            </td>
        </tr>
        <tr id="2" style="display: none">
            <td>
                <table>
                    <tr>
                        <td id="title2" class="title">
                            Percentage of Total (Simple)
                            <input id="products2" type="hidden" value="ALL" />
                            <input id="level2" type="hidden" value="intermediate" />
                        </td>
                    </tr>
                    <tr>
                        <td id="abstract2" class="abstract">
                            Product: All Products<br />
                            Level: Intermediate<br />
                            Keywords: calculation, spreadsheet, percentage<br />
                            <br />
                            Example showing how to create a report which shows the percentage contribution of a group of child members with respect to their parent.
                        </td>
                    </tr>
                    <tr>
                        <td id="link2">
                            <table>
                                <tr>
                                    <td><a href="documents/PercentageOfTotal(Simple).pdf" target="_blank"><img alt="" src="../images/pdf.gif" style="border: none" /></a></td>
                                    <td><a href="documents/PercentageOfTotal(Simple).pdf" class="link" target="_blank">PercentageOfTotal(Simple).pdf</a></td>
                                </tr>
                            </table>
                        </td>
                    </tr>
                </table>
            </td>
        </tr>
        <tr id="3" style="display: none">
            <td>
                <table>
                    <tr>
                        <td id="title3" class="title">
                            Percentage of Total (Multi Level)
                            <input id="products3" type="hidden" value="ALL" />
                            <input id="level3" type="hidden" value="intermediate" />
                        </td>
                    </tr>
                    <tr>
                        <td id="abstract3" class="abstract">
                            Product: All Products<br />
                            Level: Intermediate<br />
                            Keywords: calculation, spreadsheet, percentage<br />
                            <br />
                            Example showing how to create a report which shows the percentage contribution of a group of child members with respect to their parent which will work over a multi-level hierarchy.
                        </td>
                    </tr>
                    <tr>
                        <td id="link3">
                            <table>
                                <tr>
                                    <td><a href="documents/PercentageOfTotal(MultiLevel).pdf" target="_blank"><img alt="" src="../images/pdf.gif" style="border: none" /></a></td>
                                    <td><a href="documents/PercentageOfTotal(MultiLevel).pdf" class="link" target="_blank">PercentageOfTotal(MultiLevel).pdf</a></td>
                                </tr>
                            </table>
                        </td>
                    </tr>
                </table>
            </td>
        </tr>
        <tr id="4" style="display: none">
            <td>
                <table>
                    <tr>
                        <td id="title4" class="title">
                            Where is that Option?
                            <input id="products4" type="hidden" value="ALL" />
                            <input id="level4" type="hidden" value="advanced" />
                        </td>
                    </tr>
                    <tr>
                        <td id="abstract4" class="abstract">
                            Product: All Products<br />
                            Level: Intermediate<br />
                            Keywords: distinct, hierarchize, addcalculatedmembers, non empty, non empty behavior<br />
                            <br />
                            If you are familiar with MDX but new to Intelligencia you may want to locate a feature that implements a specific MDX function 
                            or expression. Because the Investigator interface is designed to prevent end-users from having to understand MDX it may not be 
                            obvious where to look. This document describes where to find certain MDX features in the interface.
                        </td>
                    </tr>
                    <tr>
                        <td id="link4">
                            <table>
                                <tr>
                                    <td><a href="documents/WhereIsThatOption.pdf" target="_blank"><img alt="" src="../images/pdf.gif" style="border: none" /></a></td>
                                    <td><a href="documents/WhereIsThatOption.pdf" class="link" target="_blank">WhereIsThatOption.pdf</a></td>
                                </tr>
                            </table>
                        </td>
                    </tr>
                </table>
            </td>
        </tr>
     </table>
</body>
</html>