Improved SAQL in Spring'15

The SAQL language is a real-time query language that enables ad hoc analysis of data that’s stored in dataset

SAQL is influenced by the Pig Latin programming language, but their implementations differ and they aren’t compatible.

SAQL is procedural, which means that you describe what you want to get from your query. Then, the query engine decides how to serve it efficiently. SAQLis compositional. Every statement has a result, and you can chain statements together.

Salesforce Analytics Query language (SAQL)
We already know about SOQL and SOSL. This is new Query language for Analytics cloud to enable ad hoc analysis of data stored in dataset. This is still in pilot.

 IDENTIFIERS Identifiers are case-sensitive. They can be unquoted or quoted. Unquoted identifiers can’t be one of the reserved words and must start with a letter (A to Z or a to z) or an underscore. Subsequent characters can be letters, numbers, or underscores. Unquoted identifiers can’t contain spaces. Quoted identifiers are wrapped in single quotes (') and can contain any character that a string can contain. 

Happy Coding!!
Cheers

Duplicate Management Salesforce Spring ’15

Duplicate Management feature released in Spring'15 is one of easy and useful feature that salesforce release in Spring'15, same as like "Process Builder", recently I tried to implement it and this feature is doing almost all the things that we want and was doing using Apex triggers.

I thought to post it as people will get to more about this new features, and will start implementing it rather then using Apex triggers. I have added snapshots as well as it will be more helpful in explaining. for more description go for Spring 15 release note

Now here we go,

1. GO TO : YOUR NAME => Setup => Data.com Administration => Duplicate Management

2. Click on "Matching Rules" click on "New Rule" and Select an Object from the picklist , I have selected Account

3. Provide the name of the rule and select the field on which you want to check the duplicacy and select one of the selected value "Exact" or "Fuzzy"

Exact will match the exact match.
Fuzzy will check for the containing match as well.

Your rule should look something like this, then click on "Activate", you will receive an email on the activation of the rule.

4. Now create a "Duplicate Rule", option is write in below of Matching rule, click "New Rule" and select the object from the select list, I have selected Account object

5. Now add the values in the option showing in below snapshot

You rule should look something like this

6. You are done now, create an Account with name "TEST" and again create an Account with "test", it will show alert on creation on duplicate name

Salesfirce Duplicate Management have many features you can right trigger it have two objects as well "Duplicate Record Sets" and related child object is "Duplicate Record Items" where you can the related duplicate records, you can modify the page layouts as well.

Soon will post Duplicate Management's Trigger using at its best.
Enjoy Salesforce..!!!

Process Builder With Email Alerts (Spring 15)

Just got a chance of working with Process builder, amazing stuff, covering everything that a workflow can do as well more than that, you can create records or you can call your Apex class to perform you custom logic.

It is fast, easy to use and awesome look and feel. I am assuring you once you start using it, you will stop using workflow.

So I am going to start an easy use of Process Builder with Email Alerts

1. First of All go to workflow & Approval section and click on Process Builder

2. Click "New" button in right corner.

3. Write the name of the process and Description

4. Here is the way process builder shows the logic in the way of a flow diagram, too easy to understand.

5. Click on the Add Object down to Start box, there is a picklist of all the objects and click "Save"

6. Select Field of the selected Object from the picklist for the criteria and click "Save"

7. Now you have selected the Object, now click on the Add Criteria to add criteria same as workflow you can use formula as well, I tried that one and that is also easy to create.

8. Now you are done with criteria, it is highlighted, time to add the action, click on action.

9. While adding the action I was amazed to see when there was an Option of Apex Class + Update Record + Insert Record, none of these you can do in workflow that is best property of the Process Builder. I choosed Email Alert, for Email Alert you need to have an Email Alert on the Object that you are using, their is auto complete on the last text box, which will show the related Email Alerts, as in below snapshot

10. Now you are done, isn't that quick and easy, now in the right corner of the screen there is Activate button, click on it, and you will get confirmation like below. Click OK now you have created you first workflow using Process Builder.

11. Click on "View All Process" to see the process.

Few thing need to take care of :

1. You cannot delete a process builder data, if it is Active, you need to Deactivate it and wait to 12 hours to delete it.
2. You cannot modify it again, you need to clone it and re-create ( I don't know why this restriction, I tried to modify but didn't succeeded).

Try it now, May the force.com be with you!!