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

Hi all,
I am trying to calculate rank of the objects based on sales.
It should only change for date dimension.
For all other dimension attributes, it should remain the same.
Please help me out.
Thanks,
Sam

I have a calculated column in a list called Days Open. This column contains the number of days between today (Sysdate) and another column called the Effective Date. Therefore, if Sysdate is 11/16/2010 and the Effective Date is 10/14/2010,
how do I calculate the number of days between the two dates?

I tried using this formula: =TEXT(Sysdate-[Effective Date],"h")
and then I tried =INT(Sysdate-Effective Date) & TEXT(Sysdate-Effective Date, ":hh:mm")

Neither formula worked. I hope it is something real simple that I am missing here. Any help you can provide will be highly appreciated!

This page presents a variety of calculations for latitude/longitude points, with the formulÃÂ¦ and code fragments for implementing them.

All these formulÃÂ¦ are for calculations on the basis of a spherical earth (ignoring ellipsoidal effects) - which is accurate enough* for most purposes. [In fact, the earth is very slightly ellipsoidal; using a spherical model gives errors typically up to 0.3% - see notes for further details].

We offer many Global Database Products that you can use with the below formulas to calculate distances and many other uses. Not sure how to use distance calculations or global databases within your company? See our Global Database Examples for more information on how to use our data within your industry. Be sure to Download a Free Sample of one of our many Global Database Products.

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

I have tried searching all over the web for this logic. Got many but half of them did not match what i was looking for and half were malfunctioning.

I want to calculate business working hours between 2 datetime, where in I should be able to set the working hours as well as weekends and holidays should not be calculated.

Hi, Following code will help the developer to calculate exact client height in all browsers.script language="javascript" type="text/javascript">var winW = 630, winH = 460;if (parseInt(navigator.appVersion)>3) {if (navigator.appName

how do I go about generating formulas for something like this.

I have a field( choice ) that has three choices (Low, Medium and High ). If I choose Low, I need to add 5 days to the current date( excluding weekends ) and place it in the Target date field, the same goes for Medium = 3 days( exclude weekends) , High =
1 day, exclude weekends.

Is there anyway where we can use KPI list to attach to a SharePoint list and indicates which item was clicked the most ? Or any other way to find out the best 5 links based on how many times they were accessed by a user?

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.

Hi fellows
I dont know how to rewrite my MDX in order to get the correct result.
The following MDX statement is reduced to a minimum in order to explain my problem:
WITH
MEMBER [Article].[Article].[Article_CE]
AS AGGREGATE ([Article].[Article].[Article_1], [Customer].[Customer].[Unknown], [Location].[Location].[USA])
SELECT
{[Measures].[SalesNet]
,[Measures].[Budget]
}
ON COLUMNS ,
NON EMPTY
[Customer].[Customer].[Customer].members
* {[Article].[Article].[Article].members
,[Article].[Article].[Article_CE]}
ON
ROWS
FROM
SALES
If i dont display the customer hierarchie "
[Customer].[Customer].[Customer].members
" on rows, then every thing works fine!
As Soon as I add the above customer hierarchie to my mdx statment, then every thin works fine except for my member "
[Article].[Article].[Article_CE]".
Instead of showing only one row for customer "Unknown" (see Member definition), a row appears for each customer and with the same SalesNet and Budget.
Any Idea how to rewrite my mdx ?
best regards Pellito

I have a list with workflows that was created for one of our clients that allows them to enter some information and the workflow takes care of sending emails to the necessary recipients as well as notifying the person the task is assigned to when it has
reached a certain status or age.
The "agent name" colum contains the agent's first and last name (ie John Smith). I am wondering if there is a way that in the workflow, when an email is generated, if I am able to remove the last name using some sort of text calculation. The
reason I would like to try and do it this way if possible is that if I add the Columns Agent First Name and Agent Last Name, the current Agent Name colum that is being used to generate the agent's name in the email will now not be the correct column to use
for this information and the 100s of entries already in the lists will not send out emails properly.
Does anyone have a suggestion for this, or know some sort of text calculation formula that I can use to remove the last name from the lookup in the email?

Hi, With the help of other members in this forum we created a solution to calculate percentile based on a dimension attribute (see Percentile Calculation ). However, performance is quite an issue - it takes about half a minute to calculate percentile on our cube (median calculation takes couple seconds). I do not think that our cube is an issue here because it also takes a while to compute it using Adwenture Works. How to improve the performance of query? Thanks

I wonder if somebody can help me with the following question.
I would like to create an enhancement to SSAS in a way so that one can pass in multiple values, run a calculation and in return retrieves not one but multiple cell results at the same time e.g.
retSet = functionABC(inSET) where inSet is somthing like 5 4 3 6 7 3 4 4 AND retSet is 4 6 7 8 9 3 4 4
All my calculated members in MDX return a single value BUT I need to have a calculation that if called returns multiple results (a set) at once and in a way so that Excel will properly pick up on it and consequently fills multiple cells
in the Pivot table.
Is that possible at all and if so how?
I would not mind to write a little CLR assembly to enhance the SSAS but don't know how to pass the results back.
Any ideas are highly appreciated.
Dirk

Hi,
i want to calculate the profit in percent from a P/L statement Dimension.
i use the following calculation:
CREATE MEMBER CURRENTCUBE.[Measures].[CompanyEarnings]
AS
(
sum( setIncome, [Saldo] )+
sum( setCosts, [Saldo] )
) / sum( setIncome, [Saldo] )
The Performance-Point Scorecard is Filtered by a Year-Month Hierarchy filter with the following Formular:
([Time].[Year - Month].[Month].&[2010-01-01T00:00:00]):<<UniqueName>>
This Formular works fine for the Months, but the sum for the Year is not calculating on only the selected months, its calculating on the hole year income and costs.
If i use a filter on a set with the same months which i hoped was selected with the Scorecard-Filter, it worked fine. Here is the filter which worked, but is not dynamic:
SET CURRENTCUBE.[setMonths]
AS {
[Time].[Month].&[2010-01-01T00:00:00],
[Time].[Month].&[2010-02-01T00:00:00],
[Time].[Month].&[2010-03-01T00:00:00],
[Time].[Month].&[2010-04-01T00:00:00],
[Time].[Month].&[2010-05-01T00:00:00],
[Time].[Month].&[2010-06-01T00:00:00],
[Time].[Month].&[2010-07-01T00:00:00]
};
If i change the function that it use this filter all calculations seems to be fine:
CREATE MEMBER CURRENTCUBE.[Measures].[CompanyEarnings]
AS
(
sum( setIncome, [Saldo] )+
sum( setCos

Hi, I'm having performance issue with calculated member (Running total) which is created on one dimension in the cube. Cube is having three dimension Product Details(Product Model, Product Type) , Time(Year & Month) & Qty type(In Qty
& Out qty). See below for details
Dimtime
Year (Values 2000 to 2020) Month
DimProd
Product No Product Type Product Group
DimQty Type
In Qty Out Qty
Fact Table
Product No Year Month Qty Type of Qty( In Qty or Out Qty )
My MDX query for calculated member is
CREATE MEMBER [Qty Type].[Qty Type].[All].[Total] as
SUM(NULL:[TimeDim].[Hierarchy].CurrentMember , ([Qty Type].[Qty Type].[In Qty], Measures.[Qty]) - ([Qty Type].[Qty Type].[Out Qty], Measures.[Qty])
The formula is --> Total = Previous Period Total Qty + Inqty - Out Qty
This works perfectly when i browse at higher level (Qty Type on Rows & Time On Columns), but when i browse the cube adding dimension Product Details( Product group or Product Type) to Drill-through the
In Qty & Out Qty, the query is running and after one hour also it's not finished. Can anyone help me to solve this or propose new structure to resolve this issue.

## How to create a calculation in a list - Calculate the number of days between two dates

I have a calculated column in a list called

Days Open.This column contains the number of days between today (Sysdate) and another column called the Effective Date. Therefore, if Sysdate is 11/16/2010 and the Effective Date is 10/14/2010, how do I calculate the number of days between the two dates?I tried using this formula:

=TEXT(Sysdate-[Effective Date],"h")and then I tried=INT(Sysdate-Effective Date) & TEXT(Sysdate-Effective Date, ":hh:mm")Neither formula worked. I hope it is something real simple that I am missing here. Any help you can provide will be highly appreciated!