Welcome :Guest
Congratulations!!!

Top 5 Contributors of the Month
ffttt

### how to perform write back in cube?

HI,

I want to perform write back operation in my sales cube.

Gaurav

### "WHERE" in Cube calculation

Hi Everyone, I am trying to put a where clause in the Cube calculation but not getting it to work.

Here is the actual calculation which works:

([DimTime].[TimeHierarchy].CurrentMember .Lag (1),[Measures].[Actual Hour])* 1.25

Now, I want to add a where clause to this calculation which looks something like this:

WHERE ([Company].[Department].CHILDREN - [Company].[Department] .&[Research)

### create calculation sas cube

how do write calcuation in ssas for caculated columns, here's syntax i have sql..

select (BIRTH_DT from dbo.HM_MEMBERSHIP

where (datediff(year,BIRTH_DT,GETDATE())) between  30  and 39

### SSAS 2008 - Occupancy Calculation Cube?

Hi there,

I have SQL 2005 table like

R1             2010-01-25           2010-01-28
R1             2010-01-28           2010-01-30
R1             2010-02-15           2010-02-17
R1             2001-02-20           NULL
R2             2010-01-31           2010-01-31
R2             2010-02-10

### Cube Calculation get Members of second last Level of a parent-child hierarchie

Hi everyone,

I have a parent-child-hierarchie, where the different branches has different lengths; for example the fist one is:

Level1 - aLevel2 -aLevel3 -atotal

and the second:

Level1 - bLevel2-bLevel3 - bLevel4 - bLevel5 - btotal

Now I need the memebers of the second last Level, so in the examle: aLevel3 and bLevel5

How can I get them?

### Is cube limit the number of calculation member?

Hi,

I develop new application and user can create new calculation member. So some one can tell me "how many Calculation member a cube can contain?"

Much thanks.

### AGE CALCULATION IN YEARS AND MONTHS

How to calculate childs age,but when i enter childs age as '03/27/2007' it returns 3 years where as actual age is 2 yr 11 months

### Using JQuery to perform Ajax calls in ASP.NET MVC

The muscle behind the actual asynchronous calls comes from JavaScript. I looked around at a bunch of existing JavaScript libraries and settled on JQuery because of the way it leverages existing CSS knowledge. The three things that the library should do easily are:

### How to Perform SQL Server Row-by-Row Operations Without Cursors

SQL cursors have been a curse to database programming for many years because of their poor performance. On the other hand, they are extremely useful because of their flexibility in allowing very detailed data manipulations at the row level. Using cursors against SQL Server tables can often be avoided by employing other methods, such as using derived tables, set-based queries, and temp tables

### calculation, field and map traverse adjustment, and coordinate transformation

Free Pocket PC land surveying software -- COGO calculation, field and map traverse adjustment, and coordinate transformation -- for students and professionals.

### ToggleDebugCompilation fails trying to perform "an unauthorised operation"

Hi,

We're having a problem with the Visual Studio 2008 RTW version of the web deployment projects on a colleagues machine. The project works fine if I run it on my machine, but when he tries to run it on his machine he gets:

`<SNIP : Most output removed>`
```  Task "Exec"
Command:
if exist ".\TempBuildDir\" rd /s /q ".\TempBuildDir\"
Updating Web.config <compilation> element debug attribute to 'True'.
C:\Program Files\MSBuild\Microsoft\WebDeployment\v9.0\Microsoft.WebDeployment.targets(639,7): error : Attempted to perform an unauthorized operation.
C:\Program Files\MSBuild\Microsoft\WebDeployment\v9.0\Microsoft.WebDeployment.targets(639,7): error MSB4018: The "ToggleDebugCompilation" task failed unexpectedly.
C:\Program Files\MSBuild\Microsoft\WebDeployment\v9.0\Microsoft.WebDeployment.targets(639,7): error MSB4018: System.ArgumentNullException: Parameter "message" cannot be null.
C:\Program Files\MSBuild\Microsoft\WebDeployment```

### Excel Services: Develop A Calculation Engine For Your Apps

The Excel Services architecture lets users design their own algorithms and share workbooks on a server.

Vishwas Lele and Pyush Kumar

MSDN Magazine August 2007

### Testing: Perform Code Coverage Analysis with .NET to Ensure Thorough Application Testing

When running your tests how do you know which parts of your product code are actually executed and tested? This article presents a complete system called Fundamental Function code coverage that operates at the method level. The author gives an overview of the system so you can understand code coverage principles, explains the key parts of the underlying code, and discusses how code coverage fits into the overall product development cycle. After reading this article you will be able to perform code coverage analysis on any .NET software system.

James McCaffrey

MSDN Magazine April 2004

### Error "user does not have permission to perform this operation" with User Instance = True.

I setup SQL Server 2005 / SQL Express. All works fine in SQL Server 2005.

I am connecting to a SQL Database from VS 2005,  Tools/Connect to Database. I set the Data Source to "Microsoft SQL Server Database File (SqlClient)" (meaning SQL Server Express) and User Instance = True, and Integrated Security = True.

The above is working successfully on all machines except my Laptop. On my Laptop, I am getting this error "user does not have permission to perform this operation". On my Laptop, if I change User Instance = False, it works fine. Also, If I connect to SQL Server 2005 it works fine only if User Instance = False.

I tried all kind of security changes, nothing worked. For example, I setup Everyone as Full Control for the Folder and the MDF File of SQL Server. I gave my user ID as sysadmin role in SQL Server Express. Also, I enabled creating User Instance form SQL Server Express, Nothing is working.

Tarek.

### Can not perform this operation.The file is no longer checked out or has been deleted?

In my sharepoint designer 2007, when I try to check in a file, it give me the following errors:

Can not perform this operation.The file is no longer checked out or has been deleted.

Thanks.

### Absence and vacation days webparts calculation

hi,

does any1 know if there is a webpart that can calculate an employee's vacation days. and when the employee request some vacation days it show the days that are left.

or is there a tutorial to create such a webpart?

thnx

### Can't perform Create, Update or Delete operations on 'Table(outbox)' because it has no primary ke

Hi,

I'm a beginner in asp.net and I have some problem inserting data into sql server 2005 with linq.

my code is :

Dim Result As New SMS.SendResult
If Result.status = 0 Then
Label1.Text = "Your Message Sent Successfuly"

Dim db As New IGSSDataContext
Dim out As New outbox With {.ClientID = intRandomNumber, .From = User.Identity.Name, .TO = TextBox1.TabIndex, _
.Time = Now, .Message = Message}
out.ID = (ID)
db.outboxes.InsertOnSubmit(out)
db.SubmitChanges()

TextBox1.Text = ""
&nb

 Categories:
 ASP.Net Windows Application .NET Framework C# VB.Net ADO.Net Sql Server SharePoint Silverlight Others All