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

Analysis :: How To Extract Data From SSAS Cubes Into A Table

Jun 19, 2015

I need to extract data from SSAS' cubes into a SQL Server table.

I already read examples using Linked server (with openquery), SSIS, etc. However, the result always return as many columns per dimension as levels. I need to extract all members of a dimension in a column. E.g., when excecuting the following MDX query in Adventure Works 2014:

select [Measures].[Sales Amount] on columns,
Non Empty [Date].[Calendar].members on rows
from [Adventure Works]

I would like to get this result (MDX query in SSMS), but with keys displayed intead of names:

But I get this (MDX thru openquery or SSIS):

View 4 Replies View Related

Reporting Services : Report Using Two Datasets From Two SSAS Cubes

Mar 5, 2008

Hi,

I would like to build an SSRS report from two different cubes (SSAS 2005). These cubes are contained in two different SSAS databases.

To do this, i created a dataset for each cube throught MDX expressions.
These datasets use common parameters defined in my report.
Thus, i try to integrate in my report chart datas from the two datasets, but my chart only target one dataset.

Is it possible to create a kind of dataset view to join my two datasets ?
Or is it possible to join the cubes from two different SSAS databases in an MDX expression to put all my datas in a single dataset ?

thx for your help.

Zohir

View 3 Replies View Related

Analysis :: Creating Cubes In SSAS Using Various Tables In Excel

Jun 29, 2015

I'm exploring creating local cube files, .cub from an excel sheet with tables.Would SSAS be able to create one cube from taking data from a 1 way table (A, B, C), a 2 way table (AxB, BxC, AxC) and a 3 way table (AxBxC)?

View 4 Replies View Related

Perspectives In Report Models Generated For SSAS Cubes Not Working

Apr 16, 2007

I never got an answer on this so I am reposting this issue. Also, please note that I have consistently reproduced this issue on multiple perspectives within and accross multiple cubes on 3 different SQL Server Instances. I have also had no problem with perspectives within Report Models that were not generated from an SSAS Cube.

Specifics:

=========

I have created a simple cube in BI Studio against an Oracle Relational Data Warehouse. In this cube I have created a perspective in which I have selected (included) only a small subset of measures and dimension. When I view this perspective on the Browse Tab of BI Studio, only the entities that were included in the perspective were available for report construction as was expected.

Next, I generated a model for this cube in Report Manager. Now here is the problem, I then opended the model in Report Builder and selected the same perspective from above, but all of the Entities in the cube were displayed including the fields I explicitely did not include in the perspective. I then looked at the .smdl file describing the Model and it looked like in the Perspective description section all of the cube's entities were included, even the ones that should not have been included. It seems as if the problem is ocurring durring the model generation. I also tried generating the model in Management Studio and it seems to be doing the same thing.

Any ideas on how to fix this? Could I be doing something wrong(probably)? I have to give a presentation soon and this is a big deal for the Project Stakeholders.

By the way, I am using the 180 Day Evaluation of Sql Server 2005 with SP2 CTP installed.

View 1 Replies View Related

Analysis :: How To Use Stored Procedure In SSAS To Combine Result From More Than Two Cubes

Jul 15, 2015

I have two cube and i would like to get data from both cube and combine the results from both cubes to get final result to display result in SSRS reports like we can do in Stored procedure using temporary tables/Joins.Is there any way in SSAS to combine the data from multiple cubes? Data needs to be retrieved from the cubes based on the user inputs.

View 3 Replies View Related

Analysis :: Tracking Information About No Of Connections Made To SSAS Cubes Through Excel Files

Sep 29, 2015

Is there any way to track the information about the connections to SSAS cubes through local Excel files (BI usage).

OPreviously, we are tracing the information about the BI usage through the BI SharePoint site. Now we want track the users who are using through local excel files .

View 9 Replies View Related

Analysis :: Can Applications Connect To SSAS Tabular Mode Cubes Through ODBC Drivers?

Aug 26, 2015

Can applications connect to SSAS Tabular mode cubes through ODBC drivers? I have been asked the question specifically regarding SAS, and I can see (for example) SAS Enterprise Guide has the ability to connect to sources via ODBC, so I now need to find out if there are such things as ODBC divers for SSAS (specifically Tabular).

View 3 Replies View Related

Using SSIS For ETL From Oracle 10g ODS Into Oracle DW And From There Into SSAS Cubes

May 2, 2007

Hi,

This might seems a little 'out there', but has anyone tried doing ETL from an Oracle 10g ODS into an Oracle 10g DW, and from there into SSAS2005 cubes?

Any caveats houghtscomments on doing this?

Thanks,

JGP

View 1 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

Removal Of Selected Indexes / Script Index Create For List Of Indexes

Jul 1, 2014

I'm working to improve performance on a database I've inherited, and there are several thousand indexes. I've got a list of ones which should definitely exist within the database, and I'm looking to strip out all the others and start fresh, though this list is still quite large (1000 or so).

Is there a way I can remove all the indexes that are not in my list without too much trouble? I.e. without having to manually go through them all individually. The list is currently in a csv file.

I'm looking to either automate the removal of indexes not in the list, or possibly to generate the Create statements for the indexes on the list and simply remove all indexes and then run these statements.

As an aside, when trying to list all indexes in the database, I've found various scripts to do this, but found they all seem to produce differing results. What is the best script to list all indexes?

View 5 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

A Question About Clustered Indexes Forcing Rebuild Of Non-clustered Indexes.

Sep 18, 2007

So I'm reading http://www.sql-server-performance.com/tips/clustered_indexes_p2.aspx and I come across this:
When selecting a column to base your clustered index on, try to avoid columns that are frequently updated. Every time that a column used for a clustered index is modified, all of the non-clustered indexes must also be updated, creating additional overhead. [6.5, 7.0, 2000, 2005] Updated 3-5-2004
Does this mean if I have say a table called Item with a clustered index on a column in it called itemaddeddate, and several non-clustered indexes associated with that table, that if a record gets modified and it's itemaddeddate value changes, that ALL my indexes on that table will get rebuilt? Or is it referring to the table structure changing?
If so does this "pseudocode" example also cause this to occur:
sqlstring="select * from item where itemid=12345"
rs.open sqlstring, etc, etc, etc
rs.Fields("ItemName")="My New Item Name"
rs.Fields("ItemPrice")=1.00
rs.Update
Note I didn't explicitly change the value of rs.fields("ItemAddedDate")...does rs.Fields("ItemAddedDate")=rs.Fields("ItemAddedDate") occur implicitly, which would force the rebuild of all the non-clustered indexes?

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

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

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

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

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

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

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

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

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

SQL Server 2008 :: Logic To Rebuild Only Clustered Indexes / Skipping To Rebuild Non Clustered Indexes In Same Table

Jun 25, 2015

I have a requirement to only rebuild the Clustered Indexes in the table ignoring the non clustered indexes as those are taken care of by the Clustered indexes.

In order to do that, I have taken the records based on the fragmentation %.

But unable to come up with a logic to only consider rebuilding the clustered indexes in the table.

create table #fragmentation
(
FragIndexId BigInt Identity(1,1),
--IDENTITY(int, 1, 1) AS FragIndexId,
DBNAME nvarchar(4000),
TableName nvarchar(4000),

[Code] ....