Click here to Skip to main content

Submit your article

SSAS

SSAS

Great Reads

Introduction to Named Query in Sql Server Analysis Services

by Mubin M. Shaikh

Create Named Query in Data Source View While Designing OLAP Cube in SSAS

Unified Dimensional Model (UDM)

by coded007

A word about Unified Dimensional Model we use in analysis services.

Tabs in the SSAS Cube Designer

by Marla Sukesh

Tabs in the SSAS cube designer

Analysis Service MDX Query Viewer web client

by Fedor Dzjuba

Client and a WebAPI to execute MDX query against SSAS and display a resulted cellset in a pivoted grid form with Axis neatly arranged in a hierarchical and grouped manner.

Latest Articles

Analysis Service MDX Query Viewer web client

by Fedor Dzjuba

Client and a WebAPI to execute MDX query against SSAS and display a resulted cellset in a pivoted grid form with Axis neatly arranged in a hierarchical and grouped manner.

Learn to create MSBI ( Microsoft Business Intelligence) project in 7 days

by Marla Sukesh

In this article we Learn step by step how to create project with MSBI.

Creating Date dimension from scratch in Microsoft SSAS

by Miljan Radovic

Script to generate DimDate for specified date range

Introduction to Percolator Analysis Services LINQ to MDX ORM

by Suffyan Asad

Percolator Analysis Services is a LINQ to MDX ORM that enables writing MDX Queries in LINQ instead of using hard-coded strings of MDX code, resulting in cleaner, easier to read and easier to maintain code.

All Articles

SSAS

Introduction to Named Query in Sql Server Analysis Services

29 Sep 2013 by Mubin M. Shaikh

Create Named Query in Data Source View While Designing OLAP Cube in SSAS

SQL-Server-2008

SQL Server 2012 developer version

10 Dec 2014 by ZurdoDev

If you google for sql server compare editions you can find the links. Here is one:http://msdn.microsoft.com/en-us/library/cc645993(v=sql.110).aspx[^]It says that developer has the same feature set as Enterprise and SSIS is on the list.

Unified Dimensional Model (UDM)

23 Sep 2013 by coded007

A word about Unified Dimensional Model we use in analysis services.

Tabs in the SSAS Cube Designer

29 Aug 2014 by Marla Sukesh

Tabs in the SSAS cube designer

Analysis Service MDX Query Viewer web client

7 Jan 2020 by Fedor Dzjuba

Client and a WebAPI to execute MDX query against SSAS and display a resulted cellset in a pivoted grid form with Axis neatly arranged in a hierarchical and grouped manner.

I want to study ssas,ssis,ssrs before what are things we should known in sql and tell me the tutorial and practice sites to learn

24 May 2014 by Maciej Los

Please, read Was Aday's comment to your question. You should try to find anything using Google[^] or SearchBox[^] on the right-top corner of this site.Here is a collection of useful links:Analysis Services Tutorials (SSAS)[^]SSIS Tutorial: Creating a Simple ETL Package[^]SQL Server...

how to create and populate Date Time dimension table for Nepal country for data warehouse

26 Mar 2015 by CHill60

The biggest problem I had here was working out how many days there are in each month. I struggled to find the rules specific to Nepal, so in the end I used a table of known dates (taken from this website[^]). If you know the rules then replace the hard-coded values below with the appropriate...

How to keep the structure of the tablix when there is no data to show

24 Feb 2016 by CHill60

The IsNothing function will only work if a row has been returned. Your problem is that there is nothing to return (and therefore nothing for the function to work on).You could use a stored procedure that does something like IF EXISTS (select * from table3) SELECT id, datum FROM...

Concern about SSAS DATABASE Architecture ?

11 Apr 2012 by RDBurmon

Hello All ,First of all I would like to describe my datawarehouse setup followed by my concern . So here is my databases(OLAP/OLTP) stuctureWe have one OLTP database called as "ABC_ProductSales" on (ABC_SQL1) server where we have all the details regarding product and there sales...

Displaying data while browsing cube in a diff format why ?

17 Apr 2012 by Member 8815455

