HELP OLAP Cubes

Mar 3, 2004

When I try to modify a OLAp Cube, suddenly appears a Error message

"Unknow Error. Restart the Application"

And this break my cube down

This is not always, just some time, for example when I proof the cube on Microsoft Excel or After I backed up the databes of analysis

What can I do?
I'll thanks your quick answer

NOTE: My cube use MOLAP aggregations

View 1 Replies


ADVERTISEMENT

Distributing OLAP Cubes

Aug 18, 2000

I'm looking into adding OLAP Cubes as part of our software to be distributed with our OLTP and eventually OLAP databases.
Is there any books that deal with distributing OLAP Cubes and or security.
Our clients will have SQL Server with our databases.
Thanks

View 1 Replies View Related

Scripting OLAP Cubes

Mar 16, 2000

Is there a way to script your OLAP cubes created in OLAP Manager to e.g. text files with CREATE CUBE and SELECT INTO statements.

View 1 Replies View Related

OLAP Cubes And Programming

Jul 20, 2005

I cannot seem to find a group where this question would fit so I amposting it here. I have what I believe is a unique situation. I amusing SQL Server Analysis Server to build a cube of "snapshot"month-end type of data. This data is from an instance of MicrosoftNavision and I have successfully used SQL-DMO and DTSPackage Libraryobjects to allow the user to rebuild the cube through Navision. Thisis accounting data and as such, the accountants want to be able toarchive this data by month. I know through Analysis Server Managerinterface I can copy the cube and save it to a different name.I would like to know if there is a way to programmatically save a cubeto a different name with some type of automation object?Thanks

View 1 Replies View Related

Mining On Olap Cubes

Dec 26, 2007

While creating a model, i can access to relational tables as data source, but not to olap cubes. Is it possible to browse olap cubes for mining? If yes, how? Thanks...

View 4 Replies View Related

Reports With OLAP Cubes

Apr 19, 2006

Hi



I try to design a report with Chart based on an Analysis Services Data source...

It does'nt work !!!

Has anyone else the same problem??



View 2 Replies View Related

User Rights In OLAP Cubes

Jul 12, 2000

How can we allow users to access a MS SQL Server OLAP cube but restrict the level of data that he might see?
I mean, if there is a cube with data for three different countries. How can one user be restricted to see data pertaining to
only one of the countries and not the other two countries?

View 2 Replies View Related

OLAP 2000 - Cubes - Filters

Sep 14, 2000

Does anyone know the best way to set up filters against the Cube data.
Ex. The Cube was built with data for 1998,1999, 2000.
The totals and the rollups will include the value for all years.
Client A want to access the Cube Data through Excel 2000 but only wants to see the values for 1999 - with the correct totals and rollups...

I know you can uncheck the other years in the filters in excel, but the totals and rollups will still include the values summing for all years.

Is there away to pass in a query on the fly?

Thanks.

View 1 Replies View Related

Automatically Refreshing OLAP Cubes...

Dec 14, 2000

Can someone tell me how you can automate the refresh of OLAP Cubes? I just inhereted a data warehouse running on SQL7 and the idea of having to go in and manually refresh the cubes everyday is, well... stupid. I can't believe that they've been doing this for a year. Unfortunately, I'm not familar enough with MSOLAP yet and I can't figure this out. Any tips?

View 2 Replies View Related

Moving OLAP Cubes / Databases

Oct 9, 1999

How can I move OLAP Databases / specific cubes or virtual cubes from our Development Server to the UAT or LIVE servers ?

Thanks,

Lee

View 1 Replies View Related

ADHOC Reports Using OLAP Cubes

Mar 13, 2008

Hi,

i want to know whether it is possible to develop ADHOC reports using SSRS 2005 and OLAP Cubes. the requirement is the user should be able to select the columns he wants to see in the report.

I think this requires Dynamic RDL generation. It is very urgent. i have to give POC to the client on this. Any help in this regad is appreciated.

Thanks,
Srik

View 4 Replies View Related

Question On OLAP Cubes Storage Modes

May 24, 2007

Hi, all experts here,



Thank you very much for your kind attention.



I am having a question on the SSAS2005 OLAP Cubes storage modes. We know SSAS2005 supports 3 different storage modes: ROLAP, MOLAP, HOLAP.



Do all these three storage modes of cubes store data in another physica analysis services databases which are inrelative from their data warehouse (in case they are built on top of the data warehouse)? (so it does not matter at all even we remove the data warehouse?)



Thank you very much in advance for your help and I am looking forward to hearing from you shortly.



With best regards,



Yours sincerely,



View 7 Replies View Related

Windows Forms: Can You Deploy OLAP Cubes Through Winforms?

