Search results for query: *

Thanks for your response. Managed to find this article that discusses the topic:- http://msdn.microsoft.com/en-us/library/cc671625.aspx

During runtime, are the connections within the connection managers validated prior to varible population within package configuration? I have a suite of packages that I have developed that populate connection strings through parent variable assignment (the variable is then used to set the...

My end goal for this design is to have a cube that, for any question asked of it, will identify data based on the last/current account (DimAccount) – no double counting on the same account please. I thought semi additive functions would be the route to achieve this but, as I hope I have...

Did you use the measure to use the "ByAccount" aggregate function? To use this you need to configure the account table to be of type Accounts, the AccountReference field as type "Account" and the "AccountType" field as type AccountType. You then also need to relate AccountType to AccountReference.

the second one. i'm browsing the cube within SSAS and dragging [CurrentBalance] as the measure and DimAccount.Status as my row field. as the measure is semi additive (byaccount) i was hoping that it would have returned just the most recent entry for the accounts but it has sum'd all entries...

Hi Riverguy, thanks for the response. sorry about the formating. didn't come out to clear. to explain... the DimAccount table has five columns: AccountKey AccountType AccountNumber Status StartDate The [Status] field holds either "Active" or "Inactive" [Startdate] holds the date the row...

Semi additive problem... I have an issue regarding semi additive behaviour which, as a relative newbie, has me stumped. Take this scenario... I have a very simple design which consists of a fact table with a single measure (balance), a time dimension and an account dimension. Defined as...

Hi, Can anyone point me towards reading material that detail specifics for developing a design, and subsequent warehouse cubes, for finacial data (bank accounts, securities etc)? A lot of information I can find work with pure sales related and do not cater or the semi additive challenges set...

Yup, you're right (Me being blinkered by my thoughts there). I can see that your query would return 1 row. Your query basically returns what was active on the 31st March. This is not the question I am posing though. I need "What statuses were active at any point between 1st March and 31st...

Accpeted, but just with the sample data you detailed. Add another inactive status for that period and then it would return two rows. As follows... Id Status StatusDate Active Flag End Date S0001 Submitted 20080301 I 20080312 S0001 Submitted 20080312...

I think the confusion lies with you slicing on a single date and myself wanting to use a date range. For example, you’re asking the question… What was the status on 10th March? SELECT * FROM StatusTable WHERE StatusStartDate <= ‘20080310’ AND StatusEndDate > ‘20080310’ Whereas I’m...

Thanks jtamma for the link. A very interesting article. If I have understood the design properly the fact table is populated at the end of each month with a single row for each existing employee. The row is keyed to the transaction dimension using the transaction id of the last transaction in...

Thanks for your posts, much appreciated. Hans, The if the fact is built using the status table it will hold approx 500,000 rows and will reside in SQL 2005 Analysis Services. If I understand you correctly you are suggesting a fact less table with a snowflake off to association SaleStatus...

Cor, that's bad formatting. Try this... Id Status StatusDate Active Flag End Date S0001 Submitted 20080301 I 20080312 S0001 Submitted 20080312 I 20080501 S0001 Submitted 20080501 A 20991231

Thanks for that jtamma. Doesn't really help as you can still incur double counts for date ranges. Take a report that wants all Submitted cases between 1st March and 31st March using the following data... Id Status StatusDate Active Flag End Date S0001 Submitted 20080301...

Thanks for your responses guys. Hans, For what ever time period is being sliced on I want to report 1 count per case. So if a user wanted "Application" figures for March & April it would bring back 1 count for S0001. I want the cube to be flexible and be able to perform both current view...

My example was your first dexcription - at some point in time in Q1, there were 20 sales in submitted status. And this included 2 counts for my example "S0001". Your last statement has hit the nail on the head and is what i'm struggling with - assign each sale to only one status for every...

The requirement is to build a cude for data mining. User will slice by Status ("Submitted", "Application" etc) and by date period (Year, quarter, month etc). So, example view would look like... Q1 Q2 Q3 Q4 Application 20 18 32 23

Thanks for your post Riverguy. A couple of interesting points there but could you expand on them for me. To help with clarity let me put this scenario to you (it's a bit convoluted but real)... A sale comes in (Id=S0001) to the system on 1st February, moves through the decision engine which...

Thanks for your response John. I have considered this option but... Although, from a high level, each sale does progress through a preset pipeline, certain statuses are split to a finer granularity. To explain, a sale enters the system at "Submitted" status. It then moves through a rules...