Generic date filter that affects different widjets with different dimension dates
Hi Evgency,
Effectively I have widjet with pivot which include dates in from different cubes/dimensions, but exists the relation between the two cubes.
I'm showing below the MDX query from one pivot that uses the date "Fecha Creacion" that comes from cube "EVENTOSPOLICIALES"
SELECT %LABEL([Measures].[%COUNT],"Cantidad de Encargos","") ON 0, NON EMPTY {[TipoEventoPolicialD].[H1].[TipoEventoPolicial].&[Encargo de Arma], [TipoEventoPolicialD].[H1].[TipoEventoPolicial].&[Encargo de Especies], [TipoEventoPolicialD].[H1].[TipoEventoPolicial].&[Encargo de Personas], [TipoEventoPolicialD].[H1].[TipoEventoPolicial].&[Encargo de Vehículos]} ON 1 FROM [EVENTOSPOLICIALES]
Here, I'm showing the other MDX query that uses the date "Fecha Parte" like a filter that comes from the Cube "PARTEPOLICIAL", bit the others fields come from "EVENTOSPOLICIALES"
SELECT NON EMPTY [Detenidos].[Edad].[H1].[RangoEdad].Members ON 0, NON EMPTY [Detenidos].[Sexo].[H1].[Descripcion].Members ON 1 FROM [EVENTOSPOLICIALES]
The idea is to have a generic date filter that when I choose a range of date affects both "Fecha Creacion" and "Fecha Parte".
The client wants this functionality, but if it's no possible, doesn´t matter, I can tell them that they have to choose two different dates.
Thanks for advance.