Nov 16, 2007

Hi all,

Does anyone know if its possible to set up OLAP Cubes in a Winform?

Thanks,

Rob

View 2 Replies View Related

Analysis :: Create OLAP Cubes Using NAV 2009 SP1 Database

Feb 13, 2012

I am attempting to create som OLAP cubes using the NAV 2009 SP1 database. I am using Jet Enterprise with TimeXtender4 to build the cubes.

View 5 Replies View Related

On The Subject Of Data Warehouses, Data Cubes && OLAP&….

Jul 20, 2005

On the subject of Data Warehouses, Data Cubes & OLAP….I would like to speak frankly about Data Warehouses, Data Cubes andOLAP (on-line analytical processing). Has it dawned on anyone elsethat these buzz words were created by some geek who decided to take astab at marketing? Knowing that to the backwoods manager who knowslittle of technology that new innovative names for old concepts wouldhelp to sale their products.I mean seriously, what is the story here? In a nut shell, and pleasestop me if you disagree, but isn’t a data warehouse simply adatabase? Can’t you do everything on a conventional databaselike SQL Server, Oracle or DB2 that you can do on these newproprietary Data Warehouse constructs? I mean who are they trying tofool?Take a look, for instance, at Data Cubes. Who hasn’t noticedthe striking similarity between data cubes and views used in all themore robust databases? Also, what about OLAP? OLAP is nothing morethan a report generator. There’s nothing you can do with thesemillion dollar price tagged Data Warehouse total solution packagesthat I can’t do with SQL Server, Oracle or DB2…for thatmatter Microsoft Access.As an example some sales people for Metadata Corporation has the VicePresident of I.T. in Nashville, for Healthspring, sold on their totalsolution data respository which is such a scam. All they had to dowas throw a couple of buzzwords at him and they have him hypnotized.Personally, I feel that these kinds of marketing practices undermineour industry. It helps to unravel what little standards orconsistency we have. What do you guys think?Stuart

View 7 Replies View Related

Transfer Data(Cubes+virtual Cubes) From Sql2000 To Sql 2005

Jun 6, 2006

Süleyman writes "I want to transfer databases with cubes and virtual cubes from SQL 2000 Analysis Server to SQL 2005 SQL Express.

1.how i can transfer the cubes?

2.how i can transfer the virtual cubes?

3.Why i see the tables(saw)and the cubes in SQL Managment only under Tables together and nothing under cubes?

Please help me
many thanks

Süleyman from Germany/Frankfurt am Main"

View 1 Replies View Related

OLAP Services: Automating Archival/Restore Of OLAP Databases

Sep 19, 2000

Hello All,

Our OLAP environment involves an ETL/Data Warehouse/Data Mart server and a cube publisher server.
We would like to learn how to automate the Archival/Restore of OLAP databases. We are currently doing
it manually though OLAP Manager. Any help would be appreciated. Thanks. James.

--
James E. Bothamley
Senior Database Administrator
Dave & Buster's, Inc.
2481 Manana
Dallas, TX 75220

Work
Phone (214) 904-2296
email jbothaml@DaveAndBusters.Com

"Once in a while you can get shown the light
in the strangest of places if you look at it right"

JG 1942-1995 RIP

View 1 Replies View Related

How To Repair A Corrupted OLAP Database? (was Olap!:)

Jun 12, 2007

How to repair a corrupted OLAP database?

View 2 Replies View Related

Cubes

Aug 10, 2005

I have virtual PC loaded on my machine .Everytime i try to view data in the Data Pane in Analysis Manager,it comes up with an error "Unable to browse the data(Unspecified error).I have tried restarting the DHCP services but has not no effect .
Could someone please advice me.

Have 2 virtual PC's running on is the Domain Controller named as London and the other one is Brisbane which is a memebr of the domain controller.
Niether the London and Brisabn are able to dispaly the data in the data pane in Analysis Manager.
Please Advice.

View 1 Replies View Related

Cubes

Jan 25, 2008

What permission do i need to deploy a cube?



http://www.sqlserverstudy.com

View 4 Replies View Related

Can't Browse Cubes

Jan 22, 2003

I use the SQL Analysis Manager to create a cube and it can process successful, but when i want to browse the cube, it shows the error message: " Unable to browse the cube "my cube name", Unspecified error"

can anybody tell me what's wrong with that? thanks

View 2 Replies View Related

Cubes Question

Mar 12, 2003

Hi all,

I have created a cube in sql server
analysis manager and now i want to
give that to end user...like .exe program
what are all the possible ways we can give that to the end user.....

how to do that...

thanks

View 2 Replies View Related

