Ejemplo n.º 1
0
        static void LoadCache(ILocation location, IAppIdentifier id, bool opensheets, QlikSelection Selections)
        {
            IApp app = null;

            try
            {
                //open up the app
                Print(LogLevel.Info, "{0}: Opening app", id.AppName);
                app = location.App(id);
                Print(LogLevel.Info, "{0}: App open", id.AppName);

                //see if we are going to open the sheets too
                if (opensheets)
                {
                    //see of we are going to make some selections too
                    if (Selections != null)
                    {
                        for (int i = 0; i < Selections.fieldvalues.Length; i++)
                        {
                            //clear any existing selections
                            Print(LogLevel.Info, "{0}: Clearing Selections", id.AppName);
                            app.ClearAll(true);
                            //apply the new selections
                            Print(LogLevel.Info, "{0}: Applying Selection: {1} = {2}", id.AppName, Selections.fieldname, Selections.fieldvalues[i]);
                            app.GetField(Selections.fieldname).Select(Selections.fieldvalues[i]);
                            //cache the results
                            cacheObjects(app, location, id);
                        }
                    }
                    else
                    {
                        //clear any selections
                        Print(LogLevel.Info, "{0}: Clearing Selections", id.AppName);
                        app.ClearAll(true);
                        //cache the results
                        cacheObjects(app, location, id);
                    }
                }

                Print(LogLevel.Info, "{0}: App cache completed", id.AppName);
                app.Dispose();
            }
            catch (Exception ex)
            {
                if (app != null)
                {
                    app.Dispose();
                }
                throw ex;
            }
        }
Ejemplo n.º 2
0
        private static void BasicSelection(IApp theApp, IGenericObject theObject)
        {
            // Print data for year 2014 only.
            theApp.GetField("Year").Select("2014");
            PrintData("Sales for year 2014 only", theObject,
                      row => String.Format("Year: {0}, Month: {1}, Sales: {2}", row[0].Num, row[1].Text, row[2].Text));

            var salesRepField = theApp.GetField("Sales Rep Name");

            // Print data for year 2014 only, and for sales rep "Amalia Craig" only.
            salesRepField.Select("Amalia Craig");
            PrintData("Sales for year 2014 and sales rep Amalia Craig", theObject,
                      row => String.Format("Year: {0}, Month: {1}, Sales: {2}", row[0].Num, row[1].Text, row[2].Text));

            // Switch to sales rep "Amanda Honda"
            salesRepField.Clear();
            salesRepField.Select("Amanda Honda");
            // Print data for year 2014 only, and for sales rep "Amanda Honda" only.
            PrintData("Sales for all years", theObject,
                      row => String.Format("Year: {0}, Month: {1}, Sales: {2}", row[0].Num, row[1].Text, row[2].Text));

            // Clear selections and print data for all years and sales reps.
            theApp.ClearAll();
            PrintData("Sales for all years", theObject,
                      row => String.Format("Year: {0}, Month: {1}, Sales: {2}", row[0].Num, row[1].Text, row[2].Text));
        }
