Author Archives: jeeveshfuloria

About jeeveshfuloria

i am working in iSpace global solution pvt. ltd. in MSBI field and pursuing b.tech through AMIE.

Access Google Analytics API 3.0 using Oauth2.0 in SSIS

Access Google Analytics API 3.0 using Oauth2.0 in SSIS Steps to using a service account to access the API, as example Generate a service account key in your Google API Console: Go to the Google API Console. Click on the “API … Continue reading

Rate this:

Posted in SSIS | 13 Comments

How to count every 15 Mins duration group by employees(http://forums.asp.net/t/1808316.aspx/1?How+to+count+every+15+Mins+duration+group+by+employees)

I have seen such type of scenario. so i am providing the easiest way to handle it. Table format:- EmpID Name TransactionDate 101 Abdul 2012-05-2012 08:40:30 0000 101 Abdul 2012-05-2012 09:40:30 0000 101 Abdul 2012-05-2012 12:20:30 0000 102 Raju 2012-05-2012 … Continue reading

Rate this:

Posted in SQL SERVER | Leave a comment

Create reports from xml data source and xml source from Sql Server table.

Create reports from xml data source and xml source from Sql Server table. Summary: This is  an example of creating reports from XML data source in SSRS. Business Scenario:  In some situation we have to create reports in SSRS but … Continue reading

Rate this:

Posted in SSRS | Leave a comment

Split a flat(text) file into multiple flat(text) files using ssis

Split a flat(text) file into multiple flat(text) files using ssis Summary: This is in an example of splitting a flat file into multiple files based on business scenario. Business Scenario:  In our situation we want to splitting a flat file … Continue reading

Rate this:

Posted in SSIS | 3 Comments

How to solve SSAS cube browser error and doing some drag and drop.

How to solve SSAS cube browser error and doing some drag and drop. Summary: This is in an example of correcting the error in a Cube in SSAS. Problem: In our situation there was a problem when we browser a … Continue reading

Rate this:

Posted in SSAS | 1 Comment

How to Process and deploy a SSAS Cube.

How to Process and deploy a SSAS Cube. Summary: This is in an example of deploying and processing a Cube in SSAS. Problem: In our situation there was a problem when we deploying and processing a cube it show some … Continue reading

Rate this:

Posted in SSAS | 3 Comments

Get data into report from more than one dataset.

Get data into report from more than one dataset. Summary: This is in an example of using reporting services for creating a report by using two dataset. Remember this for doing this we should have at least one match column … Continue reading

Rate this:

Posted in SSRS | 4 Comments