cancel
Showing results for 
Search instead for 
Did you mean: 

Unable to see the variable in Query Designer

Former Member
0 Kudos
52

Hello Experts,

I am running one report and it is showing me 0calday variable selection screen at run time. I am unable to see this Variable on my Query designer but when I am opening query properties its showing me in this.

Kindly let me know where is this Variable using in my query designer ?

Thanks,

Anoop

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hi Anoop,

Right click and display each and evey Keyfigure.

You will be able to find the variable. Your key figure will be restrcited by some date field using 0calday variable

Also in global filters (Filters tab ) check if there is any date field restrcicted by 0Calday.

Thanks,

Vinod

Answers (2)

Answers (2)

former_member202684
Contributor
0 Kudos

Hi Anoop,

The variable is probably being used to restrict a key figure.

Go to the key figures,

Display the technical names

Check the key figures for which the technical name is not appearing even though the key figure is not a formula.

Here you will see one of the key figure being restricted by a variable for 0calday

Hope this helps.

Regards,

Joe

Didnt notice the question is answered 😛

Edited by: lazarus_joey on Feb 17, 2012 6:48 PM

sven_mader2
Active Contributor
0 Kudos

Hi,

see there

- query filter

- query key date

- selection key figure

- selection key figure in the cell definition

- exception

- condition

=> everywhere can be a variable

Sven

Former Member
0 Kudos

Hello,

What do you mean by Key date and where should I see this?

Thanks ,

Anoop

sven_mader2
Active Contributor
0 Kudos

Hi,

in the properties of the query. Normally the field is empty.

Sven