hierarchy calender

[Anonymous]

Hi Experts ,

I have the following data loaded in the Report :

LOAD RequestId ,

     DisplayId ,

     CreatedBy,

     Date,

     Year,

     MonthNumber,

     MonthName,

     Quarter,

     FinancialYear

From ViewName;

I want to display the Financial Year >> Year >> Quarter>> MonthName in the hierarchial manner in the Dashboard.

I tried using the Hierarchial load method.

But that doesnt seem to be working.

Kindly Suggest on how can this be acheived.

Thanks in advance

[YoussefBelloum]

Hi,

you can create a concatenated field (including all the calendar fields you want) and use the "show as treeview" option in a listbox

[Anonymous]

Hi Youssef ,

yes i have tried this , but this seems to show like below:

It only shows the months in white..

and i am not able to select the FY or Years also.. i have to drill down all the way to months and then select , tried changing the style of the component.

How can i acheive this,

any ideas please share.

Thanks

[YoussefBelloum]

I know, it is working like this. you can only select the most detailed level.. otherwise you should use again the Hierarchy method..

would you be able to share sample app to see what is going wrong with the hierarchy method ?

[Anonymous]

Hi ,

Attached is the QVW file with the sample data of the date.

Tried Hierarchy load.

Doesn't seem to work at all,

Kinldy help me out in this.

Thanks

[YoussefBelloum]

Can you please attach the source (sample 70 data) to be able reload or do yo want me to create for you another sample data ?

[Anonymous]

Hi ,

Here It is , Find the attached

Thanks

[YoussefBelloum]

first time I made a hierarchical calendar

it was a headache I swear, but at least it works

PS: you can't make it work with your excel (you have date format problem, I couldn't know what it is..)

I'll let you try to connect these two tables

PFA

[Anonymous]

Hi ,

Thanks a lot for the File , i am trying to implement it .

Also wanted to ask you , in your file , on selection of any entry in the h_Date list box , the data is not getting filtered.

Is that happening with u also ? Kinldy check and let me know.

Thanks

[YoussefBelloum]

no problem

actually I didn't finish it, the h_date is not yet connected to the data table..

if you can not find solutions to connect them, let me know