Recent content by scottcabral1979

thanks Borislav , that worked!

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