Hi,
I have the following data:
POL# POL_EFF_DATE
123 1-1-2012
123 1-1-2012
123 1-1-2012
123 1-1-2013
123 1-1-2013
456 1-1-2012
456 1-1-2012
456 1-1-2013
456 1-1-2013
I want to add sequence number to each group with same Pol# and Effective Date like this:
POL# POL_EFF_DATE Seq
123 1-1-2012 1...
Hi,
I would like to build a fact table that tracks homeowner's insurance policy submissions. This table would measure policies that were quoted and/or issued.
The source data is stored by policy with a Quote Date and an Issue Date and a policy_status field. Every policy would have a quote date...
I have a Windows 7 64 bit machine running SQL Server 2008 Enterprise.
I would like to upgrade it to SQL Server 2008 R2 Enterprise. I loaded the media on the machine, but when i double click on the setup.exe, it displays a command box for a split second, goes away, and then nothing happens.
I...
Hi,
I have the following xml file:
<Root>
<Policy>
<PolicyNumber>123456</PolicyNumber>
</Policy>
<Limits>
<LimitType>LOB</LimitType>
<LimitAmt>1000</LimitAmt>
<LimitType>PP</LimitType>
<LimitAmt>5000</LimitAmt>
<LimitType>LOU</LimitType>...
I have an SSIS package that has a variable called @RUN_DATE.
I would like to create a sql agent job and uses the set values tab to pass a dynamic parameter to the ssis package.
for example, i would like to always set the variable to the last day of the previous month. I know that If i hardcode...
Hi Johnherman,
thanks for your input.
1. We do have a Customer Number for each policy and yes, a customer could have multiple policies with our company. I was thinking of building a Customer dimension to hold each customer number, address, and name information. This could be an SCD type 2...
Hi,
I'm designing a monthly periodic snapshot fact table that will have every homeowner's insurance policy that is active at the end of each month.
Each policy has many attributes including policy number, effective date, expiration date, agent, territory, distance from coast, number of family...
Hi,
looking to Upgrade from SQL 2008 Enterprise to 2008 R2 Enterprise on Windows 2008 R2 Server (64 bit).
Any known issues, gotchas, white papers, etc... that I should be looking for or prepare for?
My guess is that an in-place upgrade should be quite easy as there should not be many changes...
Hi,
I have a question about modeling a fact table representing Insurance policies.
We get a lot of requests for "How many policies were effective in 2011?" or "How Many Policies were Cancelled in 2012?".
My guess would be an accumulating snapshot, but how do I model policies that have had 4...
thanks Geoff,
This sounds logical to me. The trickiest part will be to dynamically have the excel file name change, but I should be able to find some examples of that online.
thanks
Scott
Hi,
I have an excel file with following data:
Agent State Exposure Insured Name
Rogers Inc MA 100,000 John Smith
SAN Group RI 200,000 Jim Morrison
SAN Group RI 100,000 Jimi Hendrix
123 Agency MA 300,000 Mickey...
I recently setup PowerPivot for Sharepoint 2010, installed all necessary products and setup all services and permissions on the server, including the PowerPivot Unattended refresh account.
I created a PowerPivot workbook which connects to our SQL Server data warehouse. I was able to save to...
Hi,
I built a dimensional model with the fact and dim tables populated and created a cube using SSAS 2008.
Now I would like to give the end user's the ability to drag and drop and slice and dice the data like you can using SSAS, however I'm not sure what tools are best for this.
I know Excel...
Hi,
I am trying to model an insurance claims process that contains 2 levels.
Each claim has a main occurrence number. This is the main ID for a claim.
Each occurrence number has 1 or many features. Features are what hold the measures or amounts for each claim transaction.
Occurrences have...
Thanks Simi,
This code is exactly what I was looking for to build the table dynamically based on the max number of sequence numbers.
I had to update the column names to use the @cnt variable instead of hardcoding the '1'. There was also an extra column at the end before the from statement, so...
Hi,
I am trying to build a Claims Transaction Fact table for a homeowner's insurance company.
My claims transactions source table is setup like this:
Each Claim entered has an Occurrence.
Each Occurrence can have 1 or many Features.
Each Feature has 1 or more transactions.
So for example...
Hi,
I currently work for a property and casualty insurance company where we only deal with homeowner's insurance.
I would like to build a claims transaction fact table along with all the dimensions used to describe the transactions.
Being fairly new to Dimensional modeling, i have a few...
Hi,
I'm trying to write some code that will get me the last day of each month for the months that fall between 2 dates.
So if i have a table with a record with a begin date of 01-01-2012 and an end date of 09-14-2012, i would want a result set of the following 9 records:
01-31-2012
02-29-2012...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.