I have report requirement where I have to show measures for a particular geography for previous,
current and next quarters in a pivotal view.
--Previous Quarter| Current Quarter| Next Quarter
Geography ABC|xx|xx|xx
PQR|xx|xx|xx XYZ|xx|xx|xx
Next quarter values are displayed for other geography like ABC value is shown for XYZ and XYZ value is shown for PQR I have derived measure for pervious quarter using Time Series Function > Ago function, However the problem is with next quarter,how to find next QYR data and make it 'is prompted' ???
Thanks,
Manohar Paleti
- Manohar Paleti
- Hyderabad, AP, India
- Working as a BI Consultant, Served for various organizations as an OBIEE Developer by building the BI Solutions for Business Decision Making..
Subscribe to:
Post Comments (Atom)
are u asking for OLAP or OLTP database??? if it is OLAP, we cant find Next Quarter.because the future data will not be present in OLAP.
ReplyDeleteIf u know any more solutions try to keep on posting.
Thanks.
Thank you Chandana,
ReplyDeleteI'm not sure whether it is OLAP or OLTP.
even if it is OLTP, which is always contains current transactions(can we have next quarter data)?? am not aware of it, if you know pls have post the same.
assume that we are calculating Forecast and target values,which are predefined to future years and quarters..
after a scratching heads with sr guys,
yes,we can get next quarter/year data using OLAP functions like LAG and LEAD.
pls, try those two functions and we can get it done.
Thanks,