.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Gaurav Pal
Post New Web Links

how to extract data from cube to data mart

Posted By:      Posted Date: April 14, 2011    Points: 0   Category :


I have small cube with some data but underlying database, I was wondering if there is a way i can generate the database and populate it based on the cube.



View Complete Post

More Related Resource Links

extract picture data from a string


dears,advance thanks.can anybdy help to solve my problem which is describing below.

Example- %%D1,100,0,0004[data...][0d0a]

Head - %%D1
Amount of data package -100
The data package No. - 0
Data Length -1024 (0004 (low bit in front, high bit in back) 0004= 0x0400=1024;)

data- Original Picture data -1024(maximum)
Tail -0x0d0a
Data in hex

from the above example i want to extract picture data and need to store in to the sql table.sql table columname is image and datatype is also image.after that i wanted to display this image column to an aspx page.

expecting help asap.

Retrieve cube data directly from Relational database - is this possible?

I have a cube created in SSAS R2 2008. Now i would like to retrieve some data from this cube, using MDX language, and then to process it in Relational SQL database! Is this possible? I am new in SSAS, please help!  

IS There is any way out to process only one partition of cube and data of other partition remain ava

HI ALL. Please let me know is there is any way out to process one partition only,while data of other partition remain available in the cube with the help of SSIS

Cube Refreshment with Data updated in Table

HI All, I have cube which is MOLAP,and i have created SSIS package to process the cube,now i want to start the job as soon as data got uploaded into the Relational database. Please guide me in this as i am new to ssas. Regards Shraddha

Browse SSAS Cube Data From Your iPhone

Does the world want an iPhone app that allows you to connect, browse and pivot SSAS cube data?  What features would that app have?  Is there existing apps that are close?  Looking for others thoughts on this concept.  Thanks in advance!

extract data from WSS Database

how to extract data from WSS Database.We have TFS 2008 with WSS 3.0. By querying,programmatically?any help is appriciated?

change data source of cube

how to change data source of cube?

How do you extract data from the xml attachment of an incoming email and set it as metadata in a doc

Hi, I currently have a document library that contains InfoPath forms. As a form is loaded into the document library I need the data to be extracted from the infopath file and then set as properties/metadata of the file. The infopath forms will be sent to the SharePoint site as an email attachment. So basically, an email is sent to the SharePoint server with an InfoPath form as an email attachment. The InfoPath form needs to be extracted from the email and uploaded to the document library and at the same time updating the document library metadata with the infopath form data. This has been done using Visual Studio but can this be done using SharePoint Designer 2010 now that we have upgraded our site to SharePoint 2010? Any guidance will be greatly appreciated! Thanks Michael

How to process two month data only from 10 month data and 8 month data still available to the cube.

HI ALL, I have created cube in SSAS 2008 and created 10 partition on one of the measure which contains 30 day data per partition i.e 10 month data which is filtered on the basis of getdate() -30 to getdate() ,only date part included. Now i want to refresh data only for the last two partition i.e getdate()-60 to gedate() and also to sustain rest of the data i. e.-from getdate()_61 onwards. I have tried full process mode but in that case i have lost one day data. Please suggest whether it can be possible with the process data mode.if not kindly suggest the way how to perform the same.     Regards Amit   Regards Amit

Designing my first data cube

Hi all, I'm designing my first data cube and wanted to entertain a discussion on which approach is best.  Designing the schema first, or modelling the data once it's been imported into SAAS?  The job I have, is that I'm in possession of a number of relational databases, which the firm want to see "BI run against", using SSAS and Performance Point 2007.  I've been given no granularity statement, so I'm left wondering, do I come up with a schema first, or do I try and do something with the data? As I've never designed cubes before, please assume amateur level when posting any response.  Any comments are welcome. Many thanks, Stevenhttp://www.final-exodus.net

How to enable caching on SSRS that using SSAS cube to bind data


