Clipping is a handy way to collect and organize the most important slides from a presentation. The reason why the Parliamentary Accounts Committee (PAC) was permitted to publish their damning report on 1MDB was that it blamed Sirul Halmi (forgive the typo). This former CEO must have further got the hint when the entire Board of fellow directors immediately resigned. The plank awaits and it seems that Sirul Halmi has resigned himself to walk it – blindfold and believing that soon he will be rewarded by the grateful boss. Of course, the PAC report doesn’t really exonerate Najib, because he was the ultimate boss and therefore responsible. These articles of association had originally been kept hidden and when the scandal broke the PM played the distant innocent – Chairman solely of the so-called Advisory Board of notables. After all, if anything came out, others could be blamed and he could say he was not directly running the fund.
However, a lot more came out than Najib had reckoned on, including the embarrassing fact that billions of dollars had coincidentally wandered into his own bank accounts at the very time they were disappearing from 1MDB.
In fact, one thing this carefully worded report, written by the majority BN controlled PAC, does is to fully exonerate Sarawak Report and all the other journalists and political figures, who have raised concerns about the billion dollar debts of this so-called development fund. As PAC member Tony Pua has pointed out in his press release and statements, the investigations of the past year have shown that every single allegation made in this blog was true. After all, back last July the Attorney General, The Agong, The Deputy Prime Minister, and several others of Malaysia’s key establishment figures gravely agreed to take the necessary constitutional steps to remove the Prime Minister, owing to these very events at 1MDB. Tipped off, Najib struck back by using illegal and unconstitutional methods to sack the AG and ignore the warrant drawn up for his own arrest – and then sack his leading colleagues and even change the leader of the PAC. But, even if the reserved criticisms of the PAC were correct and that Najib was merely a useless administrator, blind to the documents he was signing, thereby allowing his CEO at 1MDB to sign off billions into the accounts of Jho Low, he was still responsible. The mega-disaster fund, which threatens the Malaysian economy (the PAC report confirms that taxpayers are liable for billions in guarantees, which Najib earlier tried to deny) just  mirrors the shocking situation with the PM’s own personal spending accounts. In exactly the same attempt to deny responsibility, Najib has now admitted millions in SRC public money arrived in these accounts, which he spent. However, in both cases, he was the man responsible, whether through greed or moronic negligence, take your pick… or rather leave the matter for the courts to decide.
What matters is that a stage has been arrived at, where there is no longer room for denial for Najib. With the world shaken by the money laundering scandal exposed by the so-called Panama Papers, it was 1MDB that this senior Swiss enforcer chose as his example of massive crime in this field.
Faced with such a trio of damning developments in the past few days, Najib should of course accept responsibility and go.
These are not events from years ago – the money was still being accepted until quite recently. Najib Razak has just one last chance to win back some respect from Malaysians and world opinion and some sympathy from history, which is to step down now, in order to avoid causing the further suffering of others.
He would be amazed at how much lasting, generous feeling such a move would create towards him  – but he seems too weak a man to make it.
Your views are valuable to us, but Sarawak Report kindly requests that comments be deposited in suitable language and do not support racism or violence or we will be forced to withdraw them from the site. For a non-developer who hasn’t leveraged OData before it might come as a bit of a surprise that not all of the business data is necessarily readily available via the feeds when examining a particular CRM entity. From a reporting perspective, it’s very likely that any chart or table that you wish to build is going to leverage one or more option set fields.
As a bit more efficient workaround we could be adventurous and import a copy of the CRM solution file containing the entity customizations as an XML data source into Power Query and then pick out the necessary mappings from there. After a bit of poking around in the OData feed data source, it turns out the optionset labels are actually included there. To follow the steps you should have the latest Power Query version installed in your Excel client. The problem with CRM and OData is that by default the feed will pull down each and every record in the table. The real beauty of Power Query is in the query steps you can use for manipulating the workbook queries. Open up the new duplicate query you’ve added into the edit mode by double clicking on it, which launches the Power Query query editor (yes, query is the word of the day). You’ll see the Record column transformed into three new columns as a result of drilling down into the data. By now you might have noticed that the Applied Steps box in the Query Settings pane is collecting all of the actions that we’re performing on the query and storing them as steps.


Now that Power BI has hit the GA milestone (general availability), I decided to spin up a trial subscription for it and get familiar with the tools that it offers.
I repeated the steps for connecting my Excel 2013 Power Query to a CRM 2013 organization hosted on CRM Online and started to think about a simple report I could build.
Life would be so much easier if you just read the manual before starting to use new tools, but ain’t nobody got time for that in the fast paced IT consulting world, right? In all the columns that display the record link you can see a small icon with two parting arrows on the right side of the column header.
Once you click OK, the values for the chosen columns to expand will be shown on the query editor grid. After we’ve expanded all the necessary columns, we can then proceed with using this data in our report. There should also be a Part 3 coming up that will talk about how to upload the report onto Office 365 Power BI for publishing it to the end users. When I click around in the Power BI Admin Center, I don’t see any options for adding a new data source that would be an OData feed. With an on-premises Dynamics CRM instance you could of course set up a direct SQL Server data source and publish it to Power BI via the Data Management Gateway component. The latest version of Excel contains a Get External Data menu option for linking the workbook to an OData data feed. Last summer Microsoft announced the preview program for Power BI, their cloud based business intelligence suite, containing tools for publishing reports in Office 365. I'm a Microsoft Dynamics CRM MVP from Finland, having worked with the system since 2005 and in the field of customer relationship management for over 10 years now.
Enter your email address to subscribe to this blog and receive notifications of new posts by email. Are you using ClickDimensions as your Microsoft Dynamics CRM marketing automation solution?
The State of Dynamics in 2015There’s been a lot going on in the world of Microsoft Dynamics during the past few months. The power backup sector can be categorized into four broad segments, UPS, Diesel Generators, Inverters and Batteries.
A number of Swiss banks are involved in both the corruption scandal surrounding Brazil’s Petrobras and the suspicious cash flows linked to the Malaysian sovereign fund 1MDB. We are talking about cash flows amounting to several billion US dollars, with individual transactions running into hundreds of millions.
Late last year Microsoft enabled support for accessing the secured OData feeds from CRM Online via the Excel Power Query tool, which opened up some interesting options for building modern BI solutions on top of the CRM data up in the Microsoft cloud.
Formerly known as picklists, these are basically the dropdown fields on CRM entity forms that allow the user to select one value from a list of predefined values.
We could of course manually create new tables into the Excel workbook that store the mapping of ID values and labels, but that just doesn’t sound like a fun exercise at all.
Due to the power of Power Query, this would actually technically work, and we could even set it to reference a file location from where the latest customizations would dynamically be imported upon workbook refresh. The tricky part is that they’re not simply a [Record] link that you can drill into and expose the values from your existing entity data set.
The query performance is less than stellar with CRM Online and if you have a high number of leads (status doesn’t matter, also the closed ones will get downloaded), you might be waiting for a while before the query is completed.
Before we go there, though, let’s create a duplicate of the PicklistMappingSet query. If you make an error in your selection, just click the delete symbol next to the steps to get rid of it. My previous experiment with connecting to CRM Online OData feed with Excel 2013 Power Query seemed to be one of the very few blog posts that come up when you search for information on the topic. Opportunities tend to be a nice entity for demonstrating your typical reporting needs on summing money values based on sales process stage, owner etc. After a bit of trial and error I figured out what the procedure for turning that [Record] link into actual data values is.
This is where you can drill down to the column contents and choose which attributes for that field you would like to include in your query data.
However, the much more interesting cloud scenario of building Power View reports that leverage data from CRM Online directly seems to be beyond the current feature set offered by Power BI, unless I’m mistaken.
Knowing that Dynamics CRM 2011 and 2013 both provide an OData endpoint, this would seem like a great option for retrieving data from a CRM Online based system for reporting purposes, since direct database connections aren’t available in the cloud. The reason behind the error messages is that Excel and PowerPivot have not been able to support the authentication mechanism required for accessing the CRM Online OData feed.


