create local .CUB File in AS2005

Hi,

we have a problem with the "CREATE GLOBAL CUBE" function in AS2005:

While accessing the local .CUB file (created with "CREATE GLOBAL CUBE"), our application only shows key-values for some dimensions instead of their names.
If we use the same statement in AS2000 to create the .CUB, everything is displayed correctly;
as well if the application directly connects to the DB (AS2000 & AS2005).

We used the Profiler to take a look at the traces and found something in the SELECT that is used to fill the new cube after creation:
every dimension is bracketed with "KEY()"
We tested the statement and replaced the "KEY()" with "NAME()" and it looks like this would bring the correct data.

But how do we tell the AS2005 to use NAME() instead of KEY() while compiling the "CREATE GLOBAL CUBE" statement?

Or is there annother way to create the local .CUB file?
We are able to create a cube via xmla ... but how do we write it to a local file?

Thanks for your answers and for tolerating my bad english
best regards,
Sven

I don't know what you mean by the statement "Our application only shows key-values". If you mean your application only displays dimension member keys instead of dimension member names, then, this is a bug that is being fixed in the SP2 release.

You can capture the local cube statement, modify it suitably and send it via MDX Client.

create local .CUB File in AS2005

Hi,

we have a problem with the "CREATE GLOBAL CUBE" function in AS2005:

While accessing the local .CUB file (created with "CREATE GLOBAL CUBE"), our application only shows key-values for some dimensions instead of their names.
If we use the same statement in AS2000 to create the .CUB, everything is displayed correctly;
as well if the application directly connects to the DB (AS2000 & AS2005).

We used the Profiler to take a look at the traces and found something in the SELECT that is used to fill the new cube after creation:
every dimension is bracketed with "KEY()"
We tested the statement and replaced the "KEY()" with "NAME()" and it looks like this would bring the correct data.

But how do we tell the AS2005 to use NAME() instead of KEY() while compiling the "CREATE GLOBAL CUBE" statement?

Or is there annother way to create the local .CUB file?
We are able to create a cube via xmla ... but how do we write it to a local file?

Thanks for your answers and for tolerating my bad english
best regards,
Sven

I don't know what you mean by the statement "Our application only shows key-values". If you mean your application only displays dimension member keys instead of dimension member names, then, this is a bug that is being fixed in the SP2 release.

You can capture the local cube statement, modify it suitably and send it via MDX Client.

Create Global Variable like VB... can it be done?

I just want to store the value of a parameter in a global variable that all my reports in the same project can use.

My goal is to create a dynamic query. For example:

Company Name: Widgets inc.

Divisions: Sales, Service, Tech, Accounting

I have a matrix and when I click on the more information button it goes to another report. I want the next report to know what division is currently selected in the dropdown parameter. So, being a VB programmer, I thought I could store parameter1.division.value into a global variable and update the variable whenever the parameter changes.

This way, on the next report, my query's where statement is the global variable.

@.GlobalVariable = parameter1.division.value

Select name, address, phone FROM Employee WHERE division = @.GlobalVariable

I am using Visual Studio to design this project although I would prefer to use VB or ASP. But this is my only stumbling block right now. Everything else is complete.

Please let me know if anyone can help.

Thanks.

John

There is not a concept of a global variable for multiple reports that I know of.

You could potentially do something with a table that could store the global value by user id & identifier, and retrieve the variable from the table. Or you could setup a web service to get/set the variable.

You may be able to add a reference to a DLL in every report, and share between them, though I woud think it would be destroyed after the report session times out.

http://www.codeproject.com/dll/data_seg_share.asp

cheers,

Andrew

|||

Looks like you need a report parameter. You don't need to show it to the user, but just default it.

create global temporary tables in SQL SERVER

I m trying to create a global temporary table whose data will be deleted after the end of the session..

the DDL in oracle is

CREATE GLOBAL TEMPORARY TABLE STUDENT
(

name CHAR(20),

) ON COMMIT DELETE ROWS ;

I want to know the corresponding DDL in SQL Server..

when i try the following

CREATE TABLE ##STUDENT
(

name CHAR(20),

)

the table gets deleted at the end of the session..help needed

when there is no more connection referencing the

GTT it automatically destroys itself

|||

There is not such a thing. You can create a permanent table and include in it's key the process_id value (which you can get from @.@.spid). Then you just delete the data from the table when you get finished (and when you start in case you don't get things cleaned up because of some error)

On the other hand, is it so bad for what you are doing to just create the structure on each run? And note that ##tables are available to all other connections, #tables just to your session. You should use # tables unless there is some compelling reason to use global temp tables.

'CREATE GLOBAL CUBE' issue

Hi,

I have cube with 10 measures and 20 dimensions. When I do 'CREATE GLOBAL CUBE',
using 10 measures with any 4 dimensions work fine, can create local cube, but could not success when I include 10 measures with any 6 or more dimensions.
The error msg: '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 'myCube' partition of the 'Fact myCube' measure group for the 'myCube' cube from the myCube database.
XML for Analysis parser: The XML for Analysis request timed out before it was completed.

Is it any limitations for 'CREATE GLOBAL CUBE'?

What am I missing?

Any suggestions or input will be appreciated.

Thanks.
We have identified many situations where local cube creation fails with this error. We have not found a way to work around these errors using CREATE GLOBAL CUBE. We have found ways to deal with these errors by using an ASSL Create Cube statement to create local cubes. Our product, CubeSlice, generates the required ASSL to create the local cube. We offer a free 30-day demo, so you can try it at no cost and see if your local cubes can be created with ASSL using all your dimensions. I'd encourage you to try the local cube creation with both a relational data source and an Analysis Server cube source. We give this option on the first tab of our Local Cube Options dialog. If you still get the error you describe when using CubeSlice, let me know, and we'll try to get it fixed.

Tim Peterson
www.cubeslice.com

CREATE GLOBAL CUBE in dataset MDX query.

Hello,
I am attempting to use a CREATE GLOBAL CUBE command when defining a data set in MSRS. The intent is to use the MSRS security and scheduling capabilities to dump local cube files from our data warehouse to a file share, then use MSRS's delivery mechanisms to deliver the cubes to the intended recipient(s). The problem (I believe) is that the command does not return any data, so when rendering the report I bound the dataset to, the server just stops responding. I assume it is waiting for data that will never come. The report itself only contains a text box with a string literal. The good news is that when I try to render the report, the local cube file is generated...I just need the server to finish rendering the "dummy" report. Any ideas? Thanks.
-Rob HoffmanRob, did you look at DTS as an alternative solution?
Reporting Services isn't really meant to be used in the way you're trying to
use it. One area of concern is that you mention the server stops
responding. It it only this particular report that doesn't get rendered, or
does the server stop responding to any request?
-Lukasz
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"Rob Hoffman" <Rob Hoffman@.discussions.microsoft.com> wrote in message
news:6E2F8425-C095-4F36-9A40-C1CD6ADD73DD@.microsoft.com...
> Hello,
> I am attempting to use a CREATE GLOBAL CUBE command when defining a data
> set in MSRS. The intent is to use the MSRS security and scheduling
> capabilities to dump local cube files from our data warehouse to a file
> share, then use MSRS's delivery mechanisms to deliver the cubes to the
> intended recipient(s). The problem (I believe) is that the command does
> not return any data, so when rendering the report I bound the dataset to,
> the server just stops responding. I assume it is waiting for data that
> will never come. The report itself only contains a text box with a string
> literal. The good news is that when I try to render the report, the local
> cube file is generated...I just need the server to finish rendering the
> "dummy" report. Any ideas? Thanks.
> -Rob Hoffman|||Lukasz,
Yes, but RS looked like a better choice out of the box because of its built-in security model, job scheduling, delivery mechanisms and extensibility. The requirements of the project I'm working on make it an expedient alternative to writing code that allows users to define, schedule and deliver local OLAP cubes from our data warehouse source.
To answer your question, when I view (view tab) my dummy report in Report Manager, the report never renders, and my aspnet_wp process consumes all processing power on the server. When I open a second browser window and try to access Report Manager, the page never loads. It looks like there is some sort of infinite loop occurring. I have never observed a timeout, but I have waited several minutes for the process to complete. I ended up having to close the first browser window (stop rendering the dummy report) to get RS to return to normal operation. When I do that, the second browser window finishes rendering my Report Manager screen almost immediately. I'd appreciate any help you or anyone else can provide in resolving this.
-Rob
"Lukasz Pawlowski [MSFT]" wrote:
> Rob, did you look at DTS as an alternative solution?
> Reporting Services isn't really meant to be used in the way you're trying to
> use it. One area of concern is that you mention the server stops
> responding. It it only this particular report that doesn't get rendered, or
> does the server stop responding to any request?
> -Lukasz
> --
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> "Rob Hoffman" <Rob Hoffman@.discussions.microsoft.com> wrote in message
> news:6E2F8425-C095-4F36-9A40-C1CD6ADD73DD@.microsoft.com...
> > Hello,
> >
> > I am attempting to use a CREATE GLOBAL CUBE command when defining a data
> > set in MSRS. The intent is to use the MSRS security and scheduling
> > capabilities to dump local cube files from our data warehouse to a file
> > share, then use MSRS's delivery mechanisms to deliver the cubes to the
> > intended recipient(s). The problem (I believe) is that the command does
> > not return any data, so when rendering the report I bound the dataset to,
> > the server just stops responding. I assume it is waiting for data that
> > will never come. The report itself only contains a text box with a string
> > literal. The good news is that when I try to render the report, the local
> > cube file is generated...I just need the server to finish rendering the
> > "dummy" report. Any ideas? Thanks.
> >
> > -Rob Hoffman
>
>

CREATE GLOBAL CUBE and properties

Hello

in the syntax description of the command

CREATE GLOBAL CUBE

there is a properties part at the end

Are there any examples out whta can be done with this?

I want to force the builkding of a local cube file to ignore errors due to missing attribute keys (like it is possible in the VS IDE)

Thanks in advance
Klaus Wiesel

See my reply to your previous post.

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