Current Lanaguage in connection?

Hi.

I have a SQL Server Analysis Services Connection in Reporting Services. But my problem is that I need to allways have the same language on dataset values. Since I have multiple languages in my olap it all depends on the language setting on the invidual computer what language the new dataset values will become. Since the developers have diffrent language settings the datasets can get really ugly. I would prefere to have english on dataset values under development. But only on the dataset becouse our reports support more then one language.

I found a Current Language property under the connection setting that might be what I'm looking for? But I get error message becouse from format no mather what format I try. I have tryed stuff like, en, en-US, english, en-english and many more but havnt managed to find one that works yet.

Do anyone know what format the Current Language expect? And do anyone know if it would solve my proble, or if there are som other way to solve my problem?

Thanks!

I'm not familiar with Current Language, but the Locale Identifier property of the AS connection string expects a LCID. I used this a while back for dynamic languages (see http://blogs.msdn.com/bwelcker/archive/2005/07/03/435130.aspx) If this doesn't work, you could try posting over at the SSAS forum.|||

Thanks Brian.

The Locale Identifier was exactly what I was looking for! The only reason I asked about the Current Language was becouse it was the only advanced parameter I found that might have somthing to do with language. But when adding Locale Identifier directly to the string it worked perfectly!

Thanks again.

Currency in Analysis Services

Hi,

All the reports with comes out as $ (ex.) ( $123,437,00) I am working for the requirement that the same report has to show in multiple currency (ex.) ($,Yen,Pound,AUS$ ).As i am in Analysis Side can anyone give good Suggestion to get the output. Do any one faced the same?

Take a look at the following entry on Mosha's Blogsite:

http://sqljunkies.com/WebLog/mosha/archive/2005/10/13/mdx_format_currency.aspx

HTH,

Steve

Cumlative totals

I am developing a table in SQL Server for data analysis, and what i want to
do is have a cumlative total field. Is there a way when I am doing an insert
data, I could populate a column with a running total?
Thanks.Lyners,
Yes - one option is to create a trigger on the table to update the cumlative
total field.
HTH
Jerry
"Lyners" <Lyners@.discussions.microsoft.com> wrote in message
news:A408D891-7199-4B21-9F18-E6E88FE2C434@.microsoft.com...
>I am developing a table in SQL Server for data analysis, and what i want to
> do is have a cumlative total field. Is there a way when I am doing an
> insert
> data, I could populate a column with a running total?
> Thanks.|||the update and delete triggers might be quite involved.
Under most circumstances I would rather write a select query
calculating running totals - that would be way simpler|||Maybe...but Lyners just mentioned INSERTs so that doesn't seem too involved.
But agreed a stored procedure could be created to update the running total
column and then scheduled as a job for non peak hours.
HTH
Jerry
"Alexander Kuznetsov" <AK_TIREDOFSPAM@.hotmail.COM> wrote in message
news:1127943367.558805.246800@.g47g2000cwa.googlegroups.com...
> the update and delete triggers might be quite involved.
> Under most circumstances I would rather write a select query
> calculating running totals - that would be way simpler
>|||On Wed, 28 Sep 2005 14:13:05 -0700, Lyners wrote:

>I am developing a table in SQL Server for data analysis, and what i want to
>do is have a cumlative total field. Is there a way when I am doing an inser
t
>data, I could populate a column with a running total?
>Thanks.
Hi Lyners,
Why not create an indexed view, and have SQL Server do all the hard work
of changing the running total when the underlying data changes?
Look up CREATE UNIQUE CLUSTERED INDEX in Books Online.
Best, Hugo
--
(Remove _NO_ and _SPAM_ to get my e-mail address)|||I made a procedure that uses a curser that goes through and updates all of
the running totals. Very fast and easy.
Thanks!
"Jerry Spivey" wrote:

> Maybe...but Lyners just mentioned INSERTs so that doesn't seem too involve
d.
> But agreed a stored procedure could be created to update the running total
> column and then scheduled as a job for non peak hours.
> HTH
> Jerry
> "Alexander Kuznetsov" <AK_TIREDOFSPAM@.hotmail.COM> wrote in message
> news:1127943367.558805.246800@.g47g2000cwa.googlegroups.com...
>
>

Cubes Generation error. different between MOLAP, ROLAP

I am using one cubes for my sales analysis.
When I try to redesign storage and Process the cube from MOLAP to ROLAP, it
create error with something related to fail to create index.
I didn't change the cube design.
What information I need to be careful ?
Hi Kam.
This error is usally related to Real-Time OLAP. Are you trying to re-design
the storage mode of your cube as a Real-Time? This feature requires special
settings in the relational database.
You may find more information here
http://msdn.microsoft.com/library/de...eties_0o4z.asp
Hope that helps.
"Kam" wrote:

> I am using one cubes for my sales analysis.
> When I try to redesign storage and Process the cube from MOLAP to ROLAP, it
> create error with something related to fail to create index.
> I didn't change the cube design.
> What information I need to be careful ?

Cubes Generation error. different between MOLAP, ROLAP

I am using one cubes for my sales analysis.
When I try to redesign storage and Process the cube from MOLAP to ROLAP, it
create error with something related to fail to create index.
I didn't change the cube design.
What information I need to be careful ?Hi Kam.
This error is usally related to Real-Time OLAP. Are you trying to re-design
the storage mode of your cube as a Real-Time? This feature requires special
settings in the relational database.
You may find more information here
http://msdn.microsoft.com/library/d...ieties_0o4z.asp
Hope that helps.
"Kam" wrote:

> I am using one cubes for my sales analysis.
> When I try to redesign storage and Process the cube from MOLAP to ROLAP, i
t
> create error with something related to fail to create index.
> I didn't change the cube design.
> What information I need to be careful ?

cubes error

Hi,

I want to know, if i can use (work) with the Analysis service tutorial of adventurewoks database in MS XP Pro

i use the SQL server 2005 enterprice edition .

When i deploy my analysis service tutorial, i can't connect to my server?(lesson reviewing cubes and demension, in SQL book online)

I checked my firewall,Protocols, restarted my SQL browser and SQL server,checked my windows authentication and i can't connect to my server.

Help help help.

Not sure if you can install SQL Server Enterprise edition on the XP. But I think you can install Developer edition there.

Try and open Adventure works sample project and try deploying it to the Analysis Server. If you were able to successfully deploy the project, you should be able to browse it as well.

Hope that helps.

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

Cube structure to be "redone" everytime on changing Data Source in Analysis Services20

Hi Folks,

I have a strange discovery. This use to work fine with AS 2000.

Here's the problem : I have a AS 2005 cube "Cube1", existing with all the functionality. I want to test some things - so I did cube "Save As" tstCube1. Now tstCube1 is my test cube. I changed the data source in tstCube1 to a "new" SQL database ( this new database is exactly the same schema structure as compared to the schema that original Cube1 refers). Here's what I see now in tstCube1 -- all the calculated members, relationships in data source view, all hierarchies -- all gone. I don't see them in tstCube1, although I see them in original Cube1.

Do I have to redo the cube structure everytime I change a datasource. This could be a potential nightmare - because on migrating cubes from Dev -> Test--> Production, I have to change the data sources all the time. Does this mean everytime I change the data source -- the whole cube has to be redone.

Your suggestions are most welcomed. Thanks for any ideas...

-- Savvy

There is a difference between moving to a new data source and editing the existing data source to point to a different database. I edit the data source connect string all of the time.

_-_-_ Dave

|||Thanks Dave. That worked..

Cube structure to be "redone" everytime on changing Data Source in Analysis Services20

Hi Folks,

I have a strange discovery. This use to work fine with AS 2000.

