.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Register
 
Win Surprise Gifts!!!
Congratulations!!!


Top 5 Contributors of the Month
Easy Web
Imran Ghani
Post New Web Links

Selecting multiple dimensions members

Posted By:      Posted Date: September 28, 2010    Points: 0   Category :Sql Server
 

I select multilple dimensions, for instance [dim 1].[atrr hier].allmembers * [dim 2].[dim attr].allmembers ..*[dim 3].[dim attr].[dim 8] and a measure, which is linked to all dimensions .

Since 2 dimensions have grown larger lately, and given large number of dimensions queried, performance degrade has grown to unacceptable levels.

What is the best way to select only these members which are actually relevant? I'm well known with the filter statement but do we have alternatives?


Business Intelligence professional


View Complete Post


More Related Resource Links

T-SQL linear regression in multiple dimensions

  
Hi! I'm trying to make linear regression T-SQL in multiple dimensions  (y = a + a1*x1+ ... a2*xn) like LINEST function in Excel.I need create a similar stored procedure in SQL Server.I also created the code using the article http://charlottecredittechnology.blogspot.com/2008/11/sql-2008-excel-like-linest-function.html but i have troubles in re-adapt to a model with multiple dimensions...thanks!

Is it possible to create attribute relationship across multiple dimensions?

  
In other data warehouse tools such as Microstrategy, you can create attribute relationship between different dimensions easily. For example, I can define a joint-child relationship(Attr1 from Dim1, Attr2 from Dim2) decide Attr3 from Dim3. In another word, if it is in a natrual hierarchy, it is                                   Attr3                                      |                             (Attr1, Attr2) If we can build such kind of relationship, first Attr3(dim3) is not necessary to appear in fact table. Second, if query without fact data, you can simple pull out Attr1, Attr2 and Attr3 relationship. Is it possible to make such kind of relationship in SSAS? If not, I think put Dim3 in fact table should be an alternative way to relate Attr1, Attr2 and Attr3.    

Selecting Unique Combinations of multiple row values

  

Hi,

I have a table called 'Permutations' that lists every single combination of 5 numbers that could be selected from numbers 1 to 10.

(the first few rows are as follows, there are 30240 in total):

 

Number 1| Number 2| Number 3| Number 4| Number 5|

1 | 2 | 3 | 4 | 5

2 | 3 | 4 | 5 | 1

3 | 4 | 5 | 1 | 2

4 | 5 | 1 | 2 | 3

5 | 1 | 2 | 3 | 4

2| 3 | 4 | 5 | 6

3 | 4 | 5 | 6 | 2

 

and so on.

 

I want to write a query that only returns the unique combinations of these. So, from the rows provided above, the only rows that the query would return would be

Number 1| Number 2| Number 3| Number 4| Number 5|

1 | 2 | 3 | 4 | 5
2 | 3 | 4 | 5 | 6

Is there an easy way of doing this (note that the correct query would return 252 rows)?

Thanks


problem in selecting deslecting multiple records in grid view by clicking control key.plz help

  

i want to select/deselect multiple records inside grid view by clicking control key.I can do the selection but the deselection is not working properly..there is some thing wrong in the  logic.plz help me to solve the problem.

