Hi All,
We have an existing cube created using iqds developed from Impromptu. We are developing other cube similar to that, but with some changes and using iqds created in Framework Manager. For developing iqds in Framework Manager, we created Query subjects and then edit query subject and then when editing, we are just copying the sql code from the existing iqds. We are doing some changes to the SQL code in order to be validated in Framework Manager and then externalise those Query subjects to create the Iqds. We are able to create iqds like this. But one iqd which was created in Impromptu has a function called "od_year". But Framework Manager is not able to understand what that function is. I am not aware of Imptomptu. I appreciate if any of you could tell me about this function "od_year" and also if there is any function in Framework manager which can be used similar to 'od_year' in Impromptu.
Thanks,
Jaspire
That doesn't sound like an Impromptu function (I can't be positive, no Impromptu or docs here any more, but I'm pretty sure). Are you sure it's not a data item? If you still have Impromptu and the source report (.imr) open it up and poke around.
On a side note, FWIW, I'd convert the hand written SQL. Generally Transformer queries are pretty straightforward (or ought to be) so it shouldn't be a big effort and standard Query Subjects would be better for future maintenance.
I am giving here part of the query that includes the 'od_year' word which seems to be a function.
(CASE WHEN (((extract(YEAR FROM (cdate(T1."TIME_SID")))) = ((od_year((@CURRENT_DATE)))) - 0001) and ((extract(MONTH FROM (cdate(T1."TIME_SID")))) <= 01)) .
Also can you please explain me what you mean by hand written SQL? Actually I am just copying the queries I find from Datasource viewer of the datasources in the existing cube. When I get any doubt, I actually open the old iqds.
Also can you please tell me in what way the Standard Query subjects would be better for future maintenance?
Thanks
Regarding function appearance - I agree - see my reply to your post on Justcog.
OK, technically the SQL in the iqd isn't handwritten - but once you copy it and paste it into FM it is, or might as well be.
One example of easier maintenance, probably the classic one, is in renaming a table or column. Single point of maintenance with standard approach, potentially many if you have multiple uses of the object in your own SQL.
Of course your mileage may vary and it's a judgment call. We all take the expedient approach sometimes...and we all (unless very lucky) get bitten by it occasionally!
I knew that we don't need that proir year's details and so I just deleted all the expressions that used the function.
Well, that's one solution!
Hi,
The function does give by you does not belong to Impromptu,
Regards
Guruji