Saturday, October 06, 2012

Why using Python?

First time when I faced with Python (2 years ago) it was vague!
But as you may know the vague things is some how could help
us doing the things in a new ways. Python came to me in such.
You may use Python for the following reasons :
1. Fast scripting OOP using interactive console along with simple CLI (in compared to PHP, Perl, Java).
2. Fast tools development, using both GUI and command-line.
3. The most useful Dictionary objects, twisted along with List to List feature which I have seen ever.
4. The most simpler but rich functionality of working with file system, which I've tried ever.
5. Tones of methods, I called in all-in-one, which lets you create a complex routine in only a few lines.
    for example to set through the dictionary's value to access records directly :
                >>> for record in db.values(): print(record['LastName'])
6. In favor of Pickle module you now can translate an in-memory object into a serialize byte stream that can   be written to any file object.
7. In favor of Shelve interface, you can now using store your in-memory dictionaries objects for permanent keeping of them.
8. Big approach: Using a network socket, you can now ship pickled objects across a network and provides your own SOAP or XML based RPC services.
9. Execute the OS (Linux/Unix, MacOS, Windows) processes.
10. Porting to any platform, developing Google cloud's applications, ... .

These are not only 10 tips of Python , but by searching the Keywords inside you can learn Python more quickly now :)
 

Monday, October 01, 2012

Drill-down vs Drill-through

In BI technology, there are simple words that have different meaning but are closer in concept and usage. Here I want to explain briefly two of them which are vital for every BI developers:


Drill-down:
This is when you create a data column in a report that is enable for drill to somewhere on that report so this expands the next level of details on the same report. Most of the times the grouped  fields.

Drill-through:
This is when you create a data column in a report that is enabled for drill to another report which would suppose shows a lower level of details resides on the somewhere, outside.

More information for AX developers:
Microsoft Dynamics AX, integrated with SSRS, means that it is using the drill-through actions to open a detailed info from Enterpriseportal or open a AX form inside a report using URL action method.
In a favor of DrillThroughCommonHelper, now you can generate a required url string for SSRS URL action in order to open a form or EP directly from report.