Showing Dimension Members with no data in fact table

[Sven Grundmann]

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]

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.