<div>
<div class="content wysiwyg-content">
Hi I have created a OLAP Cube in which i have fact table <br />
1. Gross Profit <br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;EventID<br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;TypeID <br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;RevenueDate <br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;GrossProfit <br />
and a measure as count of User which comes from the Dimension UserInfo <br />
the UserInfo dimension has all the user info like userid,username,gender, address,postcode datecreated and deposit date <br />
and Dim Time is the time dimension with Datekey as primary key and <br />
RevenueDate ,datecreated and depositdate has a foriegn key referenced to the DimTime <br />
I want to create a churn report which should look like this <br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp; &nbsp;DepositDate &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<br />
RevenueDate &nbsp; Count Of User/GrosProfit<br />
<br />
My problem is since both revenue date and deposit date are related to tim dimension i cannot drag them on column field and row field both at same time do i need to create two seperate dimensions for deposit date and revenue date?<br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
</div>
</div>


Hi I have created a OLAP Cube in which i have fact table 
1. Gross Profit 
	EventID
	TypeID 
	RevenueDate 
	GrossProfit 
and a measure as count of User which comes from the Dimension UserInfo 
the UserInfo dimension has all the user info like userid,username,gender, address,postcode datecreated and deposit date 
and Dim Time is the time dimension with Datekey as primary key and 
RevenueDate ,datecreated and depositdate has a foriegn key referenced to the DimTime 
I want to create a churn report which should look like this 
	    DepositDate	
RevenueDate   Count Of User/GrosProfit

My problem is since both revenue date and deposit date are related to tim dimension i cannot drag them on column field and row field both at same time do i need to create two seperate dimensions for deposit date and revenue date?
		
	

olap cube query

Databases are organized collections of data, most commonly accessed through management systems including schemas, tables, queries and processes that allow users to enter and manipulate the information or utilize it in other fashions, such as with web applications or for reporting purposes.

Databases

A database report is the formatted result of database queries and contains useful data for decision-making and analysis. Most good business applications contain a built-in reporting tool; this is simply a front-end interface that calls or runs back-end database queries that are formatted for easy application usage.