Hi all,
I have a basic question about the functionality of the Framework manager. Is it possible to model aggregations in framework manager? My problem is to aggregate several days of a month (for example despatch date) in framework manager so that I can choose several aggregated months in a prompt. Till now I have tried to extract the month out of the Date and time string. This works, but it isnÃ,´t aggregated yet. My target is to get a hierarchy where I can choose for example one day, a month, a quarter or a half-year? Is that possible to do this in the modelling?
bye
moonraker
Yes it is possible,
but u have to place calculated columns or stored procedures in ur datamodel and by publishing the package u can use aggregates of the dates (but in no.s not in date format,i.e., like 10(months) or 2 years 10 months like that).
but as it is of date aggregation, be careful when u write the procedure.
regards.
quote author=moonraker link=topic=213.msg805#msg805 date=1126077481]
Hi all,
I have a basic question about the functionality of the Framework manager. Is it possible to model aggregations in framework manager? My problem is to aggregate several days of a month (for example despatch date) in framework manager so that I can choose several aggregated months in a prompt. Till now I have tried to extract the month out of the Date and time string. This works, but it isnÃ,´t aggregated yet. My target is to get a hierarchy where I can choose for example one day, a month, a quarter or a half-year? Is that possible to do this in the modelling?
bye
moonraker
Quote
till now i have used an expression like
decode ( substring(to_char ( [Datasource].[XXXVIEW].[DateColumn]),4,2) , '01', 'Januar', '02', 'Februar', '03', 'März', Ã,´04Ã,´,Ã,´AprilÃ,´, Ã,´05'.Ã,´MaiÃ,´,Ã,´06Ã,´,Ã,´JuniÃ,´,Ã,´07Ã,´,Ã,´JuliÃ,´,Ã,´08Ã,´,Ã,´AugustÃ,´,Ã,´09Ã,´,Ã,´SeptemberÃ,´,Ã,´10Ã,´,Ã,´OktoberÃ,´,Ã,´11Ã,´,Ã,´NovemberÃ,´,Ã,´12Ã,´,Ã,´DezemberÃ,´)
the Problem: I have to do this for all months of the several years, to have a separation of the several months of the years.
Has anyone a better solution, especially when you only have the option to calculate a new Query item and not to import Months, Years etc.
bye
moonraker
Nobody?
I have this problem especially with oracle database, is there any better solution?
Greets
moonraker