How do i create dimension based on this query

I have cube called client distinct cube.. that cube is been driven by table A and has the following columns

Client-id, Active ,mcd Elibigle and time_Id

and there another table called Eligibles which has the following columns

Client_id, Time_Id, Plan_Id, plan_Id can be 1 -5

I have a created a dimension called client insurance with table eligbles as the base table and i have added 2 more tables called ben-plans and insurance to get the names for it...

SO when i build this dimension i get the STate, and medicaid and its subsidiarys

the dimension and fact tables for this cube is matched by Client ID and when i process this cube and i get 260 distinct clients for med C but if i query those two table for the same time frame i should 620 distinct instead of 260.. I am not sure what i am
doing wrong...

More Related Resource Links

Hello
I have a table as follow:
No Placestart Placeend
1 DK USA
2 UK USA
3 USA DK
Now, I want a dimension called Country, which selects either of the rows where a value exist
In SQL it would be ex (SELECT * FROM table WHERE placestart = 'USA' OR placeend = 'USA)
So, when I select USA in the dimension all 3 rows are listed, as USA is included either in placestart or placeend.
If I select DK row 1 and 3 is selected etc...
Is this somehow possible?

Hi,
I'm using SSRS 2005 to report on an SSAS cube that contains a Procedure dimension. I don't need to use members of this dimension in my report, but rather need to select records (patients) where their chart has one or more of the codes.
I've researched this today and cannot locate the best approach. Thus far, I've attempted to create an MDX query parameter as part of my dataset. However, I don't know whether this is the correct approach, and how to structure the syntax so that
only records with one or more procedures are included in the report? If so, what is the proper MDX syntax for setting my Procedure code equal to the query parameter?
Thanks,
Sid

I posted this on Experts Exchange awhile back with no answer, so here's hoping someone here has an idea :)

So I've mostly figured this problem out, but I need some help in getting over the hump... note that I'm using JavaScript to do this (SPServices) on SharePoint 07'.

I'm on the New Items page of a list. Based on a user's selection in a "Teacher" dropdown, I'm doing the following:

1.) Get the value of the Teacher field and several other fields (School and Visit Date)
2.) Run a CAML query based on those fields to find the last list item entered for that Teacher

So here's where I'm stuck...

I have 10 choice fields, all with choices 0, 4, 7, and 10. Depending on what they were set to in the last entered item (which I queried), I want to set the selected item on each of those dropdowns to equal that. So "Score 1" was set to "4" on the la

Hi,
I want to migrate wss3.0 site into sharepoint foundation 2010 site .
earlier we were creating site based on .stp file in WSS 4.0 . but now we have to build same site in sharepoint foundation 2010. I followed the old way intall the .stp file and based on that trying to create
new site but getting some error old version template is not supporetd my this version.
how could l able to create site in sharepoint foundation 2010 based on wss 3.0 template .
Please help
Thanks in advance
Jandel Singh

Hi,
I want to migrate wss3.0 site into sharepoint foundation 2010 site .
earlier we were creating site based on .stp file in WSS 4.0 . but now we have to build same site in sharepoint foundation 2010. I followed the old way intall the .stp file and based on that trying to create
new site but getting some error old version template is not supporetd my this version.
how could l able to create site in sharepoint foundation 2010 based on wss 3.0 template .
Please help
Thanks in advance
Jandel Singh

I've got a plain C# web page that uses jQuery to call a handler page using AJAX. While the handler content is loading, a message "Please Wait, loading..." is displayed. Once I've got the content back from the handler I hide the loading message and display the content.What I'd like to do is after the loading message, display a percentage of how far through the handler page is. All the handler page does is loop through a list of members, powered by a web service, and adds them to the database so I know exactly how many members are being added to the database so I can tell how far I am through.The problem I'm having is because all of this goes on in a handler, how can I send the progress percentage back to the main web page while the handler was still loading.Any ideas? If I could do the exact same task but differently which would allow me to create the progress bar, I'd be happy to hear any suggestions.

Hi,
I am clueless as to how the following would be done. Would appreciate imputs:
i would be passed in a StartDate and EndDate along with a Period(Week,Month,Quarter,Year). this would be an INT which is calculated in the following way -- Suppose he selects StartDate = 2010-01-01, EndDate = 2010-02-28, and Period = Weeks --->
Which would mean my resultset would have a additional 9 columns (9 weeks using DateDiff(Week,@startdate,@enddate)
The number of fixed columns always will be 4 Total # of records that would always come back is > 10
something like this
CategoryTypeId(int),ParentCategory(uniqueidentifier),Id(uniqueidentifier),Name nvarchar(50),Wk1,Wk2.....Wk9
1,xxxx,xxxx,'Shopping',650,300,1275....1000
(i dont't need to total the wk,month,qurter or yearly.This would be taken care on the front end)
Thanks!

Ok, trying to figure out how to filter on specific dimension attributes.
Are there any suggestions?
I have a measure that needs to be filtered by a dimension that has numerous attributes (20 attributes in total) but I only want to show that measure against 10 of the attributes and once I get that result I need filter that result set against my time dimension
(which this part I have figure out)
This is what I have so far:
With member [calculated_measure_name] as
( [measures].[count_of_people],
{
[dimelgiblestatus].[elgible].[elgible1],
[dimelgiblestatus].[elgible].[elgible2],
[dimelgiblestatus].[elgible].[elgible3],
[dimelgiblestatus].[elgible].[elgible4],
[dimelgiblestatus].[elgible].[elgible5],
[dimelgiblestatus].[elgible].[elgible6],
}
)
Select [calculated_measure_name] on columns,
[date].[fsicalyear].&[2008],
[date].[fsicalyear].&[2009],
[date].[fsicalyear].&[2010],
[date].[fsicalyear].&[2011] on rows
from mycube
When I run it, it gets no errors but in the result set for the numbers I get "#error"; do I need to basically create a subcube in order to get the result like I would like?
If so how would I start doing that?
ThanksNetwork Analyst

Hi
What is the best way to calculate (without actual access to a SQL Server) the processing speed of a query (self-inner-join) based upon table schema, table size, and hardware (CPU, RAM, Drives)?
ThanksThanks
Jeff in Seattle

Is there any non-code way to create a SharePoint Security Group that is populated by an AD query?
The "standard" way of getting the same "effect" is to create a group that contains an AD group but that does not allow members of a particular site to see who else is also a member of the site
Any thoughts?

Hi
I am creating a shell dimension to create a hierarchy. The idea is we want to know how much revenue we make from new accounts. So I have created an account dimension and linked that to the Revenue fact. I also created a Fact linked to the
Date and User dims that will show the date the user was created. By doing this, I was able to create a calculated measure that will show me total revenue, plus the revenue that is only for new players for a specific month:
with
member NewRev as
aggregate(
exists(DESCENDANTS([User Account].[User Account].[All], [User Account].[User Account].[User Account Key])
, [Date].[Date - Calendar Month].currentmember
, "User Registration")
, [Measures].[Revenue])
select
{[Measures].[Revenue]
, NewRev}
on columns
, [Date].[Date - Calendar Month].[Calendar Month].&[201008] on rows
from
[Revenue]
Sorry it is a bit messy, testing at the moment.
What I would like to do is create a shell dimensions so I can create a hierarchy that will show new and returning players as members. It would have an all level, or the user could split the revenue by this dim. I set things up like the Time calculations
shell dim, but am a bit stuck with how to create the mdx so that it will work with any measure.
What would I change to do this?
Regards
Michael