my java script function is like..

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

    function FillColor(cellid, id, evt) {
    
        var isSelected = document.getElementById('<%=hidSelectedRow.ClientID%>');
        alert(cellid);
        if (!evt) var evt = window.event;
        ctrlPressed = evt.ctrlKey;
        if (!ctrlPressed) {
            //alert(ctrlPressed);
            var clearCellColor = document.getElementById('hidCellId').value.split(',');
            for (i = 0; i < clearCellColor.length; i++) {
                document.getElementById(clearCellColor[i]).bgCol

problem in selecting deslecting multiple records in grid view by clicking control key through java

  

i want to select/deselect multiple records inside grid view by clicking control key.I can do the selection but the deselection is not working properly..there is some thing wrong in the  logic.plz help me to solve the problem.

my java script function is like..

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

    function FillColor(cellid, id, evt) {
    
        var isSelected = document.getElementById('<%=hidSelectedRow.ClientID%>');
        alert(cellid);
        if (!evt) var evt = window.event;
        ctrlPressed = evt.ctrlKey;
        if (!ctrlPressed) {
            //alert(ctrlPressed);
            var clearCellColor = document.getElementById('hidCellId').value.split(',');
            for (i = 0; i < clearCellColor.length; i++) {
                document.getElementById(clearCellColor[i]).bgC

A query for selecting on dimension members

  

Hello,

Is there a way to write a query for selecting only dimension members without any measures? I'm trying to select the members by using "ON 0", but then I get a result containing 1 row and 0 columns and I want to get a list of the members, like what I get when using Excel and dragging a hierarchy / attribute to the row labels section.

Thanks.


Ratio to Parent by Multiple Dimensions on both Row and Column Axes

  

Hi,

I recently read "Percentage of Parent for all dimensions" thread ...To say the least, it was eye-opening...The amount of effort and detailed explanation that Tomislav Piasevoli put in was tremendous and helpful. I'm doing the same thing for our BI requirements, and I practically copied the entire code and see that it works for dimensions that are being identified on both Axes (Column / Row). However, the code is not a perfect solution for my situation.It seems that the calculation only works for any single Dimension on each Axis.  If I select more than one dimension onto the Colum / Row axes, the results came out incorrectly for the inner dimensions.


Note that: The possible dimensions that will be used for the "Ratio to Parent" are as follows:

Geography

sharing a multivalue parameter of the report accross multiple dimensions ?

  

My problem is quite simple : I'm generating a report that uses 2 cubes as sources. The 2 cubes have a time dimensions. 

These time dimensions are multivalued parameters for the report.

Today the user needs to select multiple time the periods he's looking for. I would like him to select his values only once and then pass them to all the parameters.

For example, he would select Q1 2009, Q1 2010, Q2 2010 and all the time parameters would take these values.

Any idea ?


how to create multiple dimensions on single parent column

  

How i cant create multiple dimensions on single parent column? 

This is the senario

 

Workflow fact table

Wf_id (int)

Source_Department_ID

Service_Department_ID

Created_Date

Etc

 

Department Dimension Table

Dept_id

DepartmentName

 

Now if i create dimension from dimdept , it have only one department name column, how i can use this same lookup to represent the service and source department names? Same senario pops up in sales fact tables as well , like manage_id and salesman_id both looks up to same parent table "Emp_id"


Selecting data from multiple tables whilst using a union statement.

  

Hi,

any help on this would be great.

I basically have a series of tables from one database that have an identical structure thus making retrieval of all records fairly easy (I just use a UNION ALL statement). However I need a list of values from another table within a different  database that contains information regarding the group of the data.

I so far have the following:

SELECT Table1.* FROM Table1 UNION ALL SELECT Table2.* FROM Table2 UNION ALL SELECT Table3.* FROM Table3 UNION SELECT Database.dbo.SRFILE.SR_GROUP FROM Database.dbo.SRFILE INNER JOIN Database.dbo.SRFILE.SRONUMBER = Table1.Incidentx

I keep receiving a unable to parse message however all I need to retreive is the SR_GROUP value but just don't know the correct syntax. Is it actually possible to do this as the structure of SRFILE is not the same as Table1/2/3.

Thanks again,

Jas


Filter on Multiple Dimensions

  

Hello,

 

I am trying to get a value of measure based on 2 conditions from 2 dimensions. So what I want is No of Hours (Measure) when Account from [COA AHC] dimension = 902000 and Account Unit from [Levels] dimension is 1400. Here is what I have:

select [Measures].[No Of Hoursin Period] on 0,

NON EMPTY FILTER({[COA AHC].[ACCOUNT].[ALL].CHILDREN,[COA AHC].[ACCOUNT].ITEM(0).MEMBERVALUE =902000},

{[LEVELS].[ACCOUNTING UNIT].[ALL].CHILDREN,[LEVELS].[ACCOUNTING UNIT].ITEM(0).MEMBERVALUE=1400})on 1

FROM [FINANCE]

 

I keep getting an error. What am I doing wrong? Please help me.

Thanks,

KJ


Multiple database support with Entity Framework

  
One of the features introduced in Entity Framework is being database independent. Which mean each database provider can support Entity Framework by implementing its provider.

This feature allows you build applications independent from the underplaying database provider. In this post I'm going to show how to build an application that support multiple databases using same conceptual model made by Entity Framework.

Binding the multiple drop down boxes in GridView using JQuery in ASP.NET

  
Here is the code for binding the multiple drop down boxes in GridView using JQuery in ASP.NET

Upload Multiple File using JQuery in asp.net

  
In this article I have explained how to upload multiple files using file upload control. I have used jQuery plugin for uploading multiple files.

I have also explained how to check for file type, file maximum size limit using jQuery & also using server side validation code.

Adding Multiple Columns and Rows in GridView without using a Database

  
This article describes on how to add multiple columns and rows in GridView without using a database. Basically the GridView will be populated with data based on the values entered in each TextBoxes on Button Click and retain the GridView data on post back.

GridView Multiple Filter AJAX Control

  
This AJAX control enables the user to filter data within any column inside a GridView. The user can add multiple filters and can delete existing ones too.

Multiple Column Dropdownlist for the ASP.NET DataGrid

  
Based on my previous control "Multiple Column DropDownList for ASP.NET", I received many emails asking for the same control to be used in the DataGrid for web applications. Here we go.. This control can be used as the regular MS DropDownList in the DataGrid and also as a regular dropdownlist. It has all the properties, like DataTextField, DataValueField, DataSource, SelectedIndex etc. The download file contains the samples both in VB.NET and C#. In this sample, I have used the Northwind database of SQL Server.
Categories: 
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend