What a brilliant post I have come across and believe me I have been searching out for this similar kind of post for past a week and hardly came across this.
I am using SQL server 2014 standard edition. I am using Drill Through action to display a detail report for my cube data, which is working fine. Only issue I see is when I drill through year and quarter it displays data for months in a haphazard manner instead of sorted by month. How do I set it to sort by month, and Item Number (which is a fact dimension for this measure) within month? The System Global Area in an Oracle database is the area in memory to facilitate the transfer of information between users. It holds the most recently requested structural information between users. It holds the most recently requested structural information about the database. The structure is database buffers, dictionary cache, redo log buffer and shared pool area. Once again thanks for your tutorial.
Hi Dayakar,
ReplyDeleteWhat a brilliant post I have come across and believe me I have been searching out for this similar kind of post for past a week and hardly came across this.
I am using SQL server 2014 standard edition.
I am using Drill Through action to display a detail report for my cube data, which is working fine. Only issue I see is when I drill through year and quarter it displays data for months in a haphazard manner instead of sorted by month.
How do I set it to sort by month, and Item Number (which is a fact dimension for this measure) within month?
The System Global Area in an Oracle database is the area in memory to facilitate the transfer of information between users. It holds the most recently requested structural information between users. It holds the most recently requested structural information about the database. The structure is database buffers, dictionary cache, redo log buffer and shared pool area.
Once again thanks for your tutorial.
Cheers,
Kevin