Current date in BO queries with Universe built on Infocube

[Former Member]

Hi dear experts,

We are facing the following issue :

- we built a universe on top of a multiprovider (with 2 infocubes) since we don't want to manage BW Queries.

- we need to restrict data on WebI queries using current date or system date (to compare with a date from the universe)

No options to do that seem to be available through MDX in the universe.

Has anyone already solved such an issue and how do you proceed?

Thanks for your help.

André

[IngoH · Accepted solution]

Hi Andre,

I assume you are aware that you are losing items when connecting to the cubes directly, such as restricted keyfigures, calculated keyfigures, variables, structures, navigational attributes, and the option to use authorization variables.

In the universe right now you don't have an option to reference something like a system data - that is done with an EXIT variable in the query.

Ingo