Who’s Babble?

I am a Business Intelligence professional living in Perth, Western Australia. Ive been living and breathing Microsoft B.I. since SQL 2000 and am involved in every aspect of B.I. implementations. Of late i have had the privelege of being appointed as team lead – so i now also manage all aspects of a dynamic and talented group of people.

I also have some experience with other vendors’ products such as SAP/BusinessObjects. I have a strong focus on technology and keep abreast of the newest developments in the B.I. world. Further solidifying my existing experience in enterprise-level B.I., standards, management and methodology is one of my primary motivators. The more i learn about my field i find there is so much more to learn! I guess this is true for most things life 🙂

Over the years ive managed to obtain some invaluable information from a number blogs, some that ive subscribed to and others found through everyones friend – Googe. My occupation of this tiny corner of the Internet is an attempt to share my experiences in the hope that someone may find this useful.

Remember that there is often more than approach to solve a problem.. you just need to consider the applicability and potential trade-offs of various techniques in your specific project. Never under estimate the value of good estimation and risk management!

Advertisements

5 Responses to Who’s Babble?

  1. bhavikmerchant says:

    thanks! think ive fixed them up now…

  2. sanjay shah says:

    Hi Bhavik,

    i also live and breath microsoft bi since the last 8 years, starting with office 97 and sql 2000 and sometimes even msaccess. it is fascinating.

    can i have ur email id to communicate with u.

    btw i have one urgent query on pps 2010. i have designed a dashboard with one page (multiple zones). on this page the filters from the filter zone flow easily to the other zones containing scorecards or reports. however if i add another page, i am not able to share the filters of the first page. is there any way to do this ? can the filter zone of the second page get the filters automatically from the filter zone of the first page ?

    an urgent reply would be highly appreciated.

    sanjay shah

    • bhavikmerchant says:

      Hi Sanjay,

      The functionality you are looking for is automatic in PPS 2010 as long as you use the same filter object across the pages. Even with some filters that are unique to some pages only, this still works. The common filters should stay in synch across pages.

      i think you have not added the filter in the second page.. once you do that and link it to the zones it will behave the way you want and stay synchronised across pages. This way the filter does need to be displayed on any pages where it is used.

  3. hingesagar says:

    Hi Bhavik,

    First i would say Thanks to you for such wonderful blog post.

    I am a BI developer with around 4 years of experience and i am in situation where i need to create power shell script for ssas cube role creation dynamically. I need to read the role and its members, permissions from source cube and create the same on the target cube which is on the same server. I have created the script for the same but its not working only for the adding the permission in the target cube. So need help on that. below is my script.

    param
    ($Servername =”ServerName”,
    $databasename =”Cube_1″,
    $databasename1 = “Cube_2”
    )

    $loadInfo = [Reflection.Assembly]::LoadWithPartialName(“Microsoft.AnalysisServices”)

    $svr = new-Object Microsoft.AnalysisServices.Server

    $svr.Connect($ServerName)

    $db = $svr.Databases.FindByName($databasename)
    $db1 = $svr.Databases.FindByName($databasename1)

    #$rolename =”ReportViewer”

    #Create Role

    #$db1.Roles.Add($roleToCreate)

    Foreach($rolename in $db.Roles)
    {
    $roleToCreate = new-Object([Microsoft.AnalysisServices.Role])($rolename)
    $db1.Roles.Add($roleToCreate)

    foreach ($UserName in $db.Roles.FindByName($rolename).Members)
    {
    #add-rolemember -MemberName $UserName -Server $Servername -Database $db1 -RoleName $rolename
    $roleToCreate.Members.Add($UserName)
    }

    $roleToCreate.Update()

    $dbperm = $db.DatabasePermissions.GetByRole($rolename.ID)

    if ($dbperm.Read -eq $True)
    {
    $dbperm1 = $db1.DatabasePermissions.FindByRole($rolename.ID)
    $dbperm1.Read = [Microsoft.AnalysisServices.ReadAccess]::Allowed
    $dbperm1.Update()
    }

    }

    #add the permissions

    #$dbperm = $db1.DatabasePermissions.Add($roleToCreate.ID)
    #$dbperm.Read = [Microsoft.AnalysisServices.ReadAccess]::Allowed
    #$dbperm.Update()

    # add members to the role

    #cleanup

    $svr.Disconnect()

    Regards,
    Sagar

    • bhavikmerchant says:

      Hi Sagar,

      I havent spent a lot of time on automation with powershell so i would need to test this myself and learn some stuff before being able to give any advice. At this point im not sure when this will happen, so i suggest you try the MSDN forums where you will probably get a faster answer. Best of luck!

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: