[#2930] - could not define groups on crosstab with mdx query with parent child hierarchy

Category:
Enhancement request
Priority:
Normal
Status:
New
Project: Severity:
Feature
Resolution:
Open
Component: Reproducibility:
N/A
Assigned to:

I'm trying to create a report with a crosstab on a mdx query .

the query is as follows

SELECT
{[Measures].[VALORE_COMMESSA]}
ON COLUMNS,
{{[VOCI_D.VOCI_H].[All Voci].[Redditivita].[Delta Contratto].[Delta Service Allestimento].[Delta Commerciale].[Ricavi Commerciali],
[VOCI_D.VOCI_H].[All Voci].[Redditivita].[Delta Contratto].[Delta Service Allestimento].[Delta Commerciale].[Costi Commerciali],
[VOCI_D.VOCI_H].[All Voci].[Redditivita].[Delta Contratto].[Delta Service Allestimento].[Delta Commerciale],
[VOCI_D.VOCI_H].[All Voci].[Redditivita].[Delta Contratto].[Delta Service Allestimento].[Costi di Allestimento],
[VOCI_D.VOCI_H].[All Voci].[Redditivita].[Delta Contratto].[Delta Service Allestimento],
[VOCI_D.VOCI_H].[All Voci].[Redditivita].[Delta Contratto].[Costi Intervento a Contratto],
[VOCI_D.VOCI_H].[All Voci].[Redditivita].[Delta Contratto],
[VOCI_D.VOCI_H].[All Voci].[Redditivita].[Costi di Intervento Fatturati],
[VOCI_D.VOCI_H].[All Voci].[Redditivita].[Ricavi da Interventi],
[VOCI_D.VOCI_H].[All Voci].[Redditivita]}}
ON ROWS,
{Descendants([MATRICOLE_D.MATRICOLE_H].[G1X336P01312])}ON PAGES
FROM [CDG_COMMESSE]

The dimension [VOCI_D.VOCI_H] is a parent-child hierarchy .
The MDX query designer does not show me the levels of the hierarchy that i need to define groups .
So i have tried to define it manually as follows :

Rows [VOCI_D.VOCI_H].[Redditivita]

When the report run i get the error "error filling print... Could not find level "Redditivita" on hierarchy #0 (dimension VOCI_D.VOCI_H) on axis #1"

the request is to support the ability to define groups on the levels of a parent child hierarchy .

ctamietto's picture
Joined: Sep 29 2010 - 7:47am
Last seen: 6 years 2 months ago

1 Comment:

#1
  • Assigned:nobody» lucianc
Feedback
randomness