How to use MdxHelper class of Ocaramba.Helpers package

Best Ocaramba code snippet using Ocaramba.Helpers.MdxHelper

MdxHelper.cs

Source:MdxHelper.cs

1ï»¿// <copyright file="MdxHelper.cs" company="Objectivity Bespoke Software Specialists">2// Copyright (c) Objectivity Bespoke Software Specialists. All rights reserved.3// </copyright>4// <license>5//     The MIT License (MIT)6//     Permission is hereby granted, free of charge, to any person obtaining a copy7//     of this software and associated documentation files (the "Software"), to deal8//     in the Software without restriction, including without limitation the rights9//     to use, copy, modify, merge, publish, distribute, sublicense, and/or sell10//     copies of the Software, and to permit persons to whom the Software is11//     furnished to do so, subject to the following conditions:12//     The above copyright notice and this permission notice shall be included in all13//     copies or substantial portions of the Software.14//     THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND, EXPRESS OR15//     IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF MERCHANTABILITY,16//     FITNESS FOR A PARTICULAR PURPOSE AND NONINFRINGEMENT. IN NO EVENT SHALL THE17//     AUTHORS OR COPYRIGHT HOLDERS BE LIABLE FOR ANY CLAIM, DAMAGES OR OTHER18//     LIABILITY, WHETHER IN AN ACTION OF CONTRACT, TORT OR OTHERWISE, ARISING FROM,19//     OUT OF OR IN CONNECTION WITH THE SOFTWARE OR THE USE OR OTHER DEALINGS IN THE20//     SOFTWARE.21// </license>22#if net4723namespace Ocaramba.Helpers24{25    using System.Collections.Generic;26    using System.Diagnostics.CodeAnalysis;27    using System.Globalization;28    using Microsoft.AnalysisServices.AdomdClient;29    using NLog;30    /// <summary>31    /// Class is used for execution MDX queries and reading data from Analysis Services.32    /// </summary>33    public static class MdxHelper34    {35        /// <summary>36        /// NLog logger handle.37        /// </summary>38        private static readonly Logger Logger = LogManager.GetCurrentClassLogger();39        /// <summary>40        /// Method is used for execution MDX query and reading each row from column.41        /// </summary>42        /// <param name="command">MDX query string.</param>43        /// <param name="connectionString">The Analysis Services connection string.</param>44        /// <param name="index">The index of column.</param>45        /// <returns>Collection of MDX query results.</returns>46        /// <example>How to use it: <code>47        /// var connectionString = "Provider=MSOLAP.5;Password=password;Persist Security Info=True;User ID=username;Initial Catalog=AdventureWorks;Data Source=servername;MDX Compatibility=1;Safety Options=2;MDX Missing Member Mode=Error";48        /// const string SqlQuery = "Select [Measures].[Internet Average Sales Amount] on Columns, [Product].[Category].members on Rows From [AdventureWorks];";49        /// ICollection&lt;string&gt; result = MdxHelper.ExecuteMdxCommand(mdxQuery, connectionString, 1);50        /// </code></example>51        [SuppressMessage("Microsoft.Security", "CA2100:Review SQL queries for security vulnerabilities", Justification = "Mdx injection is in this case expected.")]52        public static ICollection<string> ExecuteMdxCommand(string command, string connectionString, int index)53        {54            Logger.Debug(CultureInfo.CurrentCulture, "Send mdx query.");55            Logger.Debug(CultureInfo.CurrentCulture, "Query: {0}", command);56            Logger.Debug(CultureInfo.CurrentCulture, "AS connection string: {0}", connectionString);57            Logger.Debug(CultureInfo.CurrentCulture, "Index: {0}", index);58            var resultList = new List<string>();59            using (var connection = new AdomdConnection(connectionString))60            {61                connection.Open();62                using (var mdxCommand = new AdomdCommand(command, connection))63                {...

MdxHelper

Using AI Code Generation

1using System;2using System.Collections.Generic;3using System.Linq;4using System.Text;5using System.Threading.Tasks;6using Ocaramba;7using Ocaramba.Extensions;8using Ocaramba.Types;9using Ocaramba.Helpers;10using NUnit.Framework;11using OpenQA.Selenium;12using OpenQA.Selenium.Support.UI;13using OpenQA.Selenium.Interactions;14using System.Threading;15using System.IO;16{17    {18        public void TestMdxHelper()19        {20            var mdx = new MdxHelper(this.DriverContext);21            mdx.OpenFile(@"C:\Users\Public\Documents\Ocaramba\MdxHelper\SampleFile.xlsx");22            var cellA1 = mdx.GetCellValue("A1");23            mdx.SetCellValue("B2", "B2 data");24            var cellB2 = mdx.GetCellValue("B2");25            mdx.SaveFile();26            mdx.CloseFile();27            Assert.AreEqual(cellA1, cellB2);28        }29    }30}31using System;32using System.Collections.Generic;33using System.Linq;34using System.Text;35using System.Threading.Tasks;36using Ocaramba;37using Ocaramba.Extensions;38using Ocaramba.Types;39using Ocaramba.Helpers;40using NUnit.Framework;41using OpenQA.Selenium;42using OpenQA.Selenium.Support.UI;43using OpenQA.Selenium.Interactions;44using System.Threading;45using System.IO;46{47    {48        public void TestMdxHelper()49        {50            var mdx = new MdxHelper(this.DriverContext);51            mdx.OpenFile(@"C:\Users\Public\Documents\Ocaramba\MdxHelper\SampleFile.xlsx");52            var cellA1 = mdx.GetCellValue("A1");

MdxHelper

Using AI Code Generation

1using Ocaramba.Helpers;2using System;3using System.Collections.Generic;4using System.Linq;5using System.Text;6using System.Threading.Tasks;7using System.Windows.Forms;8{9    {10        static void Main(string[] args)11        {12            var mdxHelper = new MdxHelper();13    {[Measures].[Unit Sales], [Measures].[Store Cost]} ON COLUMNS,14    {[Product].[All Products].[Drink], [Product].[All Products].[Food], [Product].[All Products].[Non-Consumable]} ON ROWS15WHERE ([Time].[1997].[Q1], [Store].[All Stores].[USA].[CA])";16            var result = mdxHelper.ExecuteMdxQuery(mdxQuery);17            MessageBox.Show(result);18        }19    }20}

MdxHelper

Using AI Code Generation

1using Ocaramba.Helpers;2using Ocaramba.Tests.NUnit;3using NUnit.Framework;4{5    {6        public void MdxHelperTest()7        {8            MdxHelper mdxHelper = new MdxHelper();9            string query = "SELECT NON EMPTY {[Measures].[Unit Sales]} ON COLUMNS, NON EMPTY {[Product].[All Products].[Drink

MdxHelper

Using AI Code Generation

1using Ocaramba.Helpers;2using Ocaramba.Helpers;3using Ocaramba.Types;4using OpenQA.Selenium;5using System;6using System.Collections.Generic;7using System.Linq;8using System.Text;9using System.Threading;10using System.Threading.Tasks;11using Ocaramba.Extensions;12using Ocaramba;13using Ocaramba.UITests;14using Ocaramba.UITests.NUnit;15using NUnit.Framework;16using Ocaramba.UITests.PageObjects;17using System.Collections.ObjectModel;18using System.Collections.Specialized;19using System.Collections;20using System.IO;21using System.Drawing;22using System.Drawing.Imaging;23using System.Drawing.Drawing2D;24using System.Diagnostics;25{26    {27        private readonly string username = "admin";28        private readonly string password = "admin";29        private int timeout = 10;30        public void TestLogin()31        {32            DriverContext.Driver.Navigate().GoToUrl(url);33            DriverContext.Driver.Manage().Window.Maximize();34            DriverContext.Driver.WaitForPageLoaded();35            DriverContext.Driver.FindElement(By.Id("j_username")).SendKeys(username);36            DriverContext.Driver.FindElement(By.Name("j_password")).SendKeys(password);37            DriverContext.Driver.FindElement(By.Name("Submit")).Click();38            DriverContext.Driver.WaitForPageLoaded();39            Assert.IsTrue(DriverContext.Driver.FindElement(By.ClassName("user")).Text.Equals(username));40        }41        public void TestLoginWithPageObject()42        {43            DriverContext.Driver.Navigate().GoToUrl(url);44            DriverContext.Driver.Manage().Window.Maximize();45            DriverContext.Driver.WaitForPageLoaded();46            LoginPage loginPage = new LoginPage(DriverContext);47            loginPage.Login(username, password);48            DriverContext.Driver.WaitForPageLoaded();49            Assert.IsTrue(D

MdxHelper

Using AI Code Generation

1using Ocaramba;2using Ocaramba.Helpers;3{4    {5        private MdxHelper mdxHelper;6        public void SetUp()7        {8            this.mdxHelper = new MdxHelper();9        }10        public void MdxHelperTest()11        {12            var result = this.mdxHelper.GetMdxResult(13                "SELECT [Measures].[Internet Sales Amount] ON COLUMNS, NON EMPTY {([Date].[Calendar].[Calendar Year].&[2012], [Product].[Product Category].&[2])} ON ROWS FROM [Adventure Works]");14            Assert.IsTrue(result.Contains("1,635,000.00"));15        }16    }17}

MdxHelper

Using AI Code Generation

1using Ocaramba;2using Ocaramba.Extensions;3using Ocaramba.Types;4{5    {6        private readonly MdxHelper mdxHelper = new MdxHelper();7        public void MdxHelperTest()8        {9            var query = new MdxQuery();10            query.From("AdventureWorks");11            query.Select(new MdxSelect().Member("Product", "Product", "Product Line"));12            query.Select(new MdxSelect().Member("Product", "Product", "Category"));13            query.Select(new MdxSelect().Member("Product", "Product", "Subcategory"));14            query.Select(new MdxSelect().Member("Product", "Product", "Product"));15            query.Select(new MdxSelect().Measure("Sales", "Internet Sales Amount"));16            query.Where(new MdxWhere().Member("Time", "Time", "Year", "2005"));17            query.Where(new MdxWhere().Member("Time", "Time", "Month of Year", "January"));18            query.Where(new MdxWhere().Member("Product", "Product", "Product Line", "Mountain Bikes"));19            query.Where(new MdxWhere().Member("Product", "Product", "Category", "Bikes"));20            query.Where(new MdxWhere().Member("Product", "Product", "Subcategory", "Mountain Bikes"));21            query.Where(new MdxWhere().Member("Product", "Product", "Product", "Mountain-100 Black, 38"));22            var result = this.mdxHelper.GetMdxResult(query);23            Assert.AreEqual(1, result.Count);24            Assert.AreEqual("Mountain Bikes", result[0]["Product_Product_Product Line"]);25            Assert.AreEqual("Bikes", result[0]["Product_Product_Category"]);26            Assert.AreEqual("Mountain Bikes", result[0]["Product_Product_Subcategory"]);27            Assert.AreEqual("Mountain-100 Black, 38", result[0]["Product_Product_Product"]);28            Assert.AreEqual(0, result[0]["Sales_Internet Sales

Automation Testing Tutorials

Learn to execute automation testing from scratch with LambdaTest Learning Hub. Right from setting up the prerequisites to run your first automation test, to following best practices and diving deeper into advanced test scenarios. LambdaTest Learning Hubs compile a list of step-by-step guides to help you be proficient with different test automation frameworks i.e. Selenium, Cypress, TestNG etc.