Hi,
I use Metacube 4.0 and have a problem with getting user-defined
parameters value.
In Agent, I created a parameter DayZero defined as :
select p.day_ofmth from date_dim p where p.date_key=1this should return a number (only one row).Also, using dbaccess, I ran
DayZero query, it works fine and returns the right value.
In explorer, I use it in a filter:
DateKey = <<DayZero>>
(this filter should be more complex, but since it doesn't even work
with this definition...)
When running the query, the following error messsage pops up:
MCExplorerBookCTRL:
There was an error (-2147417848);MetabaseCode - GetQueryParameters:
Automation Error
I checked on the server side: the DayZero executes and ends, but
nothing else.
Metacube is new for me so I guess I am doing something wrong. Any idea??
Thanks,
Sebastien
Sent via Deja.com http://www.deja.com/
Before you buy.