Cubes
Jan 25, 2008What permission do i need to deploy a cube?
http://www.sqlserverstudy.com
ADVERTISEMENT
Transfer Data(Cubes+virtual Cubes) From Sql2000 To Sql 2005
Jun 6, 2006Sü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"
Cubes
Aug 10, 2005I 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.
Can't Browse Cubes
Jan 22, 2003I 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
Cubes Question
Mar 12, 2003Hi 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
Is It Possible To Get A Usage Log Of My Cubes
Dec 5, 2004Hi,
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.
HELP OLAP Cubes
Mar 3, 2004When 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
How To Browse Cubes On Web
Mar 22, 2007how 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
Distributing OLAP Cubes
Aug 18, 2000I'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
Scripting OLAP Cubes
Mar 16, 2000Is 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 RelatedAbout Cubes In Analysis Manager
Feb 13, 2003Hi 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
Acessing Cubes Through The Internet
Feb 26, 2003I 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
Processing Of Cubes In A Scheduled DTS
Mar 12, 2004Hi 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
Indexes Within SSAS Cubes
Sep 11, 2007New 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
Count The Number Of Cubes
Jul 23, 2005Hi 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 RelatedOLAP Cubes And Programming
Jul 20, 2005I 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 RelatedUsing 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.
Mining On Olap Cubes
Dec 26, 2007While 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 RelatedMining Cubes Vs Relational
Nov 21, 2006I'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
One Report Based On Two Cubes
Dec 22, 2006Hi,
Is there any possibility to build one report based on two cubes? please come up with different solutions for this issue.
Reports With OLAP Cubes
Apr 19, 2006Hi
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??
Data Cubes Using MS Analysis Services
Jan 6, 2006I 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!
User Rights In OLAP Cubes
Jul 12, 2000How 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?
OLAP 2000 - Cubes - Filters
Sep 14, 2000Does 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.
Automatically Refreshing OLAP Cubes...
Dec 14, 2000Can 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 RelatedMoving OLAP Cubes / Databases
Oct 9, 1999How can I move OLAP Databases / specific cubes or virtual cubes from our Development Server to the UAT or LIVE servers ?
Thanks,
Lee
SQL Server And Analysis Services (Cubes)
Aug 7, 2002Hi, i want to back up my SQL Server database and the cubes i've made on the anaysis services
i have backed up the SQL server database wihtthe wizard, and i do not know how to back up the cubes..
Is it possible, and if so, HOW??
thanx
reply @
nouman@emirates.net.ae
Analysis Service: How Can I Process Cubes?
Oct 11, 2004how can I process and update cubes automaticly every night ?
Thanks
Process Dimensions And Cubes Overnight
Oct 13, 2004Hi All, any advice or help greatly appreciated, I need to Process Dimensions and Cubes Overnight, what is the best and most reliable way of achieving this.
Many Thanks in anticipation.
Shurl
SQL 2012 :: Error Processing Cubes
Aug 19, 2014I just finished migrating SQL 2005 - 2012 and I am having issues processing my cubes. I included the error message below with generic names, but I think it should be transparent. I seem to be having an issue with one of the logins, but which one. The error message points to "domain_nameserver_name$" with a $ at the end. I am assuming this is a SQL login? I have included the error message below:
<Batch xmlns="http://schemas.microsoft.com/analysisservices/2003/engine">
<Parallel>
<Process xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:ddl2="http://schemas.microsoft.com/analysisservices/2003/engine/2" xmlns:ddl2_2="http://schemas.microsoft.com/analysisservices/2003/engine/2/2"
[code]...
Export Cubes Of SQL Server 2005
Apr 10, 2007Is there any way that cubes built on Analysis Server 2005 can be migrate or copy to Analysis Server 2000. I have built cubes on 2005 and i want the cubes to be also on another server whicih is unfortunately running Analysis Serviuces 2000. Is it poosible ?
thanks for tht time
Adding The Cubes Of A Strring Of Digits
May 9, 2007I need to take a numeric value and add together the cubes of each single digit. The string length may vary from row to row.
As as example the number 1234 has individual cube values of 1 (1 cubed), 8 (2 cubed), 27 (3 cubed) and 64 (4 cubed). The resulting sum of the cubes is then 1+8+27+64 = 100. The same result would occur for 1243.
The purpose is to look for numeric values in a table where the same digits occur in two different rows but in a different order.
How can I create a function to apply to a varchar column to produce my integer result ?
Join Data From Multiple Cubes
Aug 6, 2007I am trying to build a report that access data from multiple cubes. Is it possible to join multiple cubes based on their shared dimensions? Or is it possible for report to display data from multiple cubes properly aligned based on the dimension.
Environment:
SQL Server Analysis Services 2005 and Reporting Services 2005
Example:
We have multiple cubes with “Year� as a shared dimension and each one has different Rate info. The cubes have other set of shared dimensions which I am planning to set it up as a parameter. I would like to display the report as
Year
Rate1
Rate2
Rate3…
I really appreciate any suggestion.
Thanks
Haseeb