Hi All 

 How to set Cach refersh option for a SSRS report that using SSAS cube to bind data 

when i tried to store credential in data source getting error as show below 

"Non-Windows user credentials were supplied for a non-http connection to Analysis Services. The Microsoft SQL Server Analysis Services data extension requires Windows Integrated Security unless connecting via http or https."





Get source´s data from Cube


Hi All!

While I´m looking for information, I would like to make this question here.

Imagine a data cube that shows the number of people grouped by the city where they live. So, we have, in example:

|Dimension | Fact    |


| NY           |  1200  |

| Atlanta     |  1000  |


What I would like to do is, if I click on the 1200 cell (NY), I would like to get all the 1200 people that live on New York.

Suppossing I have that info but not in the cube as dimensions, in the data source (relational database). It would be possible?

I´m studying the drillthrough, but I think that drillthrough only can get data from the cube (Maybe I could have hidden dimensions with the information).


Thanks in advance!

copy partition data from 2000 cube to 2005 cube



i am upgrading 2000 olap cube to 2005.  i built an ssas project and deploy to the server.

the 2000 olap cube store it's data in partitions - one for each month.

the face table delete it's data and store data for only the last 13 month so basically most of the data

is store onle in the 2000 cube.

while upgrading the cube and processed it , a lot of information had lost.

i know that i cant restore the fact from the partiotn data but is there a way to copy the partition has is

from olap 2000 to 2005?


Pipeline Data Cube Design Question



The Analysis team wants to analyze sales pipeline data. Our CRM system(Source system) send the Data Warehouse team transaction as the Product moves through the different stages.


To mention a few: Creation, CallMade,LeadEngaged,CreditCheck,PapersReceived,Closed.There are more than 100 tracking statuses like mentioned above.


Sample transactions fact table:


Measures for Additive vs Non-Additive Data. What is cube design best practice?


I'm looking more for SSAS 2008 best practice design advice, rather than for an answer to a specific question (although I have a specifc set of examples).

First issue:  Creating a non-additive measure group and an additive measure group.  We have some fact data in our current cube that is additive, and some fact data that is non-additive; all stored in the same fact table.  We do not currently have measures implemented that reflect this aggregation distinction.  Question:  Is it considered good practice to segregate additive and non-additive fact data into a) different fact tables and/or b) different measure groups?  My thought is that it would be an acceptable design approach, but am looking for feedback.

Second issue:  Non-additive fact data is only available at a non-leaf grain.  The example here is that we have non-additive fact data which is only available for the 4th or 5th levels of our 6-level geography dimension.  Our solution has been to create a custom geography branch, which now essentially serves as our 'aggregation treatment' for non-additive fact data.  I don't believe it's a good practice to have the geography dimension serve this function because we end up having to create a custom geo member for each non-additive fact data element.  Question:  What is considered best practice

Issue in the Format of the Data while retrieving from Cube



I have an MDX which returns me certain columns like "Sales Value", "Sales Units" etc. Now I need to find the average price which will be Sales Value/ Sales Units. But when I write this in MDX then sometimes I either get empty space or any gibberish value. I want to know what format type I need to select to fetch the actual value. My value would come something like, 0.00231.

The MDX that I have written is,




[Measures].[Current Year Sales Value] as ' ( [Measures].[SalesValue], [PERIOD].[All PERIOD].[MAT1]) '



[Measures].[Previous Year Sales Value]

SSRS 2008 Interface with cube data source


Hi All,

Need some brainstorming and your experience here. Here is a situation and would like to understand your thoughts on this.

1. We have developed some cubes using SSAS 2008 to analyse the data.

2. We had some reporting requirement in the past and we decided to use our cube as a data source for the reports and develop using SSRS 2008.

3. We have developed many reports using the SSRS.

4. Now when the reports are passed on to the end users, they are not liking the SSRS interface...like at present we cannot increase the size of the drop down box, sorting any many other things..

As you might already know the SSRS interface i

ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend