getting measure into cube.

[shayne]

Hello all.
I am learning to use transfromer.
I am having one pproblem, I have a data set with three lines of buisness. I need to be able to add the number of members per month per line of buisness.
When I try to pull the data over I gut a total lfor each line of buisness. Since I am new to this product I am not even sure how to ask the question. I am pulling from an access query.
Thanks for any help

Shayne

[cognostechie]

If you don't know how to describe the question, the best way would be to post what your data looks like (use examples, not real data) and how you want to see it in the cube.

[shayne]

I ahve a cube that I h ave built with medical claims in it.
I have a line of buisness that is Goverment and commercial
goverment contains a leaf level of medicare and medicaid. Commercial has a leaf level of pos, self insured.
I have a data set that is member months. for each line of business. so it has goverment-medicade then the amount of members for each month of the two year data set.
When I build a cube using just the member months it comes out corrdct. When I add the member months to the medical cube then I get a measure that is incorrect. It seems to just add all of the months together and give me a total

i hope tha thelps
Shayne

[cognostechie]

Do you have a DATE in your data source which will show the months for those members?

or do you have a character column that shows 'JAN, FEB..."?

Line of Business (LOB) = Govt, Commercial
Type of Business (TOB) = Medicare, Medicaid, POS, Self Insured
Members - Individual's Name
Months - Date

If this is what you have, then you can make a model like this

Dimension1Ã,  Ã,  Dimension2
------------------------------------
All YearsÃ,  Ã,  Ã, Ã,  Ã,  Ã, BusinessÃ,  Ã,  Ã,  Ã,  Ã,  Ã,  Ã,  Ã, <- Dimension name (not the 1st level)
------------------------------------Ã, 
Ã,  Ã, YearÃ,  Ã,  Ã,  Ã,  Ã,  Ã,  Ã,  Ã,  LOBÃ, 
Ã,  Ã, Month Ã,  Ã,  Ã, Ã,  Ã,  Ã,  Ã, TOB
Ã,  Ã,  Ã,  Ã,  Ã,  Ã,  Ã,  Ã,  Ã, Ã,  Ã, Ã, 

Measure - Your no. of members (Qty)

You will have to create the All years dimension as the TIME dimension.

Ã,  Ã,  Ã,  Ã,  Ã,  Ã,  Ã,  Ã,  Ã,  Ã,  Ã,  Ã,  Ã,  Ã,  Ã,  Ã,  Ã, OR

DimensionÃ,  Ã,  DimensionÃ,  Dimension
--------------------------------------------
All YearsÃ,  Ã,  Ã,  Ã, BusinessÃ,  Ã,  Ã, Type
--------------------------------------------
YearÃ,  Ã,  Ã,  Ã,  Ã,  Ã,  Ã,  Ã, LOBÃ,  Ã,  Ã,  Ã,  Ã,  Ã,  TOB
Month

This way you can nest the TOB in LOB at the report level so you will have a more complete report where you can see all of it.

If your MONTHS are 'JAN, FEB etc' as a character field, then add that as a dimension and nest it in the report.

I could not understand how you are modelling it so this is the only thing I can suggest.   

[cognostechie]

..and by the way, your posts are difficult to read. Try using punctuations in the sentences and don't hesitate to start a new line if you have to.

The faster anybody can understand your question, the faster you will get the answers.