| T O P I C R E V I E W |
| Pedrix |
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 |
| 5 L A T E S T R E P L I E S (Newest First) |
| admin |
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]? |
| Pedrix |
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.
|
| admin |
Posted - 10/27/2004 : 19:01:45
Thanks. We will investigate.
Igor. |
| Pedrix |
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]) |
| admin |
Posted - 10/20/2004 : 18:44:56
Can you please show me the MDX you get from the MDX panel? |
|
|
Report Portal
