cancel
Showing results for 
Search instead for 
Did you mean: 

Create a variable to retrieve the data of an prompt

ju_mia
Explorer
0 Kudos

Hi,

I have a query in which I have an indicator which is the number of buildings.

In this query I have two filters: MONTH OF ANALYSIS 1 and MONTH OF ANALYSIS 2

I want to calculate the variation in the number of buildings between MONTH OF ANALYSIS 1 and MONTH OF ANALYSIS 2.

I tried to perform this formula in a variable: = [bat. Number of occupants] Where [Cal. Previous month YYYY.MM] = "psCal. Analysis month 1" But it does not work.

Thank you in advance for your help

Accepted Solutions (0)

Answers (2)

Answers (2)

ju_mia
Explorer
0 Kudos

Hi ayman.salem

I have this BO request

I have the indicator "Bat. Nombre d'occupants"

I launch my request and it's ok.

I want to create a variable that retrieves the number of Bat. Number of occupants in the month of analysis 1

Another variable that gets the Bat. Number of occupants in analysis month 2

I can observe these months of analysis in the dimension in the Cal dimension. Previous month YYYYMM.

Example: Here the user has input 2020.09 for analysis month 1 and 2020.10 for analysis month 2 Now I would like to calculate the evolution of the Bat. Number of occupants between the two dates entered by the user

ayman_salem
Active Contributor
0 Kudos

As mentioned earlier, use UserResponse (<prompt string>)

For example, your first prompt for analysis 1 "MONTH OF ANALYSIS 1", is your variable UserResponse("MONTH OF ANALYSIS 1").

ayman_salem
Active Contributor
0 Kudos

if I understand your question correctly, use UserResponse (<prompt string>) to get the prompt value.