Schema Workbench Publishing Mechanism

[Vlad]

Good morning!

Could someone explain me exactly how "Publish.." function works?

I don't quite understand which are the files being updated after publishing. I've tried to modify on my own some schema files (ex. MySchema.mondrian.xml), placed in "bi-developers/analysis/", but the result remains unchanged until the next publishing.

p.s.
I took a quick look at source code but I couldn't identify the function that manages the publishing.

Cheers,
Vlad

[gutlez]

It uses a webservice.

It not only uploads the files, but it also calls the refresh repository.
Yes, you can do it manually by uploading the files to the server and calling the refresh manually, but it's much easier to use the publish function.

[Vlad]

Uhm, ok..I've raised the question because I've tried to change manually the scheme, and still, after updating the repository(tools->refresh) nothing has changed.

Actually I was trying to omit the field "type" of the "shared dimension" but it seems that I can't do that :(

[robj]

Vlad,

If you are using Analyzer with EE, Jira issue ANALYZER-201 describes a workaround to get the updated schema in Analyzer:

1. Publish with Schema Workbench
2. Refresh the Solution Repository in the Enterprise Console
3. As an admin user in the User Console, do Tools | Refresh | Mondrian Schema Cache
4. As an admin user, open Analyzer and click the Clear Cache link, then close Analyzer

Now you can open the cube in Analyzer (as any user) and you should see the updated cube definitions that reflect your schema changes.

This method has worked for me with Analyzer since I found the jira note. Before, when I was using Analysis Views, I noticed that Mondrian schema updates didn't always seem to work, but performing the first three steps above might help with that, too.

rob

[Vlad]

Hi Rob,

unfortunately I can't use Pentaho Enterprise Console nor enterprise bi-server because the policy of my employer is open-source-only.

Anyway, the steps that you've suggested can be done also in the Pentaho Administration Console but they didn't work for me :(

I've managed to by-pass the problem in another way:

After I've (manually) modified the schema file, I've opened it with the workbench and published it from there. At this point, refreshing solution and mondrian repository really refresh the repositories and I can see the manually applied changes.

p.s.
By the way, thanks for the tips :)

[richad3]

There is another step which is the update of the datasource.xml under pentaho-solution/system/olap ...
Richad