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

Top 5 Contributors of the Month
david stephan
Gaurav Pal
Post New Web Links

SSAS Beginner Question

Posted By:      Posted Date: October 13, 2010    Points: 0   Category :Sql Server
As the title states, I am new to SSAS. My question is related to my cube design which I think is incorrect. I have 3 tables, Invoices, invoice details and journal postings. Invoices holds the invoice number, invoice details is related to invoices by invoice number and holds the amount billed. Journal is also related to invoices by invoice number and holds the post date. when I browse my cube I select invoices.invoice number as rows and amt billed as columns. unfortunately, it is showing my the full sum for every row regardless of invoice number. Any ideas?

View Complete Post

More Related Resource Links

SSAS newbie question

Hi Guys, I come from a SAP BW background, and i was wondering if i need to learn SSIS and SSRS together with SSAS in order to get a job? A insight into the current job market would also be helpfful. Thanks!

I need a workflow triggered by a workflow...how do I design this? Beginner question

I've added the Approval workflow to a forms library and it generates the necessary tasks and emails for 2 levels (serial) of Approval on the form. When the form has been approved the 2nd time, I want it to trigger another workflow that notifies a 3rd person of the existence of the form and assigns her a separate non-approval task. I'm creating it in SharePoint Designer, and I can do most of it, but I'm not sure what field I'm looking for, at the beginning in order to start the workflow. Currently, there is no column for Approval Status in the form library, only a column that shows the status of the workflow (In Progress or Approved).  I tried If Workflow Status equals Approved then email.... but that didn't work. Any help is greatly appreciated.  I'm looking for the data source field and the list item field and value, I guess.  

Beginner question about eliminating Dups

I looked at a couple of links about eliminating dups. One  link suggested RowNUmber() function which is fine for 2005 (but I wanted something that would also work on 2000).  Another link was a MS article advising to select the dups into a temporary table. http://support.microsoft.com/kb/139444/en-us I found this article confusing, and I don't see why it suggests we need a holding table. So I propose this approach - is there any reason NOT to do it my way? (Is there a bug here I'm overlooking?) IF EXISTS(SELECT 1 FROM sys.tables WHERE NAME = 'Facilities' ) DROP Table dbo.Facilities; CREATE TABLE [dbo].[Facilities] ( [ID] int IDENTITY, [FacNo] varChar(3) , [theState] varchar(2) ) INSERT INTO Facilities ([FacNo], theState)VALUES ('1', 'FL') INSERT INTO Facilities ([FacNo], theState)VALUES ('7', 'FL') INSERT INTO Facilities ([FacNo], theState)VALUES ('25', 'FL') --- DUPLICATE THE FIRST THREE ROWS INSERT INTO Facilities ([FacNo], theState)VALUES ('1', 'FL') INSERT INTO Facilities ([FacNo], theState)VALUES ('7', 'FL') INSERT INTO Facilities ([FacNo], theState)VALUES ('25', 'FL') -- ADD some new rows. INSERT INTO Facilities ([FacNo], theState)VALUES ('4', 'VA' ) INSERT INTO Facilities ([FacNo], theState)VALUES ('5', 'VA' ) INSERT INTO Facilities ([FacNo], theState)VALUES ('10','Va') INSERT INTO

Beginner question: Passing the output of one Activity to the Input of another


Hi, I am brand new to WF so forgive what might be a simple question.

I am creating multiple activities which will execute in a sequence and pass data down the chain.  I know that one way to do this is to set a context variable in the parent Sequence from Activity A, and then read this value in Activity B (thus the output of A is effectively the input of B).

I'm fine using this technique, but if there is a way to directly declare that the input of Activity B should be the output of Activity A, I'd prefer this.  I'm intrigued by this comment in the new Activity template:

        // If your activity returns a value, derive from CodeActivity<TResult>
        // and return the value from the Execute method.

What is the point of returning a value from an Activity?  Can this return value be read somehow by the next Activity in the sequence?  I'd like to set the input of Activity B to the return value (output) of Activity A.  How would I do this?


Mike Vargas

Beginner question: get selected value of Html.DropDownList


Hi everyone, how are you doing!

I'm just started learning MVC 2. I went through the music store example (though I don't 100% get everything). Now I want to add some functions to the page to learn more. I added paging, and now I want to add search combo boxes (drop down lists). Basically, in the album list screen, I want to add 1 drop down list of genre. If user select 1 genre then click Search, the page should show all album of that genre only.

My problem is I don't know how to get the selected value of this drop down list. The approach I am using now is to get the selected value, then put it as parameter and redirect to Index (/StoreManager/Index?searchGerneId=x). I searched through many posts but couldn't find a solution that works for me. It is probably because I don't really get MVC yet and still try to do things the code-behind way. So please help me :) My code  for Index in Controller is below

public ActionResult Index(int pageNumber = 1, int searchGenreId = -1)
            var albums = from album in storeDB.Albums
                         join genre in storeDB.Genres on album.GenreId equals genre.GenreId
                         join artist in storeDB.Artists on album.ArtistId equals artist.ArtistId
                         orderby album.Title
                         select al

Total beginner question...sorry


Just started programming with ASP.net about a week ago.....  I'm trying to figure out why this isn't working....

I'm trying to retireve an image URL from a database.  They are saved as strings in the table (i.e. 20.jpg, 21.jpg, etc.).  When I have the images saved in the root folder, I can access them just fine with the following ItemTemplate repeater line....

<img src="<%#Eval("piclink")%>" />

Obviously, I don't want to have a whole mash of JPEG files sitting in my root directory.  I suppose I could just use an absolute path, but how would I go about using a relative one?  I tried this...

<img src="</pictures/%#Eval("piclink")%>" />   

And this....   

<img src="<../pictures/%#Eval("piclink")%>" />

And still get nothing.


Beginner MDX Question how do i get Last member with data

I'm pretty new to Mdx, and have only used it a few times before. So this is probably a really simple question.

First and foremost, I trying to get the Last Week with Data(or last completed week) from the system (it should be Week 9, which is 201009). 
Secondly, I need sums for the last 4 , 13, and 52 weeks. I tried using the LastPeriod function which seems to work perfectly, if only i could get the SUMS of these, instead of each period individually. How do i sum a last period? 
So it should look like this
LWK         L4WK         L13WK         L52WK
598          3000          12000          87000

Thanks for the help!

([Measures].[PL Gross Sales Amt], [Time].[Fiscal Week].&[201009]) ,
([Measures].[PL Gross Sales Amt] , LASTPERIODS (4,[Time].[Fiscal Week].&[201009])),
([Measures].[PL Gross Sales Amt], LASTPERIODS (13,[Time].[Fiscal Week].&[201009])),
([Measures].[PL Gross Sales Amt], LASTPERIODS (52,[Time].[Fiscal Week].&[201009]))
[Time].[Fiscal Year]
WHERE ([Source].[Sources].[Description].&[Posted Navision Sales], 
[Bill To Cust

Beginner Question on reporting service and deployment


Today is the first day that I am trying to create a simple report using SQL Server Reporting services. I god some issues and couple of questions and would like to ask here

1. I created a report model (with two relational tables). Can I create a report based on this report model? The reason, I like to give this model to users so that they can do their customize reports by drag and drop fields (This is similar to creating Universe in the Business object)

2. I created a test report in 'report server project' Using Visual studio (Which comes with SQL Server 2005 reporting service installation). When I try to run that report, it is asking me to define 'TargetServerURL'. I gave the same machine that I am  url (http://srv-test/reportserver), but still I am getting error. Is this the way that I should define? Or should I configure a new server with reporting services installed for deployment?

I know these questions are kind of stupid questions, but as a beginner, I need some basic help to start







Dreaming a world without any war in anywhere

Beginner Question - Where is the best place to start learning SQL? Difference between DBA and Devel

Question says it all.  Thinking about changing gears in my profession possibly to something like SQL.  I'm not sure really where or in which direction to go.  Thoughts?  Thanks.

SSAS task processAdd question


Hi, I've been doing some tests and im not sure of the info I've found online.  The first problem is that I can't get the processAdd option appear when configuring my dimensions although I've already process my cube with full processing twice, is there anything else I need to check ?


Also, I have dimensions that may change (only insertions no deletions or updates), will a process Data or process add work on the dimensions  followed by a process incremental on the partitions, and a process index on the old ones not being modified ?

Is it a good plan ? cuz im not sure if when I do a process add or process data on the dimensions the measure groups get modified (new aggregations added)



Writeback expression question - Weighted Allocation (SSAS 2008 SP2)




I'm trying to nail down the behaviour of writeback.

The Expression needs to change depending on how the value should be allocated.


E.g. If I want to spread a value to the leaf level funds then:



[Fund.Currentmember, Measures.Value] / [Fund.All, Measures.Value]


I've noticed that the expression should cater for each dimension that needs to be spread.

So if it is by fund, and by product then it should have:


[Fund.Currentmember, Product.CurrentMember, Measures.Value]


[Fund.All, Product.All, Measures.Value]


I've also found that if I need to allocate a value to an actual leaf level value, then the denominator should also carry a current member for that dimension. (I don't want to divide the value of the current member by the all level)


Eg. If I want to capture a value against a particular fund, then the weighted expression would look like this:


[Fund.Currentmember, Product.CurrentMember, Measures.Value]


[Fund.Currentmember, Product.All, Measures.Value]


What I'm trying to figure out is this:


What if I want to spread a value by a grouping attribute?

Example, if there was a Fund Group attribute that held multipl

Training Question - Connection Refused Error in Browsing A Cube In SSAS


I am an instructor for a data warehouse design and implementation course at a local college, and I have run into a problem that I have not been able to fix.  Hopefully someone out there can help.  It is the first time this course is being taught in a new lab where we are running SQLExpress 2008 Developer Edition, with a local server instance installed on each workstation, using Windows authentication; this configuration was done by our local LAN/network manager.  We have created a Management Studio source database and a Management Studio warehouse database, using a star schema design.  We have successfully created SSIS packages to extract from the source tables and populate the warehouse tables.  We have been able to create a DSV in SSAS.  When we attempt to process and browse the cube, it fails with a connection refused error from the server.  Configuration Manager tells me the SSAS server process is running.  The data connection works when checked.  We get the same error regardless of which impersonation option is selected. What have I missed?  Can the configuration be adjusted to get around this?  I have spent several hours trying everything I could think of, with no success - it is getting frustrating.

Please advise.  Thanks in advance.

SSAS Dimension Question



Is it possible to display the all of the elements of two separate dimensions on a report?

For example, lets say I have two dimensions, one called Produce(containing Vegetables and Fruit) and another called TypesOfFruit(containing Apples and Bananas).  Is it possible to get output displayed like this

Vegetables  Fruit 

                 Apples Bananas

instead of


Apples Bananas

The problem is that one of my dimensions does not contain all of the elements of the other dimension.  In the case above, Vegetables are excluded from the report because there are no vegetables in the TypesOfFruit dimension. 

Any help is greatly appreciated!


SSAS Deployment and Scheduled Processing Question

So, I originally asked a question about how to deploy a cube to production, and I'm finally at the point where it is deployed, and everything seems to work. However, my SSIS packages are now feeding data into my relational DB (the source of my cube) on a daily basis. How does the cube get refreshed with the new data? I assume I'm not going to deploy every night, and I'm not making any structural changes. So how do I schedule the cube to be refreshed with new data?

Beginner's book for ado.net 2.0



Can anyone suggest me a book for beginners in ADO.NET 2.0 ? 

Some basic MVC question

  1. In regular asp net I can run (debug) the application but I can either "view in browser" that gives me the option to view the application and write code on same time.

In MVC I can't find this option.

  1. What is the basic DATA MODEL for working with SQL DB.

I mean with no any framework (entity framework, Sub sonic, Link to SQL etc')

I look for basic application that works with data but with no fw.

  1. What is the popular DB framework that working with data.
  2.  I am looking on  mvc series


C# Soup To Nuts  (the best series ever)


I watch some of the MVC video, seems that the music store is good but I have to wait to the other part.

Does any one know and recommend   a Microsoft MVC tutorial?





Beginner: this doesn't make sense to me


Do you need and "empty" script tag in the head to run scripts that are in the body?  Also, can you run JQuery scripts if they're in the <head> tag?  The first sample only works if the JQuery script is in the form (and body) tag, not in the head - even if I add $(document).ready(function() { });

This works

<head runat="server">
<script type="text/javascript" src="http://ajax.googleapis.com/ajax/libs/jquery/1.4.2/jquery.min.js" />
<script type="text/javascript">
<form id="form1" runat="server">
<a href="">Here is a link</a>
<script type="text/javascript">
$('a').click(function () {
alert("you clicked me!");


This doesn't work.  Notice I removed the second <script> tag from the head

<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="serve
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