Backup and Restore Cube at a time using SSIS Package.

Hello all,

Firstly, what I want to say is that ,I cannot stop myself to write this another blog of mine.

writing a blog and sharing some knowledge through the blog makes us really feels happy and also somewhat we also become addicted to it. 🙂

Also, this may be simply for one but for someone it will be helpful for those who don’t know how to do it.

May be there are a lot of method to perform this task and many solution’s.

While working I have to take a Backup of Cube from one database and Restore it into another database within a same machine.So,for this i usually do manually by right clicking the Backup and Restore it to another database but every time say development cube changes frequently and i have to take backup and then again restore it into production cube.

Doing manually seems little lazy,so i think of doing it dynamically or say by just a click so that.

For this I use a SSIS package where we can use the “Analysis Services Execute DDL Task ” from toolbox and by editing it, we can set/configure the values as:

Also, i forgot to mention that for the restore and backup XMLA script ,we have to right click on the database and click restore/backup and then click the script button so that it will generate the XMLA script for restore and backup to particular database.After generating the XMLA,we can directly put into the “Analysis Services Execute DDL Task” by configuring the “SourceType” :Direct input and SourceDirect : XMLA script (i.e of backup / Restore).

But here i use the file connection for pointing the XMLA script from particular location so that we can execute this for different database by only changing the XMLA file.

This may be simple but i think it may work out for someone .

Thanks,

Anil Maharjan

SQL Server Reporting Services – Displaying some message within a Tablix if there is no data.

Hello all,

This is my first article that I am trying to write .I am encourage to write this article after joining a lot of BI related network and reading a lot of articles/blogs regarding different topic. so, this may be simply for one but for someone it will be helpful for those who don’t know how to do it ..

while working in .rdl design using BIDS , I need to display certain message within a tablix toolbox, if the table doesn’t contain’s any data to display or there is no row count. In normal it will display the data if there is certain to display but if there is not any data to display then we have to display the message as like i.e “Data doesnot match”

For this we need to add a new row within a same table and set the properties of ‘Hidden’ field as =IIF(Count(“DSName”)>0,true,false)

Then within a same row we need to add a ‘Placeholder’ by right clicking within a row and set its properties value expression as

=IIF(count(Fields!Row1.Value,”DSName”)>0,””,”No data qualifies for this section”)

Also in another terms,

Remove no rows property for the table,added another table header row with the expression

=IIF(count(Fields!Row1.Value,”DSName”)>0,””,”No data qualifies for this section”)

and set visibility hidden expression for the added table header row as

=IIF(Count(“DSName”)>0,true,false)

Replace”DSName” with your datasetName.

Hope this will help for someone .. 🙂 !!!..

You can see some snapshot as:

You can see output as if there is no data to display or no row count:

Thanks,

Anil Maharjan