The Power BI umbrella also covers client side components, including Power Pivot (now spelled as two separate words apparently) and Power Query, that bring new capabilities to Excel. Whenever I feel like saying a thing or two to about Dynamics CRM, I may post it here on my blog, tweet it, save it to my CRM links or post it on Google+. UPS segment has witnessed a consistent rise in demand owing to the rapid development of the IT sector, along with growing consciousness among individuals about protecting costly electronic equipment that can be adversely affected by sudden power failures. And he was the man responsible: the sole decision-maker, the sole signatory, the PM and the FM, the man at the top. FINMA has carried out investigations into more than 20 banks in connection with these cases, and has opened seven enforcement proceedings against institutions. Those are significant sums of money for developing nations like Malaysia and Brazil, in which the average monthly income is less than USD 1,000.
More importantly, that would only give us a static list of option set values that couldn’t adapt to the changes in CRM customizations.
Still, that would leave us the burden of setting up an automated export system that would produce the customizations.xml file to reflect the latest changes.
After connecting to the OData feed URL we should select the tables that we want to work with from the data source navigator pane. If you want to move on a bit faster then check out this great tip by Andre Margono on how to set up a query filter for the Dynamics CRM OData query (for example, only active leads).
This will make it easier for us to map the values into our actual leads table later on, as well as preserve the original option set value table available for further queries.
Do this to the ColumnMappingId column and just load up all the columns found from behind it. For this example we want to see the LeadSource field, so add a new filter for this value, just as you would in a normal Excel data table.
In that article I never bothered to go deeper into actually working with the CRM data as the big news really was that the latest version of Power Query was finally able to access data from CRM Online, thanks to the added support for Office 365 authentication on the OData feed. Since it’s not immediately obvious, I decided to write it down onto this blog post, so that anyone else experimenting with using Power Query and Dynamics CRM Odata feeds can move on faster than I did.
As you expand more columns, you’ll notice that the Applied Steps dialog in the query settings pane will list each of them as a step. Move over to Power Pivot instead to define relationships between different tables, rename the columns, create calculated columns and do any other manipulation with the data before presenting it on a report layout.
However, the list of supported data sources doesn’t mention anything about Dynamics CRM.
Let’s hope that we get more information about the possibilities of Power BI for CRM Online customers when Microsoft presents their latest Dynamics product roadmaps at Convergence 2014 in a few weeks time.
There is a workaround that you could apply if you’ve got the CRM Outlook client installed on the same machine, as described in this video by Ed Martinez, but in general using PowerPivot for CRM Online reporting has been quite restricted.
To get an understanding of the features included or under development, I encourage you to watch this Power BI demo from WPC 2013, which definitely deserves the Coolest Tech Demo of 2013 trophy if you ask me. Demand for gensets comes from various sectors such as IT and ITes, telecom and construction, while inverters are primarily used in households, shops and commercial establishments. Manufacturing hub of the Indian power backup industry is concentrated in North India, particularly Himachal Pradesh and Kolkata.
And is it Mr Halmi, who even as CEO had the sole power to sign off the financial decisions at 1MDB? Nope, not a good approach from report maintenance perspective, so let’s not go there. You can also see that these fields will be included on the formula bar, which will read something like Table.ExpandRecordColumn and then a list of our chosen attributes.
This leads me to believe that the current version of Power BI doesn’t yet support using CRM OData feeds as data sources in reports published on the Power BI portal. On the client side, however, there is now an updated version of Power Query Preview for Excel 2013 that gives us the possibility to finally connect to a CRM Online OData feed directly.
Power deficit in Southern India has triggered the demand for power backup in this region, with Tamil Nadu, Karnataka and Kerala representing the highest share. Shortage in coal and gas, the primary raw materials for power generation, further aggravates the shortage in power supply.



Survival go bag checklist twins
American movies popular in other countries 2013
National geographic top 10 adventures
The darkest days how to survive an emp attack news

Rubric: Business Emergency Preparedness



Comments

  1. Ayxan_Karamelka
    Builder, Larabar, Zing, Luna, PowerBars, and Type Nuts & Spices wards off predators from their territory.
  2. Oslik_nr
    Establish what the price range and.
  3. login
    With out electrical energy there.
  4. Scorpion
    Ejection seats have survival kits in the seat pan reduce by means it is an activity that is quite.
  5. MAMEDOV
    Focus of the typical Bug Out Bag is upon survival in the single of the.