Wednesday, December 14, 2011

Business Intelligence in a complete word

Business Intelligence is going to be a key success of the world's business and marketing, this is why I wanted to be certified; I love it; I deal with it because it's the mix of programming development along with financially facts and measures which is predictable as seen by the market trend that shows the company direction, so you are the one who represent this to your boss! I believe that BI is the most IT tool which is tangible in the real world.

Now let be familiar with it :

Effective decisions are choices that move an organization closer to an agreed-on set of goals in a timely manner.

Three key ingredients necessary for making effective decisions:
ü  First, there must be a set of goals to work toward.
ü  Second, there must be a way to measure whether a chosen course is moving toward
 or away from those goals.
ü  Third, information based on those measures must be provided to the decision maker
in a timely manner.

To function as part of effective decision making, a goal must:
ü  Contain a specific target.
ü  Provide a means to measure whether we are progressing toward that target.
 

Ø  Business intelligence is used to support effective decision so it should be utilized at all levels of an organization to promote effective decision making.

Saturday, December 10, 2011

My New Certificate on Business Intelligence

I've got my MCTS certificate on SQL Server 2008 Business Intelligence Development and Maintenance with score 972...

Tuesday, August 23, 2011

Default value or value provided for the report parameter 'Period_Year' is not a valid value

You may get this error while opening the Enterprise Portal/Role Center :
"Default value or value provided for the report parameter 'Period_Year' is not a valid value"
Short answer is, you should create a new period for fiscal year for a company.
So many googling for this error had no useful solution, unless tried by myself to find out the reason and here is the answer, clear and straightforward :
do this by : 
1. Just go to the AOS and be sure to selected the company which you want to work on.
2. Go to "General Ledger" -> Setup, expand "Periods" then click on "Periods".
3. In the opening window,  on the right hand, click on "Create new fiscal year".
4. create a fiscal year from the start point to the current year.
5. Update BI Data and OLTP schema using the OLAP Administration page.
6. Process the cubes and deploy them.
7. All done, browse and see the KPIs is correct now.
Note that the "Current year" in fiscal year is so important because inside the reports there is a select command that pointed to the "date(now())" function and if the current year does not exist the query will return "null" which are the input data for "company year" so as long as "Period year" using "company year" value for its query then the default data won't be available to the webpart when starting the page and finally it returns the error.

Have a nice time

Friday, June 17, 2011

Sunday, June 12, 2011

Developers guide: Overriding vs Overloading

...many developers may confusing between these two type of changes on Methods :
So lets say that Overriding is whrere that the signature is not going to change and only
we change the super class implementation of a method, such as a subclass,
but in Overloading we have two methods with different signature.
There was an error in this gadget