Home > Default > Can I have a browser report in SSAS cube that is Tabular. [I Dnt want the different columns to be in relation with each other, no grouping wanted]

Can I have a browser report in SSAS cube that is Tabular. [I Dnt want the different columns to be in relation with each other, no grouping wanted]

November 30Hits:0
Advertisement
Hi,
Can anyone here help me with a query I have in SSAS regarding a Designing on Report. 
Basically what my team desires is a Report, which is already been made from OLPT DB. The nature of report is not of a Cube. 
They need a Simple tabular report. Which means we want to display columns just like in SELECT Statement in sql. 
When I drag my dimension on the report (row or column grouping). No data is fetched. 
Simply can anyone tell me if Simple tabular report is possible in SSAS or not. 

Answers

Hi Senthiaan,
Yes you can use "Microsoft.AnalysisServices.AdomdClient.dll" in your
.NET application to execute MDX queries and populate Datasets. Take a look into the following code;
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
namespace ConsoleApplication2
using Microsoft.AnalysisServices.AdomdClient;
class Program
static void Main(string[] args)
System.String Query = "SELECT {[Measures].[Sales Amount]} ON COLUMNS, NON EMPTY{[Date].[Calendar Year].[Calendar Year].MEMBERS} ON ROWS FROM [Adventure Works]";
AdomdConnection oConnection = new AdomdConnection("Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=AdventureWorksDW;Data Source=localhost");
AdomdDataAdapter oAdapter = new AdomdDataAdapter(Query, oConnection);
System.Data.DataTable objDT = new System.Data.DataTable("Results");
oAdapter.Fill(objDT);
foreach (System.Data.DataRow r in objDT.Rows)
System.Console.WriteLine(r[0].ToString() + " :- " + r[1].ToString());
objDT.Dispose();
oAdapter.Dispose();
oConnection.Dispose();
System.Console.ReadLine();
ADOMD Client DLL locates in the following location.
C:\Program Files\Microsoft.NET\ADOMD.NET\110\Microsoft.AnalysisServices.AdomdClient.dll
Best regards.
(Mark and Vote if the Answer helps...)

Read other 6 answers

Tags:

Related Articles

Copyright (C) 2019 wisumpire.com, All Rights Reserved. webmaster#wisumpire.com 14 q. 0.668 s.