-
MQL over Metadata in CDE (syntax of the query)
Hi guys,
it's almost 6 month I'm using Pentaho and a little less CDE/CDA.
Now my problem is to write the query for the "MQL over Matadata" datasource in CDE...
I've done all about Metadata Editor (domain, model, connections and so on...) and it works perfectly.
Then I've made a CDE file with layout, component and datasource I desire (from a SQL db without a problem...good job guy with CDE!!!) but at least I wish to insert a chart with data from a domain created with ME.
And now come the problems, I suppose that I'm stupid but how to compile the configurator (I've coping with other examples and I have a hell in my head):
XMI file = have to insert only the name of the file?with extenction? the full path?
Domain ID = I suppose only the exactly name (it's true?)
Query = AAArrrghhhh!!! what have I to insert? A SQL query (no, I suppose)? A MQL query (yes....), but which syntax? it's necessary other elements?
An example that I use but doesn't work:
<mql>
<domain_type>relational</domain_type>
<domain_id>Report_Domain_2</domain_id>
<model_id>BV_MODEL_1</model_id>
<model_name>report_model_2</model_name>
<options>
<disable_distinct>false</disable_distinct>
<limit>-1</limit>
</options>
<selections>
<selection>
<view>CT_CATEGORY1</view>
<column>BC_T_STORE_ID_STORE_MATCH</column>
<aggregation>none</aggregation>
</selection>
</selections>
<constraints/>
<orders/>
</mql>
I've typed this words exactly in the popup of the query, which are my errors?
Thanx to all that will help me or even with a single idea or experience...
And excuse me for my english.
Davide
Tags for this Thread
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules