Prompt on Quarter

[Former Member]

Hi

I have an object in universe like "Fiscal Quarter". The values of this object are like Q1 FY08,Q2 FY08,Q3 FY08.....I want to create prompt on this object in webi like "Fiscal Quarter between.....and......". As this is character data how will the BO recognize the order?As the data is in alpha numerics, it is taking in alphabetic order like Q1 FY08,Q1 FY09,Q1 FY10 etc.

For example if i have selected like "Quarter between Q1 FY08 and Q3 FY08", Actully it should display the data of Q1 FY08,Q2 FY08 and Q3 FY08. But it is taking the quarter like Q1 FY08,Q1 FY09,Q1 FY10 etc.

Please advise.

Thanks

[Former Member · Accepted solution]

Hi Raveendra,

I Hope you are getting the correct data , But not in the order you want like Q1 FY08,Q2 FY08 and Q3 FY08.

*The Datatype of the Quarter doesnu2019t matter.

Please, see the other dimension objects you have in your report , WEBI groups the quarter data according to the dimension values in the report. You can see all dimension values together like in below Ex. All US values, and France values together and distributes quarter values accoding to dimension.

Ex:

Country Quarter Sales Revenue

US Q1 FY08 $456,789

US Q1 FY09 $859,259

US Q1 FY10 $159,357

France Q1 FY08 $987,157

France Q1 FY09 $267,817

France Q1 FY10 $628,976

To See the Quarter values in the order you want, you can sort quarter in Ascending order that will change the order of the dimension i.e. US, France.

I hope this is Clear...

Thanksu2026

Pratik

[Former Member · Accepted solution]

Hi Raveendra,

I think you will have to convert the string so that it is order in the manner your want.

You could try created a order_quarter object in the universe. This would be done with a formula like

=substr(@select('My Class\Fiscal Period'), 6, 2)||substr(@select('My Class\Fiscal Period'),2,1)

which should return 081 for Q1 FY08 (note the concatenation is || which is oracle, for other dbs you will have to change this.

You can them prompt based on that.

Regards

Alan

[Former Member · Accepted solution]

Thanks Prathik & Alen....Issue resolved.

[Former Member · Accepted solution]

Thats great - did you use the code or did you come up with another soluution.

Regards

Alan

[Former Member · Accepted solution]

I have asked my database team to use your code while loading the data.

Thanks a lot..Alen