.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 process two month data only from 10 month data and 8 month data still available to the cube.

Posted By:      Posted Date: September 13, 2010    Points: 0   Category :Sql Server
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

View Complete Post

More Related Resource Links

Strange Calendar issue - Missing Data, only on last day of month


Hi. I'm using Sharepoint 2007 and we're experiencing a strange issue. In the Month view, if I look at the month of September, September 30th appears to have 15 items.  Clicking on the date displays these 15 items, but there should be considerably more. The entire day's schedule stops at 6:30 am. If I view the month of October, and look at the September 30th date, it indicates that there are 36 items, which is the correct number.  This pattern happens regardless of which month I'm looking at. It's always the last day of the month affected. The number of missing items varies from month to month, generally around 20 items. I'm baffled, and haven't got a clue how to attempt to troubleshoot this issue.

I would greatly appreciate any suggestions on how to attempt to resolve this!

MDX to pick the data from first day of the current month



I need to make a mdx query to pick the data from first day of the current month.

SELECT [Measures].[Internet Sales Amount] ON COLUMNS,

[Date].[Fiscal].[Date].MEMBERS ON ROWS

FROM [Adventure Works]


The above query returns around 4 years of data, but I need the data from first day of the current month.


Could anybody help me out!!!






Need Help - Grouping multiple fields to get top 10 for month then using that data to get previous mo



I’m querying a database in BIDS using SQL 2005 to produce a report in SSRS. All the information I need is in one table.

The table has 3 columns. The data within each column can be identical but when the 3 columns are grouped together they make up a unique set.

For example:
Month     Col 1     Col2       Col3
201009   Field A   Field B   Field C
201009   Field A   Field B   Field D

201009   Field A   Field B   Field D

201009   Field A   Field E   Field C
201009   Field B   Field B   Field F

201009   Field B   Field B   Field F
201009   Field B   Field G   Field G
201009   Field C   Field B   Field F

I need to count the number of times these unique sets appear each month and produce a report showing the to

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

Data Deployment: Streamline Your Database Setup Process with a Custom Installer


Database setup can be a tough and time-consuming process and sometimes fall victim to human error. Microsoft Installer or InstallShield can help, as can your own custom installer. In this article, the author tackles one approach to writing database installers and demonstrates the process with a working code sample.

Alek Davis

MSDN Magazine September 2004

How to process data AFTER page is completely loaded for the user?


I have some logging that has to be done, which are some database update or inserts.

However this logging is of no importance to the user, so I only want to process the data/logs after the page is completed for the user.
As of now, if I process the data while the page is loading, I go from 1.4 to 2.0 speed (server side time processing of code), which is quite a bit comparing it is of no use to the user.

So I want this code only executed after that the page is complete.

I've been checking out Ajax, async pages etc, but the problem is it still gets executed before the page is rendered to the client, which means the client will have to wait longer then it is not being processed.

I've been checking out Threadpool.queueBackgroundWorker, however if I get it correct, this will still be executed before the page is shown to the user, as it has to complete before the prerender.

Then I thought about creating a new thread, and do the processing there, which would not have my page waiting to complete the data/logging.
However when I have 100 or 200 users loading pages at the same time, then that would mean I would be creating 200 threads on those loads, which I doubt will be good for performance. So if I want to solve this, I would have to create my own threadpool and only assign for example a max of 40 threads to it which can pr

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!  

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

Process Data VS Incremental Process

HI All. what is the difference between Process Data VS Incremental Process.   Regards Amit

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!

change data source of cube

how to change data source of cube?

process Data VS Process Full

HI ALL, I have a cube now i want to process the whole cube in SSAS 2008, tell me is there is any difference in data if i processed the cube in Process Full mode or Process Data mode,if schema is still the same.   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

MOSS 2007 : Data store missing in the middle of process

Dear Expert, My user always report that some data that have been key-in by them (sharepoint web form) was missing during the WF is routing to (verifier & approval). FYI the verifier & approval only have a permission as a "View" anybody here have a same experience with me?? Isit the issue is because of sharepoint itself or human (i've try to create dummy record but work fine) ??

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!

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