Here's the problem : I have a AS 2005 cube "Cube1", existing with all the functionality. I want to test some things - so I did cube "Save As" tstCube1. Now tstCube1 is my test cube. I changed the data source in tstCube1 to a "new" SQL database ( this new database is exactly the same schema structure as compared to the schema that original Cube1 refers). Here's what I see now in tstCube1 -- all the calculated members, relationships in data source view, all hierarchies -- all gone. I don't see them in tstCube1, although I see them in original Cube1.

Do I have to redo the cube structure everytime I change a datasource. This could be a potential nightmare - because on migrating cubes from Dev -> Test--> Production, I have to change the data sources all the time. Does this mean everytime I change the data source -- the whole cube has to be redone.

Your suggestions are most welcomed. Thanks for any ideas...

-- Savvy

There is a difference between moving to a new data source and editing the existing data source to point to a different database. I edit the data source connect string all of the time.

_-_-_ Dave

|||Thanks Dave. That worked..

Cube Processing Error

Hi,
I am trying to Process a analysis server Cube and I am getting an error message saying
syntax error converting the varchar value A.H to column of type int.; 22018.
Can somebody tell me how to remove this error.
Thanks,
PraveenClean up the data? It is telling you that you are trying to convert a string that contains "A.H" to an int, and not even my creative interpretations of literals can manage that feat!

-PatP|||Thanks for the reply.Its solved now.

Cube processed time always shows current time.

I have an issue with the "processed" time that shows on the analysis
manager. Every time I open Analysis Services and click on my database, one
of my cubes shows the current time for being "processed" under metadata.
Not all of my cubes shows this time. My database and cube have the same
name (don't know if this means anything, but my other cubes have different
names.
Any help?
Eric
Message posted via http://www.webservertalk.comYou might get better help over in microsoft.public.sqlserver.olap or
microsoft.public.sqlserver.datawarehouse
Please post DDL, sample data and desired results.
See http://www.aspfaq.com/5006 for info.
"Eric Wiltrout via webservertalk.com" <forum@.webservertalk.com> wrote in message
news:55c55310d5784032b6089b6f75c89123@.SQ
webservertalk.com...
> I have an issue with the "processed" time that shows on the analysis
> manager. Every time I open Analysis Services and click on my database,
one
> of my cubes shows the current time for being "processed" under metadata.
> Not all of my cubes shows this time. My database and cube have the same
> name (don't know if this means anything, but my other cubes have different
> names.
> Any help?
> Eric
> --
> Message posted via http://www.webservertalk.com

Cube Partition

How do you slice a Cube Partition, if you want it to slice by "less than" instead of "equal to"? Analysis Services does not give you a choice.
Example: Time.FiscalYear AllTime.FY2005

Unfortunately, it looks like it can't be done without explicitly naming all the members included in the "less than" slice. For instance, if you wanted "less than" 2003, generally in MDX you'd just say {null:[Date].[Calendar Year].&[2003]}. But, for reasons I'll explain below, it doesn't appear that SSAS allows such an expression as the slice for a partition. Instead, you have to manually list all the members: {[Date].[Calendar Year].&[2001],[Date].[Calendar Year].&[2002],[Date].[Calendar Year].&[2003]}

If I understand this correctly, the "slice" for a partition has to be a string which resolves to a set. The way SSAS resolves it to a set is by running it through StrToSet("your slice",CONSTRAINED). The CONSTRAINED parameter tells it to only accept a simple set of explicitly named members. So StrToSet("{null:[Date].[Calendar Year].&[2003]}",CONSTRAINED) blows up during processing with the following error: "Errors in the OLAP storage engine: The restrictions imposed on partition slice where violated."

Though that's not a very good error message, I think that's what's happening because the following MDX query blows up:

select StrToSet("{null:[Date].[Calendar Year].&[2003]}",CONSTRAINED) on 0
from [Adventure Works]

One problem is that when you do a syntax check in Visual Studio when you're constructing the partition slice, it says it checks out fine... I've reported this as a bug:
https://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=155391

Just as reference on where I got my info...

Info on what the Slice property of a partition allows (i.e. only something that works with StrToSet and CONSTRAINED):
http://msdn2.microsoft.com/en-us/library/microsoft.analysisservices.partition.slice(d=ide).aspx

Info on how the CONSTRAINED parameter works:
http://cwebbbi.spaces.msn.com/blog/cns!7B84B0F2C239489A!488.entry

Cube Partition

How do you slice a Cube Partition, if you want it to slice by "less than" instead of "equal to"? Analysis Services does not give you a choice.
Example: Time.FiscalYear AllTime.FY2005

Unfortunately, it looks like it can't be done without explicitly naming all the members included in the "less than" slice. For instance, if you wanted "less than" 2003, generally in MDX you'd just say {null:[Date].[Calendar Year].&[2003]}. But, for reasons I'll explain below, it doesn't appear that SSAS allows such an expression as the slice for a partition. Instead, you have to manually list all the members: {[Date].[Calendar Year].&[2001],[Date].[Calendar Year].&[2002],[Date].[Calendar Year].&[2003]}

If I understand this correctly, the "slice" for a partition has to be a string which resolves to a set. The way SSAS resolves it to a set is by running it through StrToSet("your slice",CONSTRAINED). The CONSTRAINED parameter tells it to only accept a simple set of explicitly named members. So StrToSet("{null:[Date].[Calendar Year].&[2003]}",CONSTRAINED) blows up during processing with the following error: "Errors in the OLAP storage engine: The restrictions imposed on partition slice where violated."

Though that's not a very good error message, I think that's what's happening because the following MDX query blows up:

select StrToSet("{null:[Date].[Calendar Year].&[2003]}",CONSTRAINED) on 0
from [Adventure Works]

One problem is that when you do a syntax check in Visual Studio when you're constructing the partition slice, it says it checks out fine... I've reported this as a bug:
https://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=155391

Just as reference on where I got my info...

Info on what the Slice property of a partition allows (i.e. only something that works with StrToSet and CONSTRAINED):
http://msdn2.microsoft.com/en-us/library/microsoft.analysisservices.partition.slice(d=ide).aspx

Info on how the CONSTRAINED parameter works:
http://cwebbbi.spaces.msn.com/blog/cns!7B84B0F2C239489A!488.entry

Cube Deploy Error

Hello, I'm trying to deploy a cube on Analysis Services and I'm getting the next error:

Errors in the OLAP storage engine: The record was skipped because the attribute key was not found. Attribute: DSAP PRODUCTO of Dimension: DSAP PRODUCTO from Database: SAPIN_BI, Cube: Sapin BI Dllo, Measure Group: DSAP COMBOS, Partition: DSAP COMBOS, Record: 1.

I'm sure the data is consistent and has integrity.... and I verified It ...

Could you please give me a clue ?

What do I have to post or which script do I have to send you ?

Thanks a lot !

jortiz wrote:

Hello, I'm trying to deploy a cube on Analysis Services and I'm getting the next error:

Errors in the OLAP storage engine: The record was skipped because the attribute key was not found. Attribute: DSAP PRODUCTO of Dimension: DSAP PRODUCTO from Database: SAPIN_BI, Cube: Sapin BI Dllo, Measure Group: DSAP COMBOS, Partition: DSAP COMBOS, Record: 1.

I'm sure the data is consistent and has integrity.... and I verified It ...

Could you please give me a clue ?

What do I have to post or which script do I have to send you ?

Thanks a lot !

Hello, Is there any service like a kind of remote desktop via Web, to show you the problem ?

|||

Assuming your cube is built on top of a SQL Server relational database, your best bet might be to use Profiler to capture the SQL queries being generated by SSAS as it processes your cube. Then look at the queries and try to determine what query is returning unexpected data. More than likely the problem lies in the design of the dimension usage within the cube. Perhaps one of the dimensions is related to one of the measure groups based on the wrong attribute or fact table column?

HTH,

Dave Fackler

|||

Dave Fackler wrote:

Assuming your cube is built on top of a SQL Server relational database, your best bet might be to use Profiler to capture the SQL queries being generated by SSAS as it processes your cube. Then look at the queries and try to determine what query is returning unexpected data. More than likely the problem lies in the design of the dimension usage within the cube. Perhaps one of the dimensions is related to one of the measure groups based on the wrong attribute or fact table column?

HTH,

Dave Fackler

Hi Dave, It doesn't matter which dimensions and fact table I use, I get a similar error like this:

Errors in the OLAP storage engine: The attribute key cannot be found: Table: dbo_HSAP_REDENCIONES, Column: NMPRODUCTO_KEY, Value: 1. Errors in the OLAP storage engine: The record was skipped because the attribute key was not found. Attribute: DSAP PRODUCTO of Dimension: DSAP PRODUCTO from Database: SAPIN_BI, Cube: Sapin BI Dllo, Measure Group: HSAP REDENCIONES, Partition: HSAP REDENCIONES, Record: 1. Errors in the OLAP storage engine: The process operation ended because the number of errors encountered during processing reached the defined limit of allowable errors for the operation. Errors in the OLAP storage engine: An error occurred while processing the 'HSAP REDENCIONES' partition of the 'HSAP REDENCIONES' measure group for the 'Sapin BI Dllo' cube from the SAPIN_BI database.

|||

Based on the errror message, it would appear that your fact table has a column named NMPRODUCTO_KEY and a record was read from the fact table that has a value of 1 in that column. In addition, the measure group HSAP REDENCIONES would appear to be related to the DSAP PRODUCTO dimension using the NMPRODUCTO_KEY column to match the DSAP PRODUCTO attribute (which appears to be serving as the key attribute in the dimension). The question is: do any of the members in the DSAP PRODUCTO dimension have a key value of 1 for the DSAP PRODUCTO attribute? What column in the underlying dimension table is the DSAP PRODUCTO attribute based on?

Dave F.

|||

Sorry if I interfere. Have you added a new column to your fact table lately that was not in the processed cube initially?

If you use query binding for the partition(s) this new column will not appear automatically. You will have to add it yourself.

This looks like a problem that I had a few days ago.

Regards

Thomas Ivarsson

|||

Thomas Ivarsson wrote:

Sorry if I interfere. Have you added a new column to your fact table lately that was not in the processed cube initially?

If you use query binding for the partition(s) this new column will not appear automatically. You will have to add it yourself.

This looks like a problem that I had a few days ago.

Regards

Thomas Ivarsson

Thank you so much for your answers !!

|||

What solution did work?

Regards

Thomas Ivarsson

Cube DDL reverse engineer ?

Hi guys

I have built several cubes. However I would need to create local cubes from the built cubes in Analysis Services. As a result I need to work out the DDL for my existing cubes. However the cube contains many mdx calculated members. I was wondering if it would be easier to simply generate the DDL from my existing cube in Analysis Services.

Does anyone know any third party tools that I can use to reverse engineer the DDL from the built cubes in Analysis Services ?

Thanks

Tom

Why not just load it in Server Manager and tell it to Script Database as Create. That should give you the full DDL I believe.|||I want to script the cube not the sql server database.

If there is a way could you please give a more detailed description of the process.

I really appreciate it ! thankyou !

Tom|||The cube is contained in an Analysis Services database, not a SQL Server database. Or are you saying that your AS database contains multiple cubes and you only want to script out one?

Start SQL Server Management Studio
When asked to connect to server drop the Server type down and pick Analysis Services
Expand the databases node.
Right click on a database
Select Script Database as Create To

Alternatively if you want just one cube expadn the cubes node
Right click on the cube you are interested in
Select Script Cube as Create To|||Start SQL Server Management Studio
When asked to connect to server drop the Server type down and pick Analysis Services
Expand the databases node.
Right click on a database
Select Script Database as Create To
__

I've started sql server enterprise manager. When I tried to make a new registration under a sql server group it DOES NOT pick up analysis services. I know they're running on different ports why would sql server manager pickup analysis services ?

can you confirm the process please. I really can't see it working. As there's no possible way for sql server manager to connect to analysis services.

Thankyou
Tom

|||Tom,

I think I see the problem. I'm betting you are using Analysis Services 2000, not Analysis Services 2005...

With SQL Server 2005, the new management tool (called SQL Server Management Studio) replaces Enteprise Manager in SQL Server 2000. SQL Server Management Studio does indeed have the ability to connect to Analysis Services as well as SQL Server. And it has the ability to script the DDL for an entire Analysis Services 2005 database as well as any portion thereof.

However, since you are likely using Analysis Services 2000, this won't work for you. If you need to generate the DDL to create a cube, you'll have to look to some third-party tool options for this as Analysis Manager does not have the ability to generate DDL. Take a look at the short list of options mentioned on Mosha's website at http://www.mosha.com/msolap/util.htm#Metadata. This should at least give you some ideas and options...

Dave Fackler
|||thanks for that at least now I have a good idea what the other person's talking about

Thanks
Tom

Cube Calculations and Report Model Problems

Hello all,

I understand this is an Analysis Services board, but due to the topic, I thought it would be as good of a place as any. I have also cross-posted to the reporting services group.

I've been working with SSRS for a year and a half now, but I am brand new to SSAS. I've gone through tutorials and did as much reading as I could.

The underlying data I am using is similar to the following:

Shift_Start Shift_End Machine_ID Breakdown_Min ... Quality_Pct
1/1/2005 7am 1/1/2005 5pm 535 120 .55

As you can tell, we have one record for each shift. This stores breakdown minutes (as well as many other additive measures). As it stands now, we've also stored percentages in the table (although this could be removed and calculated within the cube).

Because the percent won't add up across dimensions, I removed that measure and created a calculation. This calculation does the work necessary to come up with the percentages. I have no problems using the calculations in the cube browser.

This is where SSRS comes into play. I created a data source to point to the cube and generated a data model. I then used the Report Builder to create a report based on this model.

My problem is that I cannot see the calculations I defined. As I see it, mabye the report model isn't completely integrated with analysis services cubes yet? Has anyone else noticed this behavior and/or has anyone found a solution? I hope it is as simple as me missing a setting...

Thank you for taking the time...

Regards,

Dan

I hate to break it to you Dan but I think you will need to figure out a different way of doing it... here is some discussion about using Report Designer but I think the same would apply to Report Builder:

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=64253&SiteID=1

The gist, I believe, is that you can use Calculated Measures but not Calculated Members. The other limitations on the Query, ie only measures on the columns is a real pain too. Oh well maybe it will be fixed in a service pack one of these years...

Sorry 'bout that =/

Cube Calculations and Report Model Problems

Hello all,

I understand this is an Analysis Services board, but due to the topic, I thought it would be as good of a place as any. I have also cross-posted to the reporting services group.

I've been working with SSRS for a year and a half now, but I am brand new to SSAS. I've gone through tutorials and did as much reading as I could.

The underlying data I am using is similar to the following:

Shift_Start Shift_End Machine_ID Breakdown_Min ... Quality_Pct
1/1/2005 7am 1/1/2005 5pm 535 120 .55

As you can tell, we have one record for each shift. This stores breakdown minutes (as well as many other additive measures). As it stands now, we've also stored percentages in the table (although this could be removed and calculated within the cube).

Because the percent won't add up across dimensions, I removed that measure and created a calculation. This calculation does the work necessary to come up with the percentages. I have no problems using the calculations in the cube browser.

This is where SSRS comes into play. I created a data source to point to the cube and generated a data model. I then used the Report Builder to create a report based on this model.

My problem is that I cannot see the calculations I defined. As I see it, mabye the report model isn't completely integrated with analysis services cubes yet? Has anyone else noticed this behavior and/or has anyone found a solution? I hope it is as simple as me missing a setting...

Thank you for taking the time...

Regards,

Dan

I hate to break it to you Dan but I think you will need to figure out a different way of doing it... here is some discussion about using Report Designer but I think the same would apply to Report Builder:

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=64253&SiteID=1

The gist, I believe, is that you can use Calculated Measures but not Calculated Members. The other limitations on the Query, ie only measures on the columns is a real pain too. Oh well maybe it will be fixed in a service pack one of these years...

Sorry 'bout that =/

Cube calculation error

Upon building a cube in analysis services, i go to the calculations tab and i get an an error on the page... "Unexpected error occurred: Error in the application".!!!!

Thus, i can't do any calculated measures. Anyone, know what this is ?

Thanks LP

Check out http://support.microsoft.com/default.aspx/kb/926421.|||There are 2 DLLs msmdlocal.dll and msmgdsrv.dll in these folders:
C:\Program Files\Microsoft Visual Studio 8\Common7\IDE\PrivateAssemblies
C:\Program Files\Common Files\System\Ole DB

The ones in the PrivateAssemblies folder are older versions so you copy the ones from the OLE DB folder to the PrivateAssemblies folder and the problem goes away.

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 $$$.

Cube Browser FAILS to open. It HANGS

Hi, I am working on the Analysis Services Tutorial.

When I am in Business Intelligence Studio and I right-click on the cube and I choose browse to open the cube-browser, the Cube-Browser HANGS FOREVER. it never finishes opening. I always end up using the taskmgr to kill off Business Intelligent Studio. How is this HANGING problem fixed?

AIMDBA

The Event Viewer Applicaiton log is showing the following:

Hanging application devenv.exe, version 8.0.50727.42, hang module hungapp, version 0.0.0.0, hang address 0x00000000.

For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.

Fault bucket 230214627.

For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.

AIMDBA

|||

Try to see if re-installing Analysis Services will solve the problem.

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

Cube Browser

Hi all,
I created a cube in analysis services project in a computer where sql server 2005 is not installed there, when I try to click on Browser tab in the cube, the following error occurs:
TITLE: Microsoft Visual Studio
A connection cannot be made. Ensure that the server is running.
ADDITIONAL INFORMATION:
Unable to read data from the transport connection: An existing connection was forcibly closed by the remote host. (System)
An existing connection was forcibly closed by the remote host (System)

Anyone have any idea on how to solve it? Thanks in advance.
Daren

Did you deploy your cube? Did you process it?

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

|||Hi Edward,
I tried to deploy it to my server using the ip address, the same connection error came up.
Daren
|||

This could be permission issue.

Check if you have Admin rights to Analysis Server.

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

|||Hi Edward,
Thanks for helping out. But where do I check the rights to Analysis Server? I tried browsing through the properties of the user, could not find anything about Analysis Server.
Daren
|||

Daren.

First, please make sure you install Analysis Services on your machine.

After you installed it, you should be able to deploy your project to Analysis Server.

I strongly recommend you try and work you way through tutorial for Analysis Services. Looks like you are missing very basic knowledge.

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

|||Hi Edward,
To make the picture clear, I already have analysis services installed and go through the tutorial provided in BOL, and I managed to get it to work fine in another computer (which I installed sql server with analysis services in it as well for testing purpose). Then I redo the same steps on the another computer (installed with the same settings), the only difference on both computer are testing pc is windows 2000 with latest sp installed, the other one (that I have problem browsing the data) is using windows server 2003. I have no idea how to go about from there, that's why I posted my question here.
Daren
|||

Are you an Admin on Win2003 machine?

Can you connect to Analysis Services using SQL Management Studio? Can you see your database ?

The project you develop in BI Dev Studio needs to be deployed. Only after you deploy the project to Analysis Server, you will be able to browse your cube.

After you deployed your cube, you can navigate to it in SQL Management studio and browse it from there.

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