| Author |
 Topic  |
|
|
Pedrix
Spain
10 Posts |
 Posted - 10/20/2004 : 07:14:15
|
Hi!
I'am using evaluating Report Portal 1.5 and I have problems with multi Select filters (especially with date dimensions)
I usually, but not allways, get the following message:
(this is a translation of the msgbox, since my PC is set to Spanish language)
Error: Member's formula name [Fecha Pedido].[Multi] is not valid |
|
|
admin
1647 Posts |
Posted - 10/20/2004 : 18:44:56
|
| Can you please show me the MDX you get from the MDX panel? |
 |
|
|
Pedrix
Spain
10 Posts |
Posted - 10/22/2004 : 07:47:00
|
Yes, of course!
here it is (at bottom I've posted an MDX without multiselect that works OK.
Thanks!
with member [Fecha Pedido].[Multi] as 'Aggregate ({[Fecha Pedido].[ATMD].[Todas Fecha Pedido].[2003].[Trimestre 1],
[Fecha Pedido].[ATMD].[Todas Fecha Pedido].[2004].[Trimestre 1]})'
Select non empty TopCount(HIERARCHIZE(DISTINCT({
[Almacen].[(Todos)].Members,
[Almacen].[Todas Almacen].Children})),50,[Measures].[Importe Venta]) on rows,
non empty HIERARCHIZE(DISTINCT({
[Numero Albaranes].[(Todos)].Members,
[Numero Albaranes].[Todas Numero Albaranes].Children})) on columns
From [Pedidos]
Where ([Fecha Pedido].[Multi], [Measures].[Num Pedidos])
But when I do not use multi-select I get this MDX
Select non empty TopCount(HIERARCHIZE(DISTINCT({
[Almacen].[(Todos)].Members,
[Almacen].[Todas Almacen].Children})),50,[Measures].[Importe Venta]) on rows,
non empty HIERARCHIZE(DISTINCT({
[Numero Albaranes].[(Todos)].Members,
[Numero Albaranes].[Todas Numero Albaranes].Children})) on columns
From [Pedidos]
Where ([Fecha Pedido].[ATMD].[Todas Fecha Pedido].[2004], [Measures].[Num Pedidos]) |
Edited by - Pedrix on 10/22/2004 07:49:06 |
|
|
|
admin
1647 Posts |
Posted - 10/27/2004 : 19:01:45
|
Thanks. We will investigate.
Igor. |
|
|
|
Pedrix
Spain
10 Posts |
Posted - 10/28/2004 : 01:25:46
|
Thanks, Igor.
As soon as this is solved, we will purchase the product. It's great!
We've just found it!
If we put the multi-select filter on a row/column, it works OK.
|
Edited by - Pedrix on 10/29/2004 03:43:15 |
|
|
|
admin
1647 Posts |
Posted - 11/01/2004 : 09:09:05
|
| Unfortunately we can not reproduce the problem. Can you send us your AS database in CAB or CUB format? Can you please send it to [url]sales@reportportal.com[/url]? |
|
|
| |
Topic |
|
|
|
Report Portal
Multi-select filter
