XMLA Connections - Catalog?

40 views
Skip to first unread message

Cristian Veronesi

unread,
Jun 9, 2010, 6:01:20 AM6/9/10
to pentahoanalysistool-users
Hello, it's me again. I have a Mondrian server with two Datasources
definied, "FoodMart" and my own project, let's call it "MyProject".

When I create a new XMLA Connection the app ask me Name, XMLA Url,
Username, Password and Catalog. Whatever I type into Catalog, the
"Cubes" menu always shows me the FoodMart cubes. How can I tell PAT to
connect to "MyProject" datasource? Which string have I exactly to type
into the "Catalog" field?

Thank you.

Kind regards, Cristian

Paul Stöllberger

unread,
Jun 9, 2010, 6:55:43 AM6/9/10
to pentahoanaly...@googlegroups.com
Do you use mondrian server or pentaho biserver?

If its pentaho biserver there is a
pentaho-solutions/system/olap/datasources.xml config file which looks like:
....
<Catalogs>
<Catalog name="SteelWheels">

<DataSourceInfo>Provider=mondrian;DataSource=SampleData</DataSourceInfo>

<Definition>solution:steel-wheels/analysis/steelwheels.mondrian.xml</Definit
ion>
</Catalog>
<Catalog name="SampleData">

<DataSourceInfo>Provider=mondrian;DataSource=SampleData</DataSourceInfo>

<Definition>solution:steel-wheels/analysis/SampleData.mondrian.xml</Definiti
on>
</Catalog>
<Catalog name="New Schema1">
<DataSourceInfo>Provider=mondrian;DataSource=vc</DataSourceInfo>
<Definition>solution:/wrw/VC_Schema.xml</Definition>
</Catalog>
</Catalogs>


So in the catalog textbox you could enter SteelWheels / SampleData / New
Schema1 to connect to just that catalog

Which version of PAT are you using? I made some changes to the cube
discovery recently

If you are not seeing your datasource at all, and just FoodMart, then the
problem most probably lies in your server configuration, and not in PAT. Is
that the case?

-Paul


-----Ursprüngliche Nachricht-----
Von: pentahoanaly...@googlegroups.com
[mailto:pentahoanaly...@googlegroups.com] Im Auftrag von Cristian
Veronesi
Gesendet: Mittwoch, 09. Juni 2010 12:01
An: pentahoanalysistool-users
Betreff: XMLA Connections - Catalog?

Thank you.

Kind regards, Cristian

--
You received this message because you are subscribed to the Google Groups
"pentahoanalysistool-users" group.
To post to this group, send email to
pentahoanaly...@googlegroups.com.
To unsubscribe from this group, send email to
pentahoanalysistoo...@googlegroups.com.
For more options, visit this group at
http://groups.google.com/group/pentahoanalysistool-users?hl=en.


Cristian Veronesi

unread,
Jun 9, 2010, 7:48:25 AM6/9/10
to pentahoanalysistool-users
On Jun 9, 12:55 pm, Paul Stöllberger <paul.stoellber...@aschauer-
edv.at> wrote:

> Do you use mondrian server or pentaho biserver?

> Which version of PAT are you using? I made some changes to the cube
> discovery recently

> If you are not seeing your datasource at all, and just FoodMart, then the
> problem most probably lies in your server configuration, and not in PAT. Is
> that the case?

Hello Paul. I use Mondrian server and PAT 0.7.

The server seems to be properly configurated. The Mondrian XMLA test
page seems to give correct results.

For example, this XMLA request returns the cube list:

<Discover xmlns="urn:schemas-microsoft-com:xml-analysis">
<RequestType>MDSCHEMA_CUBES</RequestType>
<Restrictions>
<RestrictionList>
<CATALOG_NAME>MyCatalog</CATALOG_NAME>
</RestrictionList>
</Restrictions>
<Properties>
<PropertyList>
<DataSourceInfo>MyDataSource</DataSourceInfo>
<Catalog>MyCatalog</Catalog>
<Format>Tabular</Format>
</PropertyList>
</Properties>
</Discover>

With a different OLAP viewer (OpenI) I was able to connect to this
server with XMLA and interact with my cubes.

Thank you for your assistance.

Kind regards, Cristian

Paul Stöllberger

unread,
Jun 9, 2010, 9:31:53 AM6/9/10
to pentahoanaly...@googlegroups.com
So you don't see your cubes at all? Just the foodmart?
Well here is your answer: put MyCatalog into the catalog textbox

Can you please test this with the server from:
http://ci.analytical-labs.com/job/pat-standalone-server/150/
Thanks!

-Paul

-----Ursprüngliche Nachricht-----
Von: pentahoanaly...@googlegroups.com
[mailto:pentahoanaly...@googlegroups.com] Im Auftrag von Cristian
Veronesi

Gesendet: Mittwoch, 09. Juni 2010 13:48
An: pentahoanalysistool-users
Betreff: Re: XMLA Connections - Catalog?

Kind regards, Cristian

--

Cristian Veronesi

unread,
Jun 10, 2010, 6:31:20 AM6/10/10
to pentahoanalysistool-users
On Jun 9, 3:31 pm, Paul Stöllberger <paul.stoellber...@aschauer-
edv.at> wrote:

> Can you please test this with the server from:http://ci.analytical-labs.com/job/pat-standalone-server/150/

I'm using the pat-standalone-war, do you have a stable version to
test?

t...@wamonline.org.uk

unread,
Jun 10, 2010, 6:38:30 AM6/10/10
to pentahoanaly...@googlegroups.com
We don't really do 'stable' we just do milestones but they are just captured from http://ci.analytical-labs.com :)

Tom



On Thu 10/06/10 11:31 AM , Cristian Veronesi cri...@operamail.com sent:
--
You received this message because you are subscribed to the Google Groups "pentahoanalysistool-users" group.
To post to this group, send email to pentahoanaly...@googlegroups.com.
To unsubscribe from this group, send email to pentahoanalysistool-users+unsub...@googlegroups.com.
Reply all
Reply to author
Forward
0 new messages