Great SSAS

I got an wonderful opportunity to explore and do some investigation on Sql Server 2005 Analysis Services (SSAS).

I already explored/worked on Sql Server 2005 Reporting Services (SSRS) for my current project. But this is the first time i put my hands on SSAS. It's quite interestion one.

Hope you guys know that SSRS is the wonderful reporting tool. Very easy to use and develop. Using SSRS we can easily develop drilldown/charts/general reports rapidly. Even we had used SSRS on Java application using JSP. It work wonderfully.

SSAS is altogether a different tool. Using this we can create sophisticated online processing (OLAP) and data mining solutions.

I'll write more about my experience on SSAS in the coming days... All i can say now is .... Great SSAS

Comments

Post a Comment

Popular posts from this blog

D365: Security Permissions for Rich Text Editor

Image
Recently I came across this issue in my organization. We have enabled RTE (MS PCF) control on one of the memo fields in CRM form. For some reason it's not allowing users to insert image inside it (preview not showing and OK not enabled). Even when they copy paste from the local devices and saves, it is not retaining the image they copy pasted.  But all these functionalities works fine for sys admin.  After going through MS docs I came across this... https://docs.microsoft.com/en-us/powerapps/maker/model-driven-apps/rich-text-editor-control based on this info I head over to CRM security roles and found this entity called Rich Text Attachment under Custom Entities tab once I gave create, read, write permissions the users are allowed to insert/copy paste the images inside Dynamics CRM forms. Hope it helps...
Read more

In Prosoft Systems Intl.

Software Team Lead / Lead Software Architect / Lead Developer Due to its size, working at Prosoft Systems Intl. has required me to take on multiple roles depending upon client requirements and in-house product development. I played a Lead Software Architect role when it comes to product developments. I love coding and deeply involve in coding part as well on products and Dynamics CRM customization. At times, I managed an international development team overseeing enterprise level Microsoft Dynamics applications. Other times, I would be used in a training / mentoring role to bring other developers up to speed on coding methodologies. During this time, I would also create course material and generate exercises in the use of class workbooks. The in-house products that I led for Prosoft's are: Coordinat-iR - Coordinat-iR focuses on providing Cybersecurity Incident Responders with the tools they need to complete their job as quickly as possible. This is done through Micros...
Read more

MS Infopath 2007

Currently I'm working on MS Infopath 2007 apart from MS CMR 4.0 and MS SSRS 2005 . Infopath is quite interesting to work on. Main advantage of Infopath is, a single form can be used as both client and web based forms. My current project is a web base .net project. All the forms are developed using Infopath. The web based Infopath has limitations compared to client based forms. The Infopath forms are deployed using MS office forms server . One of the cool features i like with Infopath is the repeating controls. The repeating controls works well in web based forms as well. Below is the code which used to populate the rows dynamically on the repeating controls. string myNamespace = NamespaceManager.LookupNamespace("my"); using (XmlWriter writer = MainDataSource.CreateNavigator().SelectSingleNode("/my:myFields/my:group1", NamespaceManager).AppendChild()) { writer.WriteStartElement("Expense", myNamespace); writer.WriteElementString("Expense_Typ...
Read more