.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

Problems with creating a set or filter

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


I have a cube with several measures in it. I also have 2 time dimensions called Repoting Date (RD) and Business date (BD). The reporting date dimension is pretty small only containing the dates as the end of the month. The business date dimension is a normal time dimension on day basis.

Now I want to create a set  or filter where the reporting date is the same as the business date. And that should apply to all measures.

So I should get (BD.Date.2010-01-31, RD.Date.2010-01-31), (BD.Date.2010-02-28,RD.Date.2010-02-28)

Any thoughts on this one ?



View Complete Post

More Related Resource Links

Problems creating a BDC file that use a unique select statment


I'm trying to build an BDC file that will pull information back from two tables in an Oracle database, I can import it without any errors, but then it tells me I do not have a filter when I try and select an item.  When I add a filter I get an error when I import the file.  The error I get is the following.
"Application definition import failed. The following error occurred: The IdentifierName Attribute of the TypeDescriptor named 'TestDate' of the Parameter named ':TestDate' of the Method named 'Get_TestTwelve_List' of the Entity named 'TestTwelve' does not match any of the defined Identifiers for the Entity. Error was encountered at or just before Line: '133' and Position: '16'."

Here is the section of

      <Property Name="RdbCommandText" Type="System.String"><![CDATA[

Creating cascading dropdowns - Unable to add filter

Hi all ! I'm trying to learn about how to create cascading dropdowns.In fact I found good explainations, but something very weird is happening... When I click on the filter (using external datasource) a message like 'There is no support atr the web form of infopatrh 2007 for filter' (or something like this).Then the buttons to add, modify, etc appear disabled to me. Any hint, felas ?

Problems while creating the Stored Procedures with Concatination

Hi I am creating one Stored Procedure where want to use concatination in that. For that I had written the query but I am unable to do it, so I need help for this. My SQL query is: SET QUOTED_IDENTIFIER ON CREATE PROCEDURE Team @Int VARCHAR(5), @str VARCHAR(150), AS SELECT * FROM Emp WHERE ID = @Int + '@str' Go In @str is we are passing the value at run time (like @str =AND NAME = 'Test') Actuall quey is: SELECT * FROM Emp WHERE ID = 1 AND NAME = 'Test' Thanks in advance Amit

Problems with creating webs (some pages and lists doesnt exists)



I am trying SP2010 and I have main web collection. In collection anything seems allrigt. But if I create a new site (for example team site), I can't reach site settings and some other problems. When I try site settings, sharepoint returns me his 404 Error. File cannot be found. If I use directive ServerRelativeUrl in some webpart via Visual Studio, webpart returns only root "/". If I want to show and manage lists, all lists are linked to the root site in collection. For example I have collection http://share2010/ . In this site I have Lists Pages and Images. In this collection I create new site Subpage with address http://share2010/subpage . In http://share2010/ site settings works fine. In http://share2010/subpage dont. And in http://share2010/subpage "list of lists" linking http://share2010/Lists/Pages and http://share2010/Lists/Images. But I need http://share2010/subpage/Lists/Pages. Can anyone help me?

Problems Creating a new site collection


Hi all,

I am attemping to create a new site collection in code. This works fine on my test box, but when I moved it to production I keep getting access denied. Here is some of the code I am using:

Protected Sub btnCreate_Click(ByVal sender As Object, ByVal e As EventArgs) Handles btnCreate.Click

        'Create the new site collection
        Dim elevatedCode As New SPSecurity.CodeToRunElevated(AddressOf CreateSite)

  End Sub ' End btnCreate_Click
''' <summary>
  ''' Create the new site collection
  ''' </summar

I have some problems creating a wizard in MVC


Hello! This is my first post here but i have read a lot of helpful threads before, so, thank you for all your answers :)
Now, I have a problem with an application. I want to create a Wizard using MVC. In this picture you can see the main structure:

Having Problems creating a development copy of a fairly complex live site, sharepoint 2007


Hi All,

I have inherited a sharepoint distribution from a previous set of contractors, which I am now trying to set up for a developer hired to fix a few bugs in custom code.
This sharepoint installation consists of a farm that includes the following: - Not Configured - Windows Sharepoint Services Incoming E-Mail, Windows Sharepoint  Services Web Application - Central Administration / Excel Calculation Services / Office Sharepoint Server Search / WSS Incoming email / WSS Web App - Office Sharepoint Server Search / WSS Incoming email / WSS web app

SQLCluster - WSS Database

I have a development machine with a single install of sharepoint / mssql 2005 that I would like to set up as a test server for code/database changes

I set out thus to export (stsadm -o export etc.) a copy of the live site, and import it into my test server. This gave me a lot of errors regarding features, which I looked up to be custom solutions that were not installed, so I installed those, and attempted the import again, this time another error regarding features missing. I checked the features/template directory and noticed on live there are a few features that are not listed in the solutions panel, these look to be mostly custom webparts

Problems Creating Age Bands After Calculating The Age From DOB Field


SELECT     CASE WHEN Client_Details_New.CliDOB IS NULL THEN 0 WHEN dateadd(year, datediff(year, Client_Details_New.CliDOB, getdate()),
                      Client_Details_New.CliDOB) > getdate() THEN datediff(year, Client_Details_New.CliDOB, getdate()) - 1 ELSE datediff(year, Client_Details_New.CliDOB,
                      getdate()) END AS Age, CASE WHEN Age BETWEEN 17 AND 25 THEN '17 - 25' ELSE 'Other' END AS AgeBands
FROM         Client_Details_New

My query is above ^^... when I execute the query it just says "Invalid Column Name 'Age'" - this error is showing for the 2nd case statement... not sure why im getting this error when I have set the column name "age" when doing the age calculation on the DOB field :S

any help is much apprecited!

Adobe I-Filter creating thousand of folders on system root.


I have adobe's v9 ilfilter installed with Sharepoint 2010 on a windows server 2008 r2 box. Indexing seems to working fine and pdf results are returned in a a sharepoint search.  My problem however is that thousands of directories are being created on the C:/ drive beginning with "A9R" followed by a bunch of numbers and letters with legitimate pdf documents (with normal documents names) inside. I read about a similar issue here http://forums.adobe.com/thread/707241?tstart=1 and here http://blogs.adobe.com/acrobat/2008/12/adobe_pdf_ifilter_9_for_64bit.html (about half way down the page). No one seems to have a solution let alone an explanation. Even more scary, is that I cannot seem to find any of these documents anywhere else.


Creating your SharePoint Governance Plan

One of the most common questions that I get from prospects as I'm talking to them about the creation of a governance plan and process is what does it look like. In other words, there are materials available which describe what should be in a governance plan but there isn't a ton of guidance on what the process of creating a governance plan and process are.

Creating Paging for a Repeater Control

A common question is "How do I implement paging within a Repeater?" Although the beauty of the Repeater control is its flexibility, you're on your own for building most functions. ASP.NET 2.0 has included some new controls that provide paging, as does the DataGrid in ASP.NET 1.1. However, this tip shows you how to roll your own paging for a simple data viewer.

Creating an AJAX Repeater in ASP.NET MVC

The "TaskList" is a tried an true example of the most basic thing that you can do in any framework. Unfortunately, I had some problems finding a really good example of all the steps necessary to get a task list to work in ASP.NET MVC 1.0.

Creating a Generic Entity Framework 4.0 Repository

With .NET 4.0 right around the corner, I thought it would be cool to download Visual Studio 2010 beta 2 and start playing around with the next release of Entity Framework.

The initial release of Entity Framework came with a great deal of criticism. To make matters worse, there was a large uproar when it was rumored that Microsoft would be abandoning LINQ to SQL, in favor of Entity Framework. This was because, at the time, many developers felt Entity Framework was an inferior technology to LINQ to SQL. To set things right, Microsoft proactively moved forward with improving Entity Framework, in time for the 4.0 release of the .NET Framework. This is good news because my initial impressions, so far, have been nothing but positive.

Top .NET Performance Problems and how to avoid them

Every time I work with one of our .NET customers to help them with managing their application performance I come across the same problems as seen with other clients before: lots of ADO.NET queries, many hidden exceptions in core or 3rd party .NET libraries, slow 3rd party components, inefficient custom code

Creating a Simple Class in C#

The second article in the C# Object-Oriented Programming tutorial describes how classes are created in C# and how behaviour, in the form of publicly visible and private, hidden methods can be added. This demonstrates some of the uses of encapsulation

Using jQuery to Filter Table Rows

The project is using the .net GridView control, so I had limited control over the output HTML code. Still, I think this code can work for most tables. One thing to notice: you should use the class "filterable" on your table or on one of its parents for the code to work.
First, we need a text box:

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.
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