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 .
1 Comment: