Cube Translation

Hi,

I'd like to automate cube translation for browsing and i'm wondering how i can do that.

Actually i have a translation table that contains all my labels and the corresponding translation. I want to integrate these translations without using the manual interface in the cube (too long and to avoid possible mistakes).

Does anyone have an idea?

thanks

You can use AMO ( Analysis Management Objects) object model to create objects. Try and see samples of how to program with AMO installed into C:\Program Files\Microsoft SQL Server\90\Samples\Analysis Services\Programmability\AMO.

Edward.
--
This posting is provided "AS IS" with no warranties, and confers no rights.

Cube throws an error while browsing

Hi,
One of cubes when browsed through proclarity showed
nothing. To debug the same, I browsed through analysis
services and the values were "#ERR". There was no
change to the structure of the cube. The cube
processing log shows that the cube was refreshed
successfully.
I then again reprocessed the cube in "Refresh" mode and
it worked fine.
Any clue of why had this happen to just one of the cube?
I was fortunate that this happenned to a smaller cube,
otherwise I would have been to a toss?
Any advice?
Thanks,
Lakshman.
if double click on #ERR, what error you see?
Wei Zhang
Microsoft OLAP Support

Cube throws an error while browsing

Hi,
One of cubes when browsed through proclarity showed
nothing. To debug the same, I browsed through analysis
services and the values were "#ERR". There was no
change to the structure of the cube. The cube
processing log shows that the cube was refreshed
successfully.
I then again reprocessed the cube in "Refresh" mode and
it worked fine.
Any clue of why had this happen to just one of the cube?
I was fortunate that this happenned to a smaller cube,
otherwise I would have been to a toss?
Any advice?
Thanks,
Lakshman.if double click on #ERR, what error you see?
Wei Zhang
Microsoft OLAP Support

Cube browsing for endusers

Hi all,

Browsing a cube using SQL server management studio and Analysis servcices project is possible. Is there any possibility to have custom application built to have the option of browisng without opening Studio management or analysis services project?

Purpose of this is simple. End user should simplay have measures and dimensions and he will just drag and drop in to the browse area.

One thing I really like about Microsoft is that almost anything is possible . Programming one cube/dimension browser yourself is quite an interesting task. I'd use AMO to get the cube and it's dimensions structures, and then I'd use those to build up MDX queries when the user drags-n-drops. To enumerate the cube and dimensions is very easy using AMO. The hard thing here is to convert the drag-n-dropping into well formed and accurate MDX. Like did they drop on columns, rows, as a filter etc? Which hierarchy and level did they expand/drill down?

Some resources:

Query using C#: http://www.devhood.com/tutorials/tutorial_details.aspx?tutorial_id=640

AS objects: http://technet.microsoft.com/en-us/library/ms124924.aspx

There is a good example on how to enumerate an OLAP db in the SQL Server samples, which can be downloaded here:

http://www.microsoft.com/downloads/details.aspx?familyid=e719ecf7-9f46-4312-af89-6ad8702e4e6e&displaylang=en

After installation the AMO browser is located at c:\Program Files\Microsoft SQL Server\90\Samples\Analysis Services\Programmability\AMO\AmoBrowser\

Else there is this ProClarity browser which allow end users (say management) to browse a cube in an intuitive way, but that one costs $$$.