Ejemplo n.º 3
0
        private static void TakeSnapshots(ISheet sheet, IApp app, out ISnapshot nordicTop5, out ISnapshot nordicQuarterly, out ISnapshot usaTop5, out ISnapshot usaQuarterly, out ISnapshot japanTop5, out ISnapshot japanQuarterly)
        {
            // Get the Sales per Region on the sheet
            var salesPerRegion = GetVisualisationWithTitle(sheet, "Sales per Region");

            // Take a snapshot of SalesPerRegion
            if (salesPerRegion != null)
            {
                app.CreateSnapshot("SDK_SalesPerRegion", sheet.Id, salesPerRegion.Id);
            }

            // Select a region an take a snapshot of Top5Customers and QuarterlyTrend
            GetSelectAndCreateSnapshots(app, sheet, "Nordic", out nordicTop5, out nordicQuarterly);
            app.ClearAll();

            GetSelectAndCreateSnapshots(app, sheet, "Usa", out usaTop5, out usaQuarterly);
            app.ClearAll();

            GetSelectAndCreateSnapshots(app, sheet, "Japan", out japanTop5, out japanQuarterly);
            app.ClearAll();
        }
        private static void GroupedDimensions(IApp theApp, IGenericObject theObject)
        {
            var hyperCube = theObject.Properties.Get <HyperCubeDef>("qHyperCubeDef");

            // Make YearMonth, Year and Month stacked dimensions
            hyperCube.Dimensions = Enumerable.Empty <NxDimension>();
            AddInlineDimension(hyperCube, "Year");
            var dimension = hyperCube.Dimensions.ToArray()[0];

            dimension.Def.FieldDefs = dimension.Def.FieldDefs.Concat(new[] { "Month" });
            // The Grouping property indicates that the Dimension is stacked.
            dimension.Def.Grouping      = NxGrpType.GRP_NX_HIEARCHY;
            dimension.Def.SortCriterias = new[]
            {
                new SortCriteria {
                    SortByNumeric = SortDirection.Ascending
                },
                new SortCriteria {
                    SortByNumeric = SortDirection.Ascending
                }
            };
            SetHyperCube(theObject, hyperCube);

            // Prints sales per Year
            PrintGroupedData("Stacked, Sales per Year", theObject);
            // When selecting a single field of the top dimension of the stack, the hypercube
            // will use the next dimension of the stack instead.
            theApp.GetField("Year").Select("2016");
            // Prints sales per month for the selected year.
            PrintGroupedData("Stacked, Sales per Month for selected Year 2016", theObject);

            // Clear year selection.
            theApp.ClearAll();
            // Set group mode to cyclic and add dimension YearMonth
            dimension.Def.Grouping  = NxGrpType.GRP_NX_COLLECTION;
            dimension.Def.FieldDefs = dimension.Def.FieldDefs.Concat(new[] { "YearMonth" });
            SetHyperCube(theObject, hyperCube);
            // Print data for Year
            PrintGroupedData("Cyclic, Sales per Year (group 0)", theObject);
            // Print data for Month
            dimension.Def.ActiveField = 1;
            SetHyperCube(theObject, hyperCube);
            PrintGroupedData("Cyclic, Sales per Month (group 1)", theObject);
            // Print data for YearMonth
            dimension.Def.ActiveField = 2;
            SetHyperCube(theObject, hyperCube);
            PrintGroupedData("Cyclic, Sales per YearMonth (group 2)", theObject);
        }
        private static void BasicSelection(IApp theApp, IGenericObject theObject)
        {
            // Print data for year 2016 only.
            theApp.GetField("Year").Select("2016");
            Console.WriteLine("*** Sales for year 2016 only");
            foreach (var row in GetAllRows(theObject.GetHyperCubePager("/qHyperCubeDef")))
            {
                Console.WriteLine("Year: {0}, Month: {1}, Sales: {2}", row[0].Num, row[1].Text, row[2].Text);
            }

            var salesRepField = theApp.GetField("Sales Rep Name");

            // Print data for year 2016 only, and for sales rep "Amalia Craig" only.
            salesRepField.Select("Amalia Craig");
            Console.WriteLine("*** Sales for year 2016 and sales rep Amalia Craig");
            foreach (var row in GetAllRows(theObject.GetHyperCubePager("/qHyperCubeDef")))
            {
                Console.WriteLine("Year: {0}, Month: {1}, Sales: {2}", row[0].Num, row[1].Text, row[2].Text);
            }

            // Switch to sales rep "Amanda Honda"
            salesRepField.Clear();
            salesRepField.Select("Amanda Honda");
            // Print data for year 2016 only, and for sales rep "Amanda Honda" only.
            Console.WriteLine("*** Sales for year 2016 and sales rep Amanda Honda");
            foreach (var row in GetAllRows(theObject.GetHyperCubePager("/qHyperCubeDef")))
            {
                Console.WriteLine("Year: {0}, Month: {1}, Sales: {2}", row[0].Num, row[1].Text, row[2].Text);
            }

            // Clear selections and print data for all years and sales reps.
            theApp.ClearAll();
            Console.WriteLine("*** Sales for all years");
            foreach (var row in GetAllRows(theObject.GetHyperCubePager("/qHyperCubeDef")))
            {
                Console.WriteLine("Year: {0}, Month: {1}, Sales: {2}", row[0].Num, row[1].Text, row[2].Text);
            }
        }