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
dears,advance thanks.can anybdy help to solve my problem which is describing below.Example- %%D1,100,0,0004[data...][0d0a]Head - %%D1Amount of data package -100The data package No. - 0Data Length -1024 (0004 (low bit in front, high bit in back) 0004= 0x0400=1024;)data- Original Picture data -1024(maximum)Tail -0x0d0aData in hexfrom
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.
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."
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!
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?
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:
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
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
[Measures].[Previous Year Sales Value]
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
As you might already know the SSRS interface i