Hi All,I have created a cube. it is working fine.Recently i have processed the cube with new data. From that time onwords the data is showing for that particular value is in diff format.Please take a look into the below data. V1 -- 605771038081655V18 -- 970928668184954V19 --...

SSAS - Drillthrough returns empty set when security applied

3 May 2012 by Rritesh Ravlani

Hi,We have an SSAS role defined which can successfully execute adrillthrough action, receiving a result set (header + records) SO LONGAS no object level security is set. As soon as any object levelsecurity is set on any dimension which contains an attribute to bereturned in the...

SQL-Server-2008

How to use stored procedure which returns multiple tables in SSRS 2008

27 Nov 2012 by omprakash katre

Does anybody know if it is even possible to have a stored procedure which returns multiple select statements (result tables), and then have that dataset in reporting services return multiple tables?The issue is that I can not reference the second or third result table in the dataset, and I can...

SQL-Server-2008

How to use stored procedure which returns multiple tables in SSRS 2008

27 Nov 2012 by Krunal Rohit

read this thread:http://social.msdn.microsoft.com/Forums/is/sqlreportingservices/thread/034c4a02-0212-42d5-b768-d761e2c11a30[^]

SQL-Server-2008

Pivot in Excel 2007 using ssas

1 May 2013 by niralirshah

Hello,I am using Excel 2007. i have values in minutes, now i want to avg those values for particular row labels .. but it gives me only sum, i tried to clieck on values and it opens the value field settings. but it disable the functions for summerized...Any help....please help asap..

population of pivotFields visibleitemslist from cube

22 May 2013 by wasifmuneer

Hi i would like to ask about pivot report. The scenrio is, i have set filter column in pivot report, unfortunately the column contains a null value as well, and i need to work for cube to remove that null value, the question is that having that null value, in column does the VBA Script...

artificial-intelligence

population of pivotFields visibleitemslist from cube

22 May 2013 by Maciej Los

Replace:pType = Sheet1.Cells(25,"B")with:pType = Sheet1.Cells(25,2)'or'pType = Sheet1.Range("B25")More:Cells Collection[^]Cell Object[^]Range Object[^]VBA to Read & Modify a Pivot Table in Excel[^]PivotTable Object [Excel 2003 VBA Language Reference][^]

artificial-intelligence

what is meant by PPS in data modeling

11 Jun 2013 by Ron Beyer

PPS = Payroll and Personnel Systems, its simply an acronym for a system that incorporates payroll and human resources data structures into a single system.

what is meant by PPS in data modeling

11 Jun 2013 by Mike Meinz

It could mean any number of things. You may have to ask the author of the material where you saw PPS mentioned.Here are two additional definitions:PPS: Production Planning SystemPPS: Performance Point Server (A Microsoft product)

SQLServer Objects Migration strategy to sqlserver newer versions

12 Jun 2013 by Madhu from Bangalore

Hai this is MadhuTo Analyse the existing SQL Server objects, Stored Procs and detail the Migration Strategy across various SQL Server versions (v2000 / 2005 / 2008)My question is what is this and how to do for that Migration ?can any one please give me brief information with...

SQL-Server-2008

Pre-Migration and Post-Migration to ascertain the data consistency and accuracy

12 Jun 2013 by Madhu from Bangalore

haiPreparation of Resolution / Strategy Doc, Test Planning and Test Execution - both Pre-Migration and Post-Migration to ascertain the data consistency and accuracy.can u please give me brief information about that and what is that and how to do?

SQL-Server-2008

SQLServer Objects Migration strategy to sqlserver newer versions

12 Jun 2013 by Maciej Los

Ohhh... Madhu,Here you can get only short answer about detailed question.Please, start here: MS SQL Server[^] choose your server version and read all related articles. I think it's enough for start ;)

SQL-Server-2008

Implement Dynamic Security by Using Row Filters in SSAS tabular model to which Direct query mode is enabled

2 Jul 2013 by R J P

Hi every one,I am using SSAS 2012 to create a tabular model. While creating tabular model am enabling Direct query mode as ON ,to get Real time data from database.Now actual problemwho ever the user accessing that tabular model should get only data which are specific to his role or his...

Require SSRS and SSAS tutorials

23 Jul 2013 by Maciej Los

Have a look here:Developing a SSRS report using a SSAS Data Source[^]SQL Server Analysis Services Tutorial[^]

SSRS 2008 : Parameters are not passed to Web Service Method (Xml Data Source)

20 Aug 2013 by omprakash katre

I am facing problem in SSRS 2008. The parameters of rdl query for an web service API are not working. Instead the parameters are parsed with default values are workingMy Query in the rdl file is ...

SSRS 2008 : Parameters are not passed to Web Service Method (Xml Data Source)

22 Aug 2013 by Anh Nguyen Trong

Please try this:It is more simple than yoursGetOrders1 - Method in WebserviceOrderID - Parameter of Webserice.ElementPath- Type exact column name in Database http://tempuri.org/GetOrders1

Concern about SSAS DATABASE Architecture ?

4 Sep 2013 by Mubin M. Shaikh

Hi,Keep architecture simple in data warehouse, means first you can prepare you can prepare data on staging level for your dimensions and fact tables, complete denormalization of your data and population of your SCD dimension here itself. so it will keep your DW data error free.AFter that...

I want to learn SSAS

16 Sep 2013 by Sergey Alexandrovich Kryukov

Please start here:http://en.wikipedia.org/wiki/Microsoft_Analysis_Services[^],http://technet.microsoft.com/en-us/sqlserver/cc510300.aspx[^].—SA

how to do proactive caching on partition for molap,rolap and olap

29 Sep 2013 by Member 10304951

In which scenario we have to use ROLAPHOLAPMOLAPPlease provide examples

Can we use the cube without deploying the solution?

30 Sep 2013 by Jagz W

I am new to SSAS and I have created an analysis services project but I don't have premission to deploy the solution on server. So, my question is Can we use cube data without deploying the solution for developing purposes or any other alternative.

error while deploying dimension for dimcustomer table

1 Oct 2013 by Member 10299303

hi,this is my first ssas project.i've created 3 dimensions for adventureworksDW database.dimproduct, dimdate & dimcustomer by using respective tables.But first two dimensions are deployed & processed successfully.but while deploying dimcustomer dimension, i'm facing lot of...

Analysis Services keep creating new database id when refresh data in PowerPivot SharePoint

1 Oct 2013 by afiqdoherty

I have a problem with the Analysis Services..i don't know how to explain this,but I have build a cube on PowerPivot and uploaded it in my sharepoint site.my problem is,each time I reload /refresh the workbook in SharePoint, the database id in Analysis Services keep creating the new id of the...

Can we use the cube without deploying the solution?

2 Oct 2013 by Mubin M. Shaikh

Hi,As Per My knowledge ,You Need to have Analysis Services Installed On Your Local Environment and You have to deploy to local environment from BIDS. without deploying i don't think so you can browse cube data in Browse Tab of Cube.Let Me know if you still have any query.Regards,Mubin

error while deploying dimension for dimcustomer table

8 Oct 2013 by Member 10299303

Hi Friends,Somehow I managed to solve my issue.The issue exists with the coloumns i've selected for dimcustomer table while creating dimension, which is having duplicate values.To solve this, I've choosen key coloumn & value coloumn of the dimension/attributes. Ofcourse, I've choosen...

creating dev Pivot grid at runtime using OLAP cube dimensions

10 Dec 2013 by sandesh.mumbai

Hi there,I am using Devexpress pivot grid in my project which binds the data at runtime using OLAPConnectionstring provided by me at runtime. But I cannot find the complete name of dimension at runtime using property of [CubeName.Dimension.GetByName]. Can somebody help me find out the exact...

creating dev Pivot grid at runtime using OLAP cube dimensions

23 Jan 2014 by sandesh.mumbai

I stored the dimension hierarchy coming from db in datatable.Then I read the complete hierarchy using for loop and manually assigned the fieldnames

Table not found error in SSAS

1 Feb 2014 by 007alok

I am working on SSAS i developed an datacube and deployed succesfully but when i call that SSAS through my SSIS it says that some table is not found but the table exist in my SSAS module.All things are working fine previous days suddenly this hapened kindly help me in this issue.

How to show chart of mining model viewer in asp.net application?

7 Feb 2014 by Member 8726940

hi..I am new to datamining.I create a analysis service project it show the prediction in the chart of mining model viewer using time seris algorithm. now I want to show this chart on asp.net webPage..Please help as soon as possible.RegardsShalini Rathore

How to create Login password for the user to vie my SSAS Cube in excel

24 Feb 2014 by Member 10441738

Hi,I want to know How to create Login password for the user to vie my SSAS Cube in excel.Can anyone provide step by step procedure please.with regardsSanjoy Ghosh

How to get User Related data only in ssas cube

24 Mar 2014 by agarmt

I have 1000 customers who has belongs to different countries and states. how can i show their corresponding data only in ssas cube when the user login into the page.to fetch the data presently i am using msmdpump.dll

Help optimizing a MDX Query

29 Apr 2014 by staretzu

I am quite new to MDX (who isn't) and I need someone to help me with this query. GENERATE( FILTER ( [Dim Products].[Product].[Product].members * [Dim Date].Week.Week.members, [Measures].[Price] ), NONEMPTY ( TOPCOUNT ( [Dim...

Show Empty Column Values in SSAS/SSRS

6 May 2014 by Member 10798594

I have a situation ..In My cube I have :A Fact table >2 Dimension > , >I have 4 company say (A,B,C,D)but i have record for only company A & D that too only for December month . When I create a SSRS report out of the cube i want a matrix where...

Show Empty Column Values in SSAS/SSRS

6 May 2014 by Member 10798594

got the solution to this . Please referhttp://social.msdn.microsoft.com/Forums/sqlserver/en-US/7aa7679e-5d03-4951-97ef-defc13538152/show-empty-column-values-in-ssasssrs?forum=sqlreportingservicesIf any other suggestion , please be free to suggest.

Help optimizing a MDX Query

11 May 2014 by staretzu

Any advise please? I need help with this as soon as possible.

How to browse the record from SSAS on the basis of quarterly and yearly using EnteredDate Column

23 Jul 2014 by Member 10464342

In my project requirement is some thing like this.Database Name - NewData TableName - PolicyPolicyAID PolicyNo. ClaimNo EnteredDate---------------------------------------------1 MNS123 138317 12/02/20132 MNS123 138318 13/02/20133 ...

SQL-Server-2008R2

How Can I Retrieve The Limited Records Using Row_Number Function In Mdx Query

24 Sep 2014 by kingsa

Hi,I written MDX query for getting row Number. I got the row_number but i want to retrieve the data between 10 to 15 Records using row_ number column. can u guide me or send snippetsWITH MEMBER [Measures].[Row number] AS iif( IsError(Axis(0).Count), null, Rank ( ...

How do I attache analysis service db file

24 Sep 2014 by Member 11106350

When i am trying the attach Analysis service db file (MDX Step-by-Step.abf)bu running the below commnand C:\Microsoft Press\MDX SBS\Setup\Analysis Services\Mdx Step-by-Step.abf MDX...

how to retrive limited number of records from mdx query

25 Sep 2014 by kingsa

Hi all,i want retrive data from cubes using mdx query , the data need to shown in grid , but i want limited no of records , wen i do paging i need to records which i want to shown those records i need to fectch, canu guide or send snippets

SQL-Server-2008R2

how to retrive limited number of records from mdx query

25 Sep 2014 by _Asif_

Check this forum for solutionMDX Query TOP n rows[^]

SQL-Server-2008R2

How Can I Retrieve The Limited Records Using Row_Number Function In Mdx Query

29 Oct 2014 by Maciej Los

MDX queries differs from SQL queries in many aspects...MSDN wrote:ImportantUnlike the WHERE clause in SQL, the WHERE clause of an MDX SELECT statement never directly filters what is returned on the Rows axis of a query. To filter what appears on the Rows or Columns axis of a query, you...

How to replace Fact table in Tabular SSAS

10 Nov 2014 by Member 11188358

Hi,I have started with Tabular SSAS. i have made tabular cube which is working fine.Now , i have made another cube using the previous cube. I am not able to understand how to replace my fact table now. In Multi- dimensional there is an option of replace but in tabular i am not able to...

Automate cube process using sql jobs

13 Nov 2014 by bunty swapnil

Hi friends,I am very new to SSIS and don't know SSAS. and i have an task to automate SSAS cube.But i want cube processing after all the steps of my job, to publish the data.Cube present in other machine and job is on other machine. even i am unable to point machine for pointing to...

Automate cube process using sql jobs

13 Nov 2014 by Mathew Soji

Please refer below , may be useful.http://msdn.microsoft.com/en-us/library/ms169712.aspx[^]Create First OLAP Cube in SQL Server Analysis...

Automatic Date generation in Dim_TIme

13 Nov 2014 by Durga Venkata Avinash

Hi,I have a scenario in my on going project. We prepared a Time Dimension for linking to analysis services cube (star schema). Today we got a issue such that we need to automatically generate date in Time Dimension table. I am thankful in advance for your suggestions.Thanks,Durga.

SSAS Tabular creating multiple Workspace tabular

16 Nov 2014 by Member 11188358

Hello, I have created a tabular Cube (Name:Cust_Sales) which i am processing twice in a day. While i deploy or process; there is workspace database creating in SSMS. so basically when i am connecting to SSSM i can see two different database.1. Cust_Sales2....

SSAS CUBE not working in My browser

16 Nov 2014 by Sanandh ck

Dear Siri have deployed a ssas cube in Data center serveri cant access my cube in internet browser in another machine(another domain)i show a error message "The query could not be processed:o The following system error occurred: A connection attempt failed because the connected...

SSAS Cube Web connection

17 Nov 2014 by Sanandh ck

How to set connection string to ssas cube if the connection using basic authentication mode

I want to study ssas,ssis,ssrs before what are things we should known in sql and tell me the tutorial and practice sites to learn

17 Nov 2014 by Member 11242859

Hello vanarajranjit,First you have to know basic knowledge of sql language - like Joins, Stored procedures, functions, DDL, DML etc. Also you know basic fundamentals of Business Intelligence, Data Warehouse, ETl and Reporting.If you want to learn SSAS, SSIS, SSRS please see below links -...

how to create time filter in date dimension for SSAS Cube

18 Nov 2014 by Member 11243703

Hi, Please suggest me ,how can I create time filters (like WTD,MTD,QTD,YTD) in time dimension for SSAS Cube. Thanks in advance.

How can I build a small app for end users to show them some reporting services or pivot reports?

3 Dec 2014 by Georgian Pirvu

Can anyone recommend a starting point in implementing a small Business Intelligence aplication in .Net , WPF? I mean a small aplication for reporting where user from local network to connect with their own login data and run some reporting services reports or to show some power pivot reports...

reporting-services

SQL Server 2012 developer version

10 Dec 2014 by Homero Rivera

Hello, I'm hoping to have some help from experienced developers who work with MS SQL Server. I really tried calling Microsoft about this, ask questions, look into different websites and blogs and I couldn't get a straight answer.Hence, I appeal to you.Will the SQL Server 2012 Developer...

In Ssas One Of My Measure I Have Used Format String As <Pre>"$#,#;0;</Pre>

16 Dec 2014 by prakash.chakrala

Hi TeamIn SSAS one of my measure i have used format String as "$#,#;0; so its displaying $ (my value) but i f have -ve value in the data its not displaying $ symbol can anyone help on this.

SSAS -How to select a particular attribute when we drag dimension into query editor

11 Feb 2015 by Boligarla Hari

I have about 5 attributes (Continent,Country,State,District,City) in my geography dimension **When i drag a geography dimension to the ssas query editor i want to show my own defined attribute like 'state' (ssas by default selects the first attribute based on alphabetical order) i don't want...

How to install BIDS for SQL Server 2008 R2 and Visual Studio 2008 SP1

19 Sep 2019 by Member 11006077

Hi Friends,i have got project related to BIDs, but i know knowledge of "SQL Server 2008 R2 and Visual Studio 2008 SP1"i want learn how to install the BIds and why they are using BIDSi have one doubt, for every application UI And Database is enough right But why they are using...

SQL-Server-2008R2

How to install BIDS for SQL Server 2008 R2 and Visual Studio 2008 SP1

9 Mar 2015 by CHill60

The install[^]Tutorial[^]Quote:why they are using BIDS... You'll have to ask them!

SQL-Server-2008R2

how to create and populate Date Time dimension table for Nepal country for data warehouse

20 Mar 2015 by vibsg

Hi,how to create and populate Date Time able for Nepal country for data warehouse.I would like to have 20 years data in the below fileds according to Hindi calendar (for NEPAL Country)CREATE TABLE [dbo].[dim_time]( [YearLabel] [char](10) NULL, [QtrLabel] [nvarchar](20)...

How to build the Time dimension to show Year Total, Last 8 Weeks, Prev 35 Days etc on single hierarchy

5 May 2015 by sagunrpiya

How can I create a time dimension in SSAS which has hierarchy with the highest level values as Year, Prev 35 Days, Weeks.Then second level on hierarchy will show Qtr1,Qtr2 etc under Year. Prev 7 Days, Prior 28 Days under Prev 35 Days and Wk00, Wk01 under Weeks. Under second level hierarchy we...

How do I remove filtered data from My ALL level in MDX

30 Jun 2015 by Member 11803871

HI! I have a cube that has both Canada & US data. I have managed to filter out the Canada data from the Rows but my ALL value (which I still need) includes both Canada & US values. How do I write the MDX qry so that only the US data is in the ALL?If there is a better way to filter PLEASE...

Problems with filters (Problèmes avec les filtres)

22 Jul 2015 by Member 11603655

Bonjour , Bref , je suis en train de développer une application BI à l'aide de l'outil SQL SERVER 2012 .Le tout s'est passé bien et comme il faut .Je décrits mon problème : L'application BI est développée pour une société industrielle , qui a comme le travail horaire sur 3 postes (Matin...

Problems with filters

22 Jul 2015 by Wendelius

I really suggest dropping the idea of using integers instead of datetime. That kind of logic will make it very difficult to manipulate and query the data.What comes to performance, SQL Server handles dates internally using numbers so the difference between integer and date shouldn't be...

dimenson attributes order change

22 Jul 2015 by prakash.chakrala

Hi Team,In a cube i have a dimension in that i have 3 attributes named as Dimension1, Dimension2, Dimension3.Now actual problem when i drag dimension directly we will get Dimension1 attribute but how to get Dimension3 attribute by default when we drag dimension.Thanks in...

Cube measure changes

1 Sep 2015 by Tadit Dash (ତଡିତ୍ କୁମାର ଦାଶ)

Here we answer specific questions which members face during programming. We can't work on the whole source code. You need to do that yourself.If you face any difficulty while coding, feel free to come back here and ask another question with specific issue describing the scenario....

Show Dimension Names In MDX Query Result

27 Oct 2015 by Sibeesh Passion

Hi,Hope you are fine. I am facing an issue in MDX Query. I have a custom MDX query, When I run the query I am getting results too. Now my requirement is to show the dimension names in the query result, So that I can get those header names in the cell set itself. Please see the below...

Show Dimension Names In MDX Query Result

29 Oct 2015 by Kuthuparakkal

Please try like this: WITH MEMBER [Measures].[Fiscal Year] AS [Dim Data Period].[Fiscal Year].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[Fiscal Quarter] AS [Dim Data Period].[Fiscal Quarter].CURRENTMEMBER.MEMBER_CAPTIONSELECT NONEMPTY( ...

Find data type of measures in Cube using MDX queries

30 Dec 2015 by Sibeesh Passion

I am working SSAS MDX queries. Now I need to identify the data type of each columns from the MDX queries. I have already tried as below.WITH MEMBER PageSize AS 1 Member [Measures].[My Type] as TypeName([Measures].[Budget Delivered COGS])But it returns double for the currency field....

Data warehouse: Orders, Sales and Revenue facts

25 Jan 2016 by Purna Chandra Sasmal

Based on your data volume, you can decide.if it is less, you can create view on top of this and have the total sum of order, sale and revenue corresponding to dimensions.or, you can create tabular model.

Sorting all the columns in MDX queries

3 Feb 2016 by Sibeesh Passion

Below is my MDX query. Here I have applied sorting for one column, how can I sort all the columns, the reason behind this is, I no column should have any values like (null), null, empty, unknown etc.WITH MEMBER PageSize AS 1MEMBER [PageNumber] AS 1MEMBER [Measures].[Orderby...

Sorting all the columns in MDX queries

3 Feb 2016 by Sibeesh Passion

I have done it by myself. I have changed the ROWAXISWOF as follows.SET ROWAXISWOF AS NonEmpty ( NonEmpty ( ( [Time Periods].[Fiscal Year].[Fiscal Year].Members, [Time Periods].[Fiscal Quarter].[Fiscal Quarter].Members, [Time Periods].[Fiscal Month].[Fiscal Month].Members,...

How do i get the latest row based on the last start date

15 Feb 2016 by Member 12328896

HiCan any one plese help me in retreiving the latest Startdate record with its corresponding record using calculated member in ssas. I have four dimension out of which two are date dimension and the last is department.EmployeeId StartDate EndDate Dept101 03/02/2013 01/01/2014...

How do i get the latest row based on the last start date

15 Feb 2016 by OriginalGriff

Just use a JOIN:SELECT a.EmployeeId, a.StartDate, a.EndDate, a.Dept FROM MyTable aJOIN (SELECT EmployeeID, MAX(StartDate) AS maxSD FROM MyTable GROUP BY EmployeeId) bON a.EmployeeId = b.EmployeeId AND a.StartDate = b.maxSD

How to keep the structure of the tablix when there is no data to show

24 Feb 2016 by Member 11931581

We have a SSRS report which shows the result of a dataset in a tablix. If the query in the dataset returns no data, the header of the Tablix gets displayed but not the tablix cells below the header. I know there is a property to NoRowMessage, but in fact it is not what we want. Because when I...

How to fetch data from cube ssas

7 Mar 2016 by Member-515487

select * from openquery(BILS,'WITH MEMBER [Measures].[ParameterCaption] AS [ServiceOwner].[Owner].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [ServiceOwner].[Owner].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS...

How to fetch data from cube ssas

7 Mar 2016 by Maciej Los

Please, take a look here: Retrieve data from sql cube[^]Both answers refer to ADOMD.NET[^] framework.

SSAS tabular model :data not showing in excel after refresh in old excel but same time when refresh new template data appers in that both are conencted same server

27 Jul 2016 by ravi.jain0310

data not showing after refresh excel SSAS tabular model. When user refresh old excel template data not refresh not showing new data in old template for some users. At other end some users used new excel template and after they refresh new data appears in new excel template . Both excel are...

I need sample techniacl solution design document

29 Jul 2016 by OriginalGriff

Google is your friend: Be nice and visit him often. He can answer questions a lot more quickly than posting them here...A very quick search gave over 90,000 hits: sample technical solution design document for create report from ssas - Google Search[^]In future, please try to do at least...

Is there any way to rename an existing calculated measure with a new name in SSAS?

9 Aug 2016 by Swagata Chakraborty

Is there any way to rename an existing measure ?For example , I have one measure "No of Cards" , which I need to update as "No of new cards" with the same column id . But I am unable to do so .Also , SSAS is not allowing me to delete the old measure .What I have tried:I have changed the...

Add column in existing MDX.

22 Aug 2016 by Member 10833473

hi,I need to add a column in existing MDX and its values should be 1,1,1,1, and 2,2,2 like below. Please refer below values which are under column 'measure code'.Top line income 1Products (GL) 1 Net Interest Income (NII) 1Non Interest Revenue (NIR) ...

How to calculate sum in SSAS based on measure & dimension

13 Feb 2017 by Member 12999924

You an calculate the sum likesum ({[Set Expression]},[Measure.Count of Cases])That is sum({[Case Assigned CommitteId].[id].[id]},[Measure.Count of Cases])-sum({Case Closed CommitteId].[id].id]},[Measure.Count of Cases])

WTD calculation not working in SSAS

21 Aug 2017 by Member 11479116

Hi I am creating WTD Calculation into SSAS but it is mot working as my expectations,I want to Week to Week data from this measure for example when I select Sunday it will return 7 days data from Sunday to Saturday. When I select Monday it will return Monday to Sunday Data. What I have tried: ...

About set profile input XML with a variable data profile task SSIS

20 Sep 2017 by leocode7

Hello Everyone, Please Tell me if is possible to set the property ProfileInputXml of the Data Profile Task in SSIS with a variable, because i want to set the property dinamically with expression options, I Attached a image to show more better the problem. Bugs - Google Drive[^] If there is a...

How to pass particular string name in mdx parameter

3 Jan 2018 by BinnyVishwant

i have an input parameter value "Europe - DMS Finland". but i need to input only finland to the mdx query to fetch the required data result. What I have tried: i have tried this in where condition in mdx: where strtomember((right(@ManagementGroup,7))) but still the complete value is passing...

How to pass a parameter in mdx?

9 Jan 2018 by BinnyVishwant

I have a parameter value 'SF - LYON' while trying to pass in where condition: MEMBER [Measures].[ParameterCaption] AS [Organization].[Organization].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[Parametervalue] AS [Organization].[Organization].CurrentMember.UNIQUENAME MEMBER...

Import .asdatabase files into visual studio 2015

16 Apr 2018 by Member 13721041

Hi.. I have "Analysis Services Database Deployment contents" (.asdatabase) files.. How do i import them into Visual studio 2015. Please someone help me with a solution ASAP. Thanks.. What I have tried: Tried importing them through Visual studio Tools-> Import and Export settings.

Can sap lumira connect with ssas cube

5 Jul 2018 by CHill60

Have you even tried searching for yourself? Google Search[^] You may get a full answer from the SAP Support Services[^] After doing some (your own) research, if you still have a problem come back with details of how you are trying to connect and any error messages you encounter, then we may be...

How can you load an existing MDX query into SSAS's MDX editor?

15 Sep 2018 by Member 12824529

I have an existing sizable MDX query and need to modify it slightly without having to rewrite the entire MDX. I opened SSAS, selected my cube, right-clicked, and clicked Browse to open the MDX query editor. There, similar to graphically building SQL in SSMS, I can graphically build a new MDX...

Business intelligence developer to data scientist

16 Sep 2018 by nishant damani

Hello everyone i am a Business Intelligence developer working in SSIS, SSAS SSRS and SQL with 3 year of experience, now i want to take my career a step ahead and want to become data scientist so can anyone guide me on what to learn R or python, also what other things should i learn in order to...

How do I achieve proper aggregation using following MDX?

2 Sep 2019 by cluelessentity

I have the following MDX: SCOPE ([measures].[std_mg_qst_sup_olap]); SCOPE ([d_std_dim_questionnaire].[l_std_dim_questionnaire_key].[l_std_dim_questionnaire_key].members); THIS = sum( [d_std_dim_questionnaire].[l_std_dim_questionnaire_key].currentmember,...

Not able to filter data using two different dimensions

20 Feb 2020 by Kishan053

I want to create account receivable aging report from cube, in that I want to filter out measure with month and date of service, Does any one have example?? What I have tried: I tried but it always receive total amount of month but not getting...

What should I install first visual studio or SQL server

17 Jun 2021 by satish kumar Jun2021

Hi Team, This is satish kumar, i am facing issue with Visual Studio, to work on BI, i installed first visual studio next sql server, individual applications working fine, but coming to visual studio some services are not running, here my...

What should I install first visual studio or SQL server

17 Jun 2021 by OriginalGriff

SQL Server - VS will use an instance if it finds it (and it's newer than it's trying to install) but if you do it afterwards SQL server can remove the VS version and cause problems. I've had this with earlier version of VS, so I always do it that...

Introduction to Percolator Analysis Services LINQ to MDX ORM

4 Jan 2015 by Suffyan Asad

Percolator Analysis Services is a LINQ to MDX ORM that enables writing MDX Queries in LINQ instead of using hard-coded strings of MDX code, resulting in cleaner, easier to read and easier to maintain code.