Wednesday, March 21, 2012

Problem opening local cube with ProClarity 6.2

I am new to BI and have a perplexing problem. I need to create a local cube for offline use in ProClarity 6.2 for mobile users.

I have created a sample cube in AS2005 using the following code:

CREATE GLOBAL CUBE [RainbowBranch]

Storage 'C:\SourceData\RainbowBranch.cub'

FROM [Rainbow Trade Sales]

(

MEASURE [Rainbow Trade Sales].[Adj Sales Value],

DIMENSION [Rainbow Trade Sales].[Branch]

)

The resultant cube can be opened in Excel 2003 with no problems, but when opened in ProClarity, there is no cube name to select, so I can never get to see the cube data.

Is there a problem with my cube build statement? Does it need more in terms of parameters, etc.

Regards,

Charles.

Hello. The coming 6.3 version of ProClarity, supposed to be released any day, will have strong improvements for local cubes. You can have a problem with a bug in 6.2

HTH

Thomas Ivarsson

|||

Thanks Thomas,

I heard about the forthcoming ProClarity 6.3 release. I believe that it will only be available from our vendor at the end of March, which is a problem in terms of making decisions at this point in time. Anyhow, back to my current problem; A colleague sent me a cub file to test, the cub is named "Debtors Analysis" - I think it is part of sample data but I do not know how it was generated (AS2000 perhaps or ProClarity 5.3 ?). This "Debtors Analysis" cub opens perfectly in both ProClarity 6.1 & 6.2 as well as in Excel 2003. This leads me to believe that my problem lies with my cub file - either something missing in my cub file which causes ProClarity to fail, or something extra in the cub file which ProClarity does not recognise.

Are you aware of any other way to create cub files that I can test in the meantime. Preferably not using another 3rd party, commercial product. Thanks.

Regards,

Charles.

|||Have you tried looking on the Proclarity community bulletin boards... There are many similar posts

No comments:

Post a Comment