March 29, 2010 at 6:49 am
Hi,
I have to create 3 measure to my existing cube and I was wondering if it is a good idea to use Named query to get part of the results...
The Fact table of the cube has the following columns
client_Id,
Paid_amt,
Paid_flag,
capitated_amt,
Adj_units
this cube has measure as the distinctcount of clients, sum(paid_amt), sum(capitated_amt), sum(adj_units)..
Now they want me to more measures what would give the count of clients who had a paid_amt and their adj_units and also count of clients who have a capitated_amt and their adj_units...
I can get depending on the Paid.. so if the paid flag is set to true means it is a paid claim else a capitated claim...
So i was thinking of creating 2 named queries based on the Paid Flag...
Since i am new to SSAS i was wondering if this the right way to do it... Or is there away i can get the data off the main table? I tried doing it off the existing table and it works fine based for the paid and capitated but the units and the client count is not correct..
Any help will be appreciated..
Thanks
KAren
March 30, 2010 at 8:30 pm
You could probably easily achieve this using calculated members
April 5, 2010 at 6:31 am
Daniel.
Thanks for the answer.. I have tried using Calculated members but I am not getting the corrrect data returned..
Can you please help me in figuring this thing out..
[Code]
create member [service data cube].[Measures].[Dist Count Capitated] as
([measures].[Client ID],[Paid Flag].&[false])
[/Code]
When I process my cube and then browse I get a distinct count of 709
but if I run my query its gives me around 45..
My table structure is as follows
My table structure is as follows
Claim adj int,
Client_Id int,
srvc_Id int,
provider int,
time_ID int,
Adjudicated units int,
paid_flag bit,
Paid amt money,
Capitated Amt money
Any help will be appreciated.
Thanks
Karen
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply