Using Multi mesures and filteres

[Jorge Arada]

Hi ... thanks for that excelent job you have done ...

In excel when i use more than 1 dimenson and try to filter some members the next dimenson keep all the memembers ... I think it's missing crossjoin function on the query MDX ... or maby i m not doing it well ... Can you help me with that?

Thanks in advance

[Alexandra Davidoiu (Iancu)]

Can you give steps to reproduce please?

[Jorge Arada]

As you can see in that image http://s27.postimg.org/tv5psoooz/img.jpg
I used two dimensons filtred with 2 levls each ...
on 1st (Categoria Profissional) i filtred value RADIOLOGISTA and on second (Grupo de acto) Filtred value TAC

i got all Nome even if those dont have Grupo de acto corresponding (cell's with no data)

[Alexandra Davidoiu (Iancu)]

You get this kind of response because of the tabular result (you use the layout “”tabular Form”). If you use “compact form” for your layout you will get a more readable response. The empty spaces that you get there are side effects from crossjoin in tabular format.

I tried to reproduce your example with my data. Figure 1 is in “tabular layout”. As you can see I also have empty spaces, and they are from flattening the response from the crossjoin. You can see the same operation in “Compact” layout in the second fig. I think the data there is more easy to read.

Hope it helps

[Jorge Arada]

Thanks for your's fast replay...
When i change the view i still have same problem its not crossjoining ...
i just wana see the results of 1st dimenson if there is a result for a filtred members in 2nd dimenson ... something like in 1st img

And i still having all from 1st even if not matching in 2nd

[Alexandra Davidoiu (Iancu)]

Any chance we get your database/schema? You can reach us via the support of arquery. Check here http://www.arquery.com/Contact

[Jorge Arada]

Sorry it's a client database ... can't give you that ...

i can give you the xml mondrian schema if it helps ...

[Alexandra Davidoiu (Iancu)]

send it to support. let's see how it goes from there.

[shreeux2]

Using multiple measures and filters in data analysis or reporting allows for a more detailed and tailored view of the data. Measures refer to quantitative data points, such as sales figures, revenue, or customer satisfaction scores, which can be aggregated or analyzed across different dimensions like time, geography, or product categories. Filters, on the other hand, allow users to narrow down data by applying specific criteria for couple name combiner, such as focusing on a particular time period, region, or product type.

[Kevin6546]

Using multiple measures and filters in data analysis allows for a deeper and more precise understanding of trends and performance indicators. By applying various measures—such as total sales, profit margins, or customer counts—alongside filters like time periods, regions, or product categories, analysts of order softcover albums can isolate specific patterns and insights that would otherwise remain hidden in aggregate data.