Showing posts with label tool. Show all posts
Showing posts with label tool. Show all posts

Saturday, February 25, 2012

Cube documentation

Hello everyone,

I'd like to ask for your personal experience with documenting cubes. Is out there any good tool for that, something as Olapscribe for 2000, latest PowerDesigner or any other commercial tool available? It would be good to have something in BIDS helper also...

Thanks!

Radim

Hello! I have seen this tool http://www.bidocumenter.com/Public/CompareProducts.aspx and tried it.

It is not that good for Analysis Services 2005 documentation though. Even with this tool you will need to do additional work.

HTH

Thomas Ivarsson

|||You could try BI Dcoumenter, it produces an HTML version of the 2005 cubes or a complied HTML. Quite clever, except the diagrams are a little annoying as you need to recreate them, each time you take a new version of the database.|||Yes, I've seen that one also. I'll try the other tools listed on Compare page. I didn't take any deep look, but it seems a bit technical to me. I need something that normal user could look into and check what cubes/dimension/attributes do we have and what is the purpose of them.

Radim Hampel

Cube design e best client tool to access olap database

Hi all,

My doubt is about the best client tool to use for access cube olap. Currently i use excel for some tests but when expand until third ou fourth level the query delays a time not acceptable many times hanging the virtual server.

Another doubt is about cube design the bahavor described above is normal?

Is my server i have a fact table with 211.000 rows, 17 columns (with two calculations columns) and 15 dimension tables ( I think tha is a small database). This tables are organized in a starschema inside a SQL Server 2005 database. The cube 15 dimensions (one with two hierarquies) and with five partitions based in the hierarquies.

Virtual Server Configuration:

512MB Physical Memory.

CPU Intel Core Centrino 1.66GHz

Windows 2003 SP1

SQLServer 2005 SP2

Apologies about my english.

Thanks

Hi!

It is a little bit hard to tell without knowing more about your cube. Have you designed proper attribute relationsships and aggregations? You can download the performance guide for AS2005 pointed to a the top of this group.

Next, I think that a cube of that size and that many dimensions will require more memory than 512 MB. I also run AS2005 on my laptop but not as a virtual server(because it is slower) and I have 2 GB of physical memory.

The problem in Excel might be related to the physical limits of you machine. To do a real test of Excels limits you should run it from a workstation without any server software installed. In that case 512 MB can be enough even if most workstations today have at least 1 GB RAM installed.

HTH

Thomas Ivarsson

Tuesday, February 14, 2012

crystalreportviewer in .NET different language?

When i show a report in a crystalreportviewer control,it appears those buttons,each with tool tips,also that "Main Report" text,can all this be modified ,to right something else?
for example in a aplication for countries that not use english,especially in europe,it should be all texts in different languages,so changing those texts.can this be modified?

Many thanks.Hi Jassie,

Did you solve that problem?

if yes, How?

I have the same problem,|||You may try this:

http://marian.ideaz.sk/crystal/