Is It Possible To Get A Usage Log Of My Cubes

Dec 5, 2004

Hi,

I have managed to setup some cubes on the server, have roles defined, and users are using

these and the results are mathcing...

Is there a way that I can get some sort of user based usage log of the cubes andget details

of when and what type of data did any user see/make use of?

I'll appreciate any help in this regard.

View 2 Replies View Related

How To Browse Cubes On Web

Mar 22, 2007

how to do I use these cubes on web for browsers as I do in business intelligent IDE in visual studio. Are there any free component available for web throught which cubes dtaa can be browsed or are there any methods available in SQL server to publish cubes to web

Any help in this regard will greately appriciated.
Thanks

View 2 Replies View Related

About Cubes In Analysis Manager

Feb 13, 2003

Hi all,

I am working on datawarehouse
using sql server analysis manager.
I created a cube ..that is working fine
but now i have to distribute to end users
so how to do it and how many ways we can do that

1)can we make that .cub file
2)how can give access to endusers
without giving access to database
3)how to host a cube and access from
excel or any other software

Thanks
J

View 6 Replies View Related

Acessing Cubes Through The Internet

Feb 26, 2003

I have a Analysis Servises installed in a Windows 2000 server and I created
a cube on it. I created also an ASP page with Web Pivot Control to access
the cube, but when the users open my ASP page they can´t access the cube. Their machines
doen´t have Excell 2000 installed.

Is it necessary to heve the Pivot table Service installed in the user machine? Or I only have toinstall the Office Web Components ? Or both?
If
it´s true how can I install Pivot Table Service in the user machine? Is
there a specific setup program to install it or is the same setup program
used to install Analysis Services? How should I do this? Should I have a
link in the ASP page to run the setup program? Should I do a download?

Thanks,

Paulo Ortega

View 2 Replies View Related

Processing Of Cubes In A Scheduled DTS

Mar 12, 2004

Hi everyone!

I created a DTS which does some data transformations before processing some cubes. It finished processing in abt 10mins when I run this DTS manually. However, when I schedule this DTS to run, it took around 3 over hours to run. Does anybody know where the problem lies? I have been looking for a solution for this for a long time and I'm hoping that somebody can help me...

Thank you!! :)

Michelle

View 2 Replies View Related

Indexes Within SSAS Cubes

Sep 11, 2007

New to SSAS so, have some not so intelligent ???

We have created Dimensional Model within SQL 2005 and created SSIS packages to load. We have Pk's on Dimensions and FK's on one Fact table. We are thinking about adding clustered index to Fact that consists of the FK's and order by the Hierarchy within the Fact by Dimension. IS THIS A GOOD IDEA IF WE DRILL DOWN AND DRILL THROUGH = QUESTION #1

We build a CUBE from the dimenionsal model and we do not know how to build indexes on the cube. SO DOES SSAS AUTOMATICALLY BUILD INDEXES IT THINKS IT NEEDS ON THE CUBE AND DO YOU KNOW WHAT THEY ARE?? ALSO IF WE HAVE INDEXES ON DIMENSIONAL MODEL DO THOSE GET USED BY SSAS CUBE THAT WE CREATED WITH AUTO BUILD??? = QUESTION #2..

THank you

View 5 Replies View Related

Count The Number Of Cubes

Jul 23, 2005

Hi all,Do you know how can I count the number of cubes and number of databasesin SQL Analysis Services using T-SQL?Thanks.

View 2 Replies View Related

Using Cubes With Translations From SSRS

Sep 27, 2007


Hello Everyone,

I have defined a cube with translations on every dimension and measure group.

when I query this cube from BIDS, the captions of each column have text in the right language (whatever is chosen in BIDS at the time of query)

Now, my customers will be sending queries from SSRS. when i fire the MDX query from SSRS I want to extract the MEMBER_CAPTION dimension property (I think this will contain the translated text for each columns header)

My question is how can I extract this from SSRS?

regards,
Abhishek.

View 10 Replies View Related

Mining Cubes Vs Relational

Nov 21, 2006

I've not found much guidance so far about the pros and cons of mining OLAP cubes vs their underlying fact and dimension tables. Can anyone offer advice in this area, or point me to more info about this?

Thanks,
Kevin

View 1 Replies View Related

One Report Based On Two Cubes

Dec 22, 2006

Hi,

Is there any possibility to build one report based on two cubes? please come up with different solutions for this issue.

View 1 Replies View Related

Data Cubes Using MS Analysis Services

Jan 6, 2006

I need to use cubes in VS 2005 web project. I have no clue how to create cubes or use them in my web page. I am familiar with Reporting Services but not cubes.
thanks in advance!
 

View 4 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved