Need MDX help for attrition and churn???

MS SQL SERVER

    Sponsored Links

    Next

  • 1. create installation files
    After development, what's the best way to deliver the OLAP to client? is it possible to create something like setup.exe for them to double click and follow the wizard to install OLAP and report services projects? (The server name is different from my testing server and real server) thank you!!
  • 2. Cubes not available after processing
    The problem is that the cube is not available for queries. But process structure has been made, a full process of the dimensions and of the measure groups. This is what I did do: I did Import the SSAS Project from my live server to my local machine (laptop). I did some changings in the project in the dimensions and measure groups and deployed the solution to the server. After this I did a process structure. I logged into Analysis Server, opened a mdx script and the cube was available. Then I did a FULL Process of all the dimensions to be sure that everything is allright with them. Then I did reprocess all my Measure Groups. Now the cube is not available. This happend the second time now. I process the cube by using ascmd.exe executing xmla commands. After I do a process structure again it works. I can see the cube and the measure data is available after processing the measure groups. I cannot explain this behaviour. Can you? Best regards, Stefoon
  • 3. Interesting problem
    In SSAS I've made a dsv with a named query, which is my fact table. That is no problem but I then try to set my storage mode to ROLAP and now it gets interesting because I cannot process the cube. I get an error stating that there's some schemabinding problem and actually it's quite clear why the error appears. It's because SSAS tries to make a indexed view and this is based on the named query and it requires a 2-part name. No problem.. I change my named query and it still doesn't work because SSAS changes my query back so it doesn't use the 2-part name so my change from Orders to dbo.Orders is changed back! Is it because I'm using the dbo schema ? Or is this simply a bug ? In real life it really doesn't matter because I never use ROLAP anyway but while delivering a course it's quite interesting :) I'll try digging a little deeper but if anybody know anything it will be appreciated :) And enjoy the holidays :) Regards:) Bobby Henningsen
  • 4. Guidelines about using subselect vs Where
    I'm running a query against a specific week. I can put this WHERE [Date Dim].[Week End Date].&[2006-01-21T00:00:00] at the end, or I can do a subselect: ...from (select [Date Dim].[Week End Date].&[2006-01-21T00:00:00] on columns from [myCube] ) Right now the first example runs faster, but I don't know if that will typically be the case. Can anybody point me to an explanation about why one technique would be more efficient than the other?
  • 5. SSAS 2005: queries not optimized for the fact table...
    Hi, there is any option available to reduce the number of joins used by SSAS to read the data from the source DB? I have 3 dimensions (referenced dimension) connected to my fact table through 1 dimension. The "Materialize" option is checked for the 3 dimensions. So SSAS use 3 joins between the fact table and the intermediate dimension instead-of 1 join only. So this reduce the performance of the query. I know I can edit the query used by the partition or I can use a named query. But first I want to know if there is a simple option anywhere which optimize correctly the query. Thanks. Jerome.

Need MDX help for attrition and churn???

Postby Kevin Brooks » Thu, 08 Dec 2005 06:40:28 GMT

I have inherited a cube and star schema at my company and need some MDX help
for attrition and churn reporting.  The cube is a daily snapshot of a
production system as follows - it has a load date dimension with no <all>
level.  Each load date will give you current active customers and cumlative
disconnected customers.  So for a given date I can say we have this many
active customers and all total have lost this many.  The cube also has a
"end date" dimension that will tell you when a customer left.  So if they
are active it is blank and if they disconnected I can tell which day (ie -
Nov 2004 10,000 disconnected).  They want to start doing attrition and churn
reporting out of it.  I can do it writing SQL fairly easy, however it of
couse is not very dynamic.

For attrition or churn I can grab the number of actives 30 days ago, however
how can I get the number of disconnected since that day 30 days in past?  I
would need the 30 days of disconnected to change based on the load date.
Thanks.

Kevin Brooks



Similar Threads:

1.How do I calculate attrition and churn with MDX

I have inherited a cube and star schema at my company and need some MDX help
for attrition and churn reporting.  The cube is a daily snapshot of a
production system as follows - it has a load date dimension with no <all>
level.  Each load date will give you current active customers and cumlative
disconnected customers.  So for a given date I can say we have this many
active customers and all total have lost this many.  The cube also has a
"end date" dimension that will tell you when a customer left.  So if they
are active it is blank and if they disconnected I can tell which day (ie -
Nov 2004 10,000 disconnected).  They want to start doing attrition and churn
reporting out of it.  I can do it writing SQL fairly easy, however it of
couse is not very dynamic.

For attrition or churn I can grab the number of actives 30 days ago, however
how can I get the number of disconnected since that day 30 days in past?  I
would need the 30 days of disconnected to change based on the load date.
Thanks.

Kevin Brooks


2.Plzz help, need help on mdx topics

3.MDX DRILLTHROUGH IN AS2005 - NEED HELP , VERY VERY URGENT, Please Help

4.Need Help to form the MDX-Statement

Hello, I have following Situation:
I have a Dimension "SourceDirectory", whis has Elements
"SourceDirectory1", "SourceDirectory2", ... until "SourceDirectory10".

My Statement in MDX is whis:
SELECT {[Measures].AllMembers} ON columns,
{[SourceDirectory].Children} ON rows
FROM [CheckstyleError]
It works. Now, how can I select all SourceDirectories but not the
"SourceDirectory6", whis has only NULL-Values and I need't to see it in
my report. 
I would be glad to have an early reply! 
Thanks

5.MDX Query - Help needed from experienced

Ingen
=====
GA - Georgia
--County1
   --- SharedFlag
--County2
   --- SharedFlag
NC - North Carolina
--County1
  --- SharedFlag
--County2
  --- SharedFlag
MD - Maryland
--County1
  --- SharedFlag
--County2
  --- SharedFlag

Query 1:
Select Non Empty [InGen].[State Name].Members on Columns from [Firm 
Reporting]
...........................................
Could get all states as columns


Query 2:
with
set [SLA] as 'Filter( [InGen].[County Name].Members, 
[InGen].CurrentMember.Properties("SharedFlag") = "A" OR 
[InGen].CurrentMember.Properties("SharedFlag") = "Y" )'
Select Non Empty {SLA} On Columns From [Firm Reporting]
.....................
Could get all county names those are having SharedProperty of A or Y


Question: How can I get states on columns if any one of their counties has a 
Shared Property of A or Y ?

I do not have much experience but I tried hard to get this query 
(essentially it is a clubbing the above two queries) but with no luck. Can 
any body help me ? Thanks in advance.


6. Need Help to form the MDX-Statement

7. MDX for Reporting Services Help Needed

8. Need Help MDX



Return to MS SQL SERVER

 

Who is online

Users browsing this forum: No registered users and 73 guest