Skip to content
April 1, 2023
  • Subscribe
  • Twitter
  • LinkedIN Group (Forum)
  • Facebook Group (Forum)
  • Facebook Page
  • YouTube
  • Telegram Group (Forum)
SQLServerGeeks

SQLServerGeeks

SQL Server Education (by the geeks, for the geeks)

Free Live Event Free Live Training Virtual Symposium DPD banglore
  • Free Courses
  • Blogs
    • Subscribe To Our Newsletter
    • SQLServerGeeks Bulletin Index
    • The Scripts Garage
    • All Blog Posts
    • One DMV a Day Series
    • Accidental DBA Series
    • One Operator a Day Series
    • One Trace Flag a Day Series
  • Magazine
  • Events
    • Browse Events
    • Suggest Topics
  • Videos
    • SSG Videos Lobby
    • SQL Server Tutorials & Demos
    • Webinar Recordings
    • SQLShighra Recordings
    • Virtual Symposium Recordings
      • SQL Server & Azure SQL – May 2021
      • SQL Server 2019 & Azure SQL – May 2020
    • Geek Talks
  • RESOURCES
    • SQL Server Resources
    • SQL Server Notes by Amit Bansal (AB)
  • About Us
    • Subscribe To Our Newsletter
    • Social Channels
    • SSG Team
    • Join Us
    • Speakers
    • Blog With Us
    • Contact Us
    • Write a Guest Post
    • Testimonials
    • Join DataPlatformGeeks community
  • Log In
  • Join Now
Main Menu

Author: Amit Karkhanis

SQL Server

SQL Server Analysis Services – Understanding and configuring Processing Settings

April 29, 2013September 12, 2014 - by Amit Karkhanis - 2 Comments.

Processing is an operation to keep an Analysis Services database (ASDB) up-to-date with the current data from an OLTP system or a data warehouse based on how an ASDB is designed. …

SQL Server Analysis Services – Understanding and configuring Processing Settings Read More
SQL Server

SQL Server Analysis Services – Different types of Hierarchies

March 26, 2013September 12, 2014 - by Amit Karkhanis - 4 Comments.

A dimension consists of various attribute members. Attributes are exposed to end users through attribute hierarchies. A hierarchy defines the relative position of attribute members in a dimension. By default, in …

SQL Server Analysis Services – Different types of Hierarchies Read More
SQL Server

SQL Server: SSRS – Moving Reports from Old to a New Environment

December 23, 2011August 28, 2014 - by Amit Karkhanis - 10 Comments.

Question – How to migrate all the reports and data sources deployed on the old server to the new server? Scenario – Our Company is going for the new server setup by …

SQL Server: SSRS – Moving Reports from Old to a New Environment Read More
SQL Server

SQL Server Analysis Services Time Dimension Considerations – Part 2

December 6, 2011November 28, 2014 - by Amit Karkhanis - Leave a Comment

Hi Friends, This is a second part in the series “SQL Server Analysis Services Time Dimension Consideration”. In the Part 1, we have briefly discussed on the two types of the …

SQL Server Analysis Services Time Dimension Considerations – Part 2 Read More
SQL Server

SQL Server Analysis Services Time Dimension Consideration – Part1

December 5, 2011September 24, 2014 - by Amit Karkhanis - Leave a Comment

In SQL Server Analysis Services Time Dimension has its own importance in the overall data analysis. As we can see that the majority of the BI solution aggregate data over the time …

SQL Server Analysis Services Time Dimension Consideration – Part1 Read More
SQL Server

SQL Server: SSAS – Important Attribute Properties Part 2

November 10, 2011November 28, 2014 - by Amit Karkhanis - 3 Comments.

In the Part 1 we have checked the attribute properties that control the display and visibility of an attribute, properties related to the attribute column bindings and few other ones. In …

SQL Server: SSAS – Important Attribute Properties Part 2 Read More
SQL Server

SQL Server: SSAS – Important Attribute Properties Part1

November 8, 2011August 28, 2014 - by Amit Karkhanis - 1 Comment

While working with the dimension designer, it is important to understand some of the useful attribute properties that determine how dimensions and dimension attributes function. To view the properties, just select …

SQL Server: SSAS – Important Attribute Properties Part1 Read More
SQL Server

SQL Server: Topsum and Bottomsum in MDX

September 26, 2011November 27, 2014 - by Amit Karkhanis - Leave a Comment

This is the last one in the series“Top to Bottom in MDX”. In the first part we have seen Topcount and Bottomcount functions and in the second part, Toppercent and Bottompercent …

SQL Server: Topsum and Bottomsum in MDX Read More
SQL Server

SQL Server MDX – Resellers by laps time

September 16, 2011November 27, 2014 - by Amit Karkhanis - 1 Comment

The inspiration behind this blog entry is the comment received by Andrew on my blog post “Top to Bottom in MDX”. In that blog, I have explainded the use of Topcount …

SQL Server MDX – Resellers by laps time Read More
SQL Server

SQL Server: Toppercent and Bottompercent in MDX

September 12, 2011November 27, 2014 - by Amit Karkhanis - Leave a Comment

In my previous blog post “Top to Bottom in MDX” we have shown Topcount and Bottomcount functions. (I suggest you to first go throgh this post to get more clear idea …

SQL Server: Toppercent and Bottompercent in MDX Read More

Posts navigation

1 2 3 Next

Subscribe to SQLServerGeeks


Ad

Virtual Symposium

master classes



SSG_linkedin

SSG_fb

About Us

  • Core Team
  • Authors
  • Blog With Us
  • Testimonials
  • Contact Us
  • Join DataPlatformGeeks Community

Virtual Symposium

Copyright © 2022 SQLServerGeeks. Community initiative by Amit Bansal | Anti-Harassment Policy
Powered by WordPress and HitMag.