GlobalCube
/
analytics


			
							123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326
							<!--

*****************************************************************

** Licensed Materials - Property of IBM

**

** IBM Cognos Products: drill

**

** (C) Copyright IBM Corp. 2001, 2010

**

** US Government Users Restricted Rights - Use, duplication or 

** disclosure restricted by GSA ADP Schedule Contract with 

** IBM Corp.

*****************************************************************

-->
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta name="generator" content=

"HTML Tidy for Windows (vers 1st July 2003), see www.w3.org">
<title>Selection Context Library Test Page</title>

<script language="javascript" src=

"http://localhost/cognos8/cognoslaunch.js" type="text/javascript">
</script>
<script language="javascript" src=

"http://localhost/cognos8/drill/utility.js" type="text/javascript">
</script>
<script language="javascript" src=

"http://localhost/cognos8/drill/CSelectionContextBuilder.js" type=

"text/javascript">
</script>
</head>
<body>
<script language="javascript" type="text/javascript">

                <!--

                        //Example 1: Build a basic selection context includes selection of a single value from a single column.

                        function BuildBasicSelection()

                        {

                                
                                var oSelectionContext   = new CSelectionContext(document.getElementById("fModelPath").value);   //The output selection context


                                //Select a measure (add more by adding to the childSelections array)...??could also be built from child to parent??

                                var oProdLine = oSelectionContext.addSelectedCell(      /*dataItemName*/                "Product line", 

                                                                                                                                        /*metadataModelItem*/   "[Great_Outdoors].[Products].[Products].[Product line]",

                                                                                                                                        /*useValue*/                    "[Great_Outdoors].[Products].[Products].[Product line]->:[PC].[@MEMBER].[2103]",

                                                                                                                                        /*useValueType*/                "memberUniqueName",

                                                                                                                                        /*displayValue*/                "Personal Accessories");


                                //The final selection context is made up of the header, the metadata table, the cells and the strings.

                                document.getElementById("fSC").value = oSelectionContext.toString();

                        }


                        //Example 2: Build the selection context for a nested selection including a single value from a single cell

                        //                       and a "parent" as would beseen in a higher level of a nested crosstab.

                        function BuildNestedSelection()

                        {

                                
                                var oSelectionContext   = new CSelectionContext(document.getElementById("fModelPath").value);   //The output selection context


                                //Select a column....(order method type = "Mail")

                                var oOrderMethod = oSelectionContext.addSelectedCell(   /*dataItemName*/                "Order method type", 

                                                                                                                                        /*metadataModelItem*/   "[Great_Outdoors].[Order method].[Order method].[Order method type]",

                                                                                                                                        /*useValue*/                    "[Great_Outdoors].[Order method].[Order method].[Order method type]->:[PC].[@MEMBER].[603]",

                                                                                                                                        /*useValueType*/                "memberUniqueName",

                                                                                                                                        /*displayValue*/                "Mail");


                                //Select a column....(product line = "Personal Accessories")

                                var oProdLine = oOrderMethod.addDefiningCell(                   /*dataItemName*/                "Product line", 

                                                                                                                                        /*metadataModelItem*/   "[Great_Outdoors].[Products].[Products].[Product line]",

                                                                                                                                        /*useValue*/                    "[Great_Outdoors].[Products].[Products].[Product line]->:[PC].[@MEMBER].[2103]",

                                                                                                                                        /*useValueType*/                "memberUniqueName",

                                                                                                                                        /*displayValue*/                "Personal Accessories");


				//Give the defining cell an axis ordinal

				oProdLine.addProperty('ordinal', '2');


                                //The final selection context is made up of the header, the metadata table, the cells and the strings.

                                document.getElementById("fSC").value = oSelectionContext.toString();


                        }


                        //Example 3: Build the selection context for a measure which is made up of the measure and two defining cells (one for

                        //                       row and one for column AND a nested selection in the rows (product line/product type)).

                        function BuildNestedMeasure()

                        {

                        
                                var oSelectionContext   = new CSelectionContext(document.getElementById("fModelPath").value);   //The output selection context


                                //Select a measure (add more by adding to the childSelections array)...??could also be built from child to parent??

                                var oMeasure = oSelectionContext.addSelectedCell(       /*dataItemName*/                "Quantity", 

                                                                                                                                        /*metadataModelItem*/   "[Great_Outdoors].[Measures].[Quantity]",

                                                                                                                                        /*useValue*/                    "500",

                                                                                                                                        /*useValueType*/                "Decimal",

                                                                                                                                        /*displayValue*/				"$500.00",

                                                                                                                                        /*usage*/						"measure");


                                //Select a column....(product type = "Tents")

                                var oProdType = oMeasure.addDefiningCell(       /*dataItemName*/                "Product type", 

                                                                                                                                        /*metadataModelItem*/   "[Great_Outdoors].[Products].[Products].[Product type]",

                                                                                                                                        /*useValue*/                    "[Great_Outdoors].[Products].[Products].[Product type]->:[PC].[@MEMBER].[102]",

                                                                                                                                        /*useValueType*/                "memberUniqueName",

                                                                                                                                        /*displayValue*/                "Personal Accessories",

                                                                                                                                        /*usage*/						"identifier");


                                //Select a column....(product line = "Personal Accessories")

                                var oProdLine = oProdType.addDefiningCell(                      /*dataItemName*/                "Product line", 

                                                                                                                                        /*metadataModelItem*/   "[Great_Outdoors].[Products].[Products].[Product line]",

                                                                                                                                        /*useValue*/                    "[Great_Outdoors].[Products].[Products].[Product line]->:[PC].[@MEMBER].[2103]",

                                                                                                                                        /*useValueType*/                "memberUniqueName",

                                                                                                                                        /*displayValue*/                "Personal Accessories",

                                                                                                                                        /*usage*/						"identifier");


                                //Note: declaring a variable is only required if nesting above a cell.

                                oMeasure.addDefiningCell(       /*dataItemName*/                "Year", 

                                                                                        /*metadataModelItem*/   "[Great_Outdoors].[Time].[Time].[Year]",

                                                                                        /*useValue*/                    "[Great_Outdoors].[Time].[Time].[Year]->:[PC].[@MEMBER].[20050101-20051231]",

                                                                                        /*useValueType*/                "memberUniqueName",

                                                                                        /*displayValue*/                "2005",

                                                                                        /*usage*/						"identifier");


                                //The final selection context is made up of the header, the metadata table, the cells and the strings.

                                document.getElementById("fSC").value = oSelectionContext.toString();

                        }


                        //Example 4: Build a selection context where multiple values for the same item are selected (at the root)

                        function BuildMultiSelectSameItemAtRoot()

                        {

                                //Create the Selection interface objects....IMPORTANT: Need better names for these top level interfaces!

                                var oSelectionContext   = new CSelectionContext(document.getElementById("fModelPath").value);   //The output selection context


                                //Select a column....(product type = "Tents")

                                var oProdType = oSelectionContext.addSelectedCell(      /*dataItemName*/                "Product type", 

                                                                                                                                        /*metadataModelItem*/   "[Great_Outdoors].[Products].[Products].[Product type]",

                                                                                                                                        /*useValue*/                    "[Great_Outdoors].[Products].[Products].[Product type]->:[PC].[@MEMBER].[102]",

                                                                                                                                        /*useValueType*/                "memberUniqueName",

                                                                                                                                        /*displayValue*/                "Tents");


                                //Select a column....(product line = "Packs")

                                var oProdType2 = oSelectionContext.addSelectedCell(     /*dataItemName*/                "Product type", 

                                                                                                                                        /*metadataModelItem*/   "[Great_Outdoors].[Products].[Products].[Product type]",

                                                                                                                                        /*useValue*/                    "[Great_Outdoors].[Products].[Products].[Product type]->:[PC].[@MEMBER].[104]",

                                                                                                                                        /*useValueType*/                "memberUniqueName",

                                                                                                                                        /*displayValue*/                "Packs");


                                //add a special property (one that's in the schema)

                                oProdType2.addProperty('LevelUniqueName', '[Great_Outdoors].[Products].[Products].[Product line]');

                                
                                //The final selection context is made up of the header, the metadata table, the cells and the strings.

                                document.getElementById("fSC").value = oSelectionContext.toString();

                        }


                        //Example 5: Build the selection context for a nested selection including a single value from a single cell

                        //                       and a "parent" as would beseen in a higher level of a nested crosstab.

                        function BuildMultiSelectTwoChildrenSameParent()

                        {

                                
                                var oSelectionContext   = new CSelectionContext(document.getElementById("fModelPath").value);   //The output selection context


                                //Select a column....(product type = "Tents")

                                var oProdTypeTents = oSelectionContext.addSelectedCell( /*dataItemName*/        "Product type", 

                                                                                                                                        /*metadataModelItem*/   "[Great_Outdoors].[Products].[Products].[Product type]",

                                                                                                                                        /*useValue*/                    "[Great_Outdoors].[Products].[Products].[Product type]->:[PC].[@MEMBER].[102]",

                                                                                                                                        /*useValueType*/                "memberUniqueName",

                                                                                                                                        /*displayValue*/                "Personal Accessories");


                                //Select a column....(product line = "Packs")

                                var oProdTypePacks = oSelectionContext.addSelectedCell( /*dataItemName*/                "Product type", 

                                                                                                                                        /*metadataModelItem*/   "[Great_Outdoors].[Products].[Products].[Product type]",

                                                                                                                                        /*useValue*/                    "[Great_Outdoors].[Products].[Products].[Product type]->:[PC].[@MEMBER].[104]",

                                                                                                                                        /*useValueType*/                "memberUniqueName",

                                                                                                                                        /*displayValue*/                "Packs");


                                //Select a column....(product line = "Personal Accessories")

                                var oProdLine = oProdTypeTents.addDefiningCell(         /*dataItemName*/                "Product line", 

                                                                                                                                        /*metadataModelItem*/   "[Great_Outdoors].[Products].[Products].[Product line]",

                                                                                                                                        /*useValue*/                    "[Great_Outdoors].[Products].[Products].[Product line]->:[PC].[@MEMBER].[2103]",

                                                                                                                                        /*useValueType*/                "memberUniqueName",

                                                                                                                                        /*displayValue*/                "Personal Accessories");


                                //Once added, the other addDefiningCell overload can be used

                                oProdTypePacks.referenceDefiningCell(oProdLine);

                                
                                //The final selection context is made up of the header, the metadata table, the cells and the strings.

                                document.getElementById("fSC").value = oSelectionContext.toString();

                        }


                        //Example 6: Build a selection context for illustrating measure based scope.

                        function BuildMeasureBasedScope()

                        {

                                
                                var oSelectionContext   = new CSelectionContext(document.getElementById("fModelPath").value);   //The output selection context


                                //Select a measure (add more by adding to the childSelections array)...??could also be built from child to parent??

                                var oQuantity = oSelectionContext.addSelectedCell(      /*dataItemName*/                "Quantity", 

                                                                                                                                        /*metadataModelItem*/   "[Great_Outdoors].[Measures].[Quantity]",

                                                                                                                                        /*useValue*/                    "1000",

                                                                                                                                        /*useValueType*/                "Decimal");


                                //The final selection context is made up of the header, the metadata table, the cells and the strings.

                                document.getElementById("fSC").value = oSelectionContext.toString();

                        }


                        //this function launches the goto page with the output from the selection context library.

                        function LaunchGotoPage()

                        {

                                var sGateway                            = document.getElementById('fGateway').value;

                                var sModelPath                          = document.getElementById('fModelPath').value;

                                var sEncodedModelPath           = sEncodedModelPath = encode64(document.getElementById('fModelPath').value);

                                var sTool                                       = "Goto2";

                                var sDirectLaunch                       = "true";

                                var sLang                                       = "";

                                var sRoutingServerGroup         = "";

                                var sEncExecutionParameters = "";

                                var sAuthoredDrillthru          = "";

                                var sModeledDrillthru           = "";

                                var sDrillContext                       = document.getElementById('fSC').value;

                                
                                cognosLaunch('ui.gateway', sGateway, 

                                                'ui.tool', sTool, 

                                                'directLaunch', sDirectLaunch, 

                                                'lang', sLang,

                                                'ui.routingServerGroup', sRoutingServerGroup,

                                                'encExecutionParameters', sEncExecutionParameters,

                                                'authoredDrillthru', sAuthoredDrillthru,

                                                'modeledDrillthru', sModeledDrillthru,

                                                'modelPath', sModelPath,

                                                'drillContext', sDrillContext);

                        }       

                -->

</script>
<h1>Selection Context Library Test Page</h1>
<!-- Minimum additional parameters necessary to launch the goto page -->
<h2>The following are values required to launch the Go To
page...</h2>
<table>
<tr>
<td>*Name:</td>
<td><input type="text" name="fGateway" value=

"http://localhost/cognos8/cgi-bin/cognos.cgi" size="100"></td>
</tr>
<tr>
<td>*Model:</td>
<td><input type="text" name="fModelPath" value=

"/content/package[@name='sales and marketing cube']/model[last()]"

size="100"></td>
</tr>
<tr>
<td>Action:</td>
<td><input type="text" name="fAction" value="filter" size="100" id=

"Text1"></td>
</tr>
<tr>
<td colspan="2" align="right">* denotes "Required"</td>
</tr>
</table>
<!-- Produce a selection context using the selection context library -->
<h2>Produce example Selection Contexts using the Selection Context
Builder Library...</h2>
<table id="SelectionContextLibraryTable">
<tr>
<td colspan="2">=== Example 1: "Simple Selection" ====<br>
OLAP Product Line = "Personal Accessories"<br>
<button onclick="BuildBasicSelection()" id="Basic" type=

"button">=== Example 1: "Simple Selection" ====</button></td>
</tr>
<tr>
<td colspan="2">=== Example 2: "Single axis nested Selection
===<br>
OLAP Product type = "Tents" nested under<br>
OLAP Product Line = "Personal Accessories"<br>
<button onclick="BuildNestedSelection()" id="Nested" type=

"button">=== Example 2: "Single axis nested Selection
===</button></td>
</tr>
<tr>
<td colspan="2">=== Example 3: Measure selection (with nested row
axis) ===<br>
Measure: Quantity<br>
Rows: Product type = "Tents" nested under Product Line = "Personal
Accessories"<br>
Cols: Year = "2005"<br>
<button onclick="BuildNestedMeasure()" id="Button2" type=

"button">=== Example 3: Measure selection (with nested row axis)
===</button></td>
</tr>
<tr>
<td colspan="2">=== Example 4: Multi select of same item at the
root (or select) ===<br>
Product type = "Tents"<br>
Product type = "Packs"<br>
<button onclick="BuildMultiSelectSameItemAtRoot()" id="Button1"

type="button">=== Example 4: Multi select of same item at the
selection root (or select) ===</button></td>
</tr>
<tr>
<td colspan="2">=== Example 5: Multi select - two cells have the
same defining cell ===<br>
Product type = "Tents"<br>
Product type = "Packs"<br>
<button onclick="BuildMultiSelectTwoChildrenSameParent()" id=

"Button4" type="button">=== Example 5: Multi select - two cells
have the same defining cell ===</button></td>
</tr>
<tr>
<td colspan="2">=== Example 6: Measure Based Scope ===<br>
Quantity = "1000"<br>
<button onclick="BuildMeasureBasedScope()" id="Button6" type=

"button">=== Example 6: Measure Based Scope ===</button></td>
</tr>
<tr>
<td width="74">Output<br>
Selection<br>
Context:</td>
<td>
<textarea rows="30" cols="100" name="fSC" id="fSC">
</textarea></td>
</tr>
<tr>
<td align="right" colspan="2"><b>Launch the goto page with this
output selection context:<br>
<button onclick="LaunchGotoPage()" id="Button3" type=

"button">Launch Goto Page</button></b></td>
</tr>
</table>
</body>
</html>