Data BI Visuals

In Simple English, Not is being used to show the negative meaning of the context. In Web Intelligence, "Not"" is also projected as same but still we can use for reverse logic. Syntax of Not Function: Not(Object) – It returns boolean value. For example, consider a below condition. If “Status” = “Approved” then “Process Completed” else “Waiting.” If “Status”<>”Approved” then “Waiting” else “Process Completed.” We can use NOT function for the second condition. It would be like below, If NOT(“Status”=”Approved”) then “Waiting” else “Process Completed.” When we see "Not" function alone, then it would be simple, but when "Not" function is combine with other functions, then we can handle the complex logic very quickly.

Microsoft released SQL Server vNext as a platform for windows and Linux. Check the below video to know the installation process of SQL Server vNext.

This is one of the post from SAP Business Objects Admin collection. It explains the default access levels that administrators can use to assign access to end users. Each Access level is defined with certain set of permissions for all the tools in Business Objects. This can be customized based on your requirement. If you think that you don ’ t want to touch the default access levels, you can create a new access levels with your requirements. Check the permissions that end user get when you assign the access levels. View Access Level It will be the preferred access level who just want to give only read or view access of reports. View on Demand Access Level It is slight advanced than view access level as it has the refresh option where end user can refresh the reports. Schedule Access Level This is just for schedule the reports. This access will be assigned to users who take care of reports schedule. Full Access Level This will provide ful...

Can anybody claim that you are secure in this digital world? Mostly, NO!!! Always someone is watching you when you are using internet. I am not mean that you should be away from internet to get privacy and security. You should know who are all watching you so that you can easily handle them. If you are using Google Search on your day to day activities then google is watching you. The same is applicable for Andriod Phone users as it is a product of google. This post explains that how you can check what are the activities has been monitored by google. Google not just monitoring and recording your text inputs, it is also recording voice & audio. You can track all your voice and audio that has been recorded by google. All the information are maintained in google history page. Check the googlehistory page and look at your recordings The above URL redirects to https://myactivity.google.com/myactivity?restrict=vaa You should sign-in to see your acti...

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 deta...

By default, "Object from this query" option will be disabled when drag and drop the object in query filter.     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.