itechpassion

Entry to the Technology

New MSN look

Start experience the new MSN look, It has lot of features more than Google.

Some of the features are,

Office – Office Products like Word, Excel, PowerPoint, etc. By using Microsoft account, we can create excel sheet and can store it on one drive.

OneNote – This is my favorite app.

OneDrive

MSN

WEBI Report–Object from this query

By default, “Object from this query” option will be disabled when drag and drop the object in query filter.

clip_image001

How to enable “Object from this query” option?

It is easy to enable this. As you can see in the filter, by default “In list” option will be there, by changing the value from list to other values , “Object from this query” option will be enabled.

clip_image002

Access HANA view in SQL Console

For each view, system will create a table whether it might be SAP HANA LIVE view or Calculation view or Attribute view. Those tables will be reside in system schema “_SYS_BIC”

Expand the schema -> Column Views. There you can see lot of tables.

Tables will be available for each view and each column inside that view. Make sure to get the main view. For example if you take HANA Live View “VBAK_COM”.

–Main View table

select top 10 * from “_SYS_BIC”.”sap.hba.ecc/VBAK_COM/”

To select view with particular column, follow below

select top 10 “SalesDocument” from “_SYS_BIC”.”sap.hba.ecc/VBAK_COM”

The above table can be access in SQL console, it will give the output which is same as what you have seen in the data preview.

The other tables also available for columns

select top 10 * from “_SYS_BIC”.”sap.hba.ecc/VBAK_COM/SalesDocument/hier/SalesDocument”

The above table will give detailed information about each node.

You can join the main view table with any table and can get the result.

SAP TCodes

There are many sites to see the list of Tcodes/ TXN codes . Here I displayed the look and feel of Tcodes.

TXN

Look and feel

SE11

clip_image001[4]

SE12

clip_image002[4]

SE13

clip_image003[4]

SE14

clip_image004[4]

SE15

clip_image005[4]

SE16

clip_image006[4]

SE17

clip_image007[4]

SE18

clip_image008[4]

SE19

clip_image009[4]

SE20

clip_image010[4]

SE37

clip_image011[4]

SE38

clip_image012[4]

Thanks

Let me know, if you want the same look and feel for other Tcodes

Google Apps Status Dashboard

Google showing dashboard with all Google apps with that status. It will be useful to check before buying mail users for enterprises.

From this dashboard, we can able to identify the down time of the apps, when it happened and how long it has been for service disruption mode and service outage.

Check the dashboard in below link

http://www.google.com/appsstatus#hl=en&v=status

image

Compare Word Documents

In some situations, we need to compare the original document with the revised one. It will be difficult to check one by one when it has more pages. There are many 3rd party tools are available to compare word documents. But Microsoft itself providing the feature. Have you noticed that in your word document? Mostly NO. Because this feature needs to be added manually from options.

Let see how to add this feature in word document.

Go to options by clicking the file option in top left corner.

W1

Select customize ribbon and choose all commands and find “Compare”

w2

Add that feature into customize the ribbon section, under new group.

w3

That’s it, you have added compare feature in your document. Check it in Home tab or wherever you added.

Start comparing documents.

Thanks

Alternate row colour in WEBI report table

How to customize the table look. We can able to get alternate colour for table like in excel. If you choose pre-defined format, we will get two colours. We can achieve the same in Webi report also.

Objective:

We are going to see, how to get the table like below

Table design

As you can see, it used two colour alternatively. We are going to learn, how to get that.

Step 1: Right click on the table and look for “Format table”

Format_table

Step 2: Go to Appearance section and find alternate colour at the bottom.

alternate

This is the place we have to select colour and row frequency.

Thanks. Please let me know, any more tips or queries on Web Intelligence.

 

Webi Nested Filter

In this post, we are going to learn how to create a nested filter in web intelligence rich client.

Drag and drop the objects into the query filter like below,

clip_image001

You can change the condition to OR by clicking on “AND”.

clip_image002

Now drag the filter over the filter you wish to nest with. Now am dragging the “Kunnr” filter into “Land1″, you will get screen like below,

clip_image003

We got the nested filter. It is nothing but the filter over filter.

As per the requirement, you can change the condition “And” & “Or”.

We can check the Query script viewer to confirm the result.

clip_image004

WEBI–Walkthrough Part 1

clip_image001

One of the tab in WebI report is,

Report Element

  1. Tables
  2. Cell
  3. Section
  4. chart
  5. others
  6. Tools, Position & Linking

Tables – We can create variety of tables

  1. Vertical Table
  2. Horizontal Table
  3. Cross Table
  4. Form

 Cell – We can add 2 types of cell in report

  1. Blank Cell
  2. Pre-Defined Cell

clip_image002

Section – Insert section based on the table values

clip_image003

Chart – Different type of charts

clip_image004

clip_image005

clip_image006

Others – Apart from normal default, we have plenty of other charts also available

clip_image007

clip_image008

clip_image009

Tools, Position & Linking – The other tools under report element will be in disable state till we add any of the figure in reporting area.

clip_image010

Other elements will be discussed, keep visit here.

Thanks

WEBI Query Properties

By using query properties, we can restrict the records to display in a report. Please check the options in query properties

 

Max rows retrieved – Maximum number of rows of data that are displayed when a query is run. This is related with Sample Result set. For example, if you give 1000 rows in “Max rows retrieved” then 500 rows in “Sample Result Set” then you will get 500 rows only.

Also it can be restricted based on the administrator security profile.

Sample Result Set – It determine the Maximum number of queries returns. This restriction is applied in database level.

Fixed – At each data refresh, query returns the same rows when Fixed option is marked. If not then on each data refresh, query returns different set of sampled rows

Retrieve duplicate rows – In some cases, in database, the same data may be repeated over many rows. You can restrict those data using this option.

 

image

Follow

Get every new post delivered to your Inbox.

Join 221 other followers