this is my query

[Code]

select distinct fr.client_ID

from dbo.tbl_fact_count_consumer_served f

left outer join tbl_report_fact_count_consumer_demog fr on f.client_Id = fr.client_Id

left outer join tbl_demension_time t on f.time_Id = t.time_Id

left outer join...

I did that and didnt find any blanks,,

and i tried querying the fact table and the dimensions but got around 3565 rows but the datacube give me around 3494 and...

Steve,

How do i do the second option...

can you please give me the steps... i am a newbie to SSAS

Sorry about now posting an update on this thread but i did solve the problem... it turned out to be a picture that i was referencing...I saved the link to...

yeah... your correct... but i havent tried for around 800 rows... the max i have tried is 294...but if i need to select all the 294 rows i click on...

instead of string use nvarchar(max)

yeah it is returning the data in two rows one row each for each item but i want them to be in row only...

Thanks for the answers and this is what i ended up doing

select client_Id from tbl where and eff_dt = @enddt) and datediff(mm, eff_dt, exp_dt)>=12

This is my actual requirement...

The previous 12 months should start counting on the end date of the date range entered (selected) and it is based on the enrolled status. ...

To be continuously enrolled, there should not be a gap in the dates of enrollment for the 12 month period.

My expected results should be clients that have been continously enrolled for the previous 12 months

thats the first two records.

Actually My table structure is at follows

Client_Id eff_dt exp_dt

1 ...

In the total column you can add them by doing the following

=ReportItems!textbox1.Value + ReportItems!textbox2.value

where textbox1 and textbox2 is Jan, feb etc..

Hope this helps

thanks,

Karen

yes that is correct....

Slange,

Thanks a lot for helping me out.

Regards,

Karen