We use cookies to give you the best experience on our website. If you continue to browse, then you agree to our privacy policy and cookie policy.
Unfortunately, activation email could not send to your email. Please try again.

Showing Dimension Members with no data in fact table

Thread ID:

Created:

Updated:

Platform:

Replies:

120843 Oct 21,2015 11:53 AM Oct 22,2015 04:55 AM ASP.NET Web Forms 1
loading
Tags: PivotClient
Sven Grundmann
Asked On October 21, 2015 11:53 AM

Dear Sir or Madam,

in an OlapClient we want to show hierachy members of specific levels, even if no data is ralated to this members. For example if we've got a time dimension with the following elements: 

Year -> Quartar -> Month,

we would like to define, that all months of a quartar are shown, no matter if data is present for these months. 

If I would write a client by myself I could perform this by using the NON EMPTY statement in an MDX query, for example:

SELECT [...] {(DESCENDANTS([TimeDimension].[All Time Levels].[Month].ALLMEMBERS))} [...] 

would result in showing all months within the quartar, even if no data is present. The same statement including the NON EMPTY statement 

SELECT [...] NON EMPTY {(DESCENDANTS([TimeDimension].[All Time Levels].[Month].ALLMEMBERS))} [...] 

would result in showing only those months, for those data is present (i assume, this is standard behaviour in olapclient). 

Can you provide an example in which all level members are shown in the client?

Best regards

Sven

Ramesh Govindaraj [Syncfusion]
Replied On October 22, 2015 04:55 AM

Hi Sven,

Thank you for using Syncfusion products.

We recommend you to modify the MDX query as per your requirement before its execution through code behind. Please find the below code example illustrating the same.


C# (Inside Service):

DataManager = new OlapDataManager(connectionString);
DataManager.BeforeMdxQueryExecute += DataManager_BeforeMdxQueryExecute;


void DataManager_BeforeMdxQueryExecute(object sender, QueryExecutingEventArgs e)

{

    e.MdxQuery = ""; //You can get, edit and pass the altered MDX query here.
}



Regards,
Ramesh G.

CONFIRMATION

This post will be permanently deleted. Are you sure you want to continue?

Sorry, An error occured while processing your request. Please try again later.

You are using an outdated version of Internet Explorer that may not display all features of this and other websites. Upgrade to Internet Explorer 8 or newer for a better experience.

;