tag:blogger.com,1999:blog-58387522063909106582026-10-06T16:53:24.588+05:30Think Outside the BOXSubani Shaikhttp://www.blogger.com/profile/15957045950978198422noreply@blogger.comBlogger60125tag:blogger.com,1999:blog-5838752206390910658.post-831317683406960592024-08-27T14:42:00.007+05:302025-04-16T01:18:43.998+05:30

 SAP Analytics Cloud Import - Data Management.In SAC Acquired Models you can schedule for periodic data loads by using these settings. 

Subani Shaikhttp://www.blogger.com/profile/15957045950978198422noreply@blogger.com4tag:blogger.com,1999:blog-5838752206390910658.post-20093719884274352862024-08-27T14:32:00.002+05:302024-08-27T16:35:58.288+05:30

 SAP Analytics Cloud Limitations for Acquired Connection:https://help.sap.com/docs/SAP_ANALYTICS_CLOUD/00f68c2e08b941f081002fd3691d86a7/5f61b6509a5e4d499e8cb9685f32db73.html

Subani Shaikhttp://www.blogger.com/profile/15957045950978198422noreply@blogger.com0tag:blogger.com,1999:blog-5838752206390910658.post-74964527508143705782024-08-14T15:48:00.008+05:302024-08-14T19:41:53.966+05:30

Create a Connection in SAC tenant on File Server for Excel files import to build and schedule data load periodically into SAC Acquired Models.Go to SAC System Administration --> System IntegrationEnable option "Allow model import from File Server" Enable second option in screenshot if users required to export files.

Subani Shaikhttp://www.blogger.com/profile/15957045950978198422noreply@blogger.com0tag:blogger.com,1999:blog-5838752206390910658.post-24668508732434858102024-08-13T19:41:00.002+05:302024-08-13T19:59:50.792+05:30

 Direct Filters vs Indirect Filters at Page level in SAC Stories:When you create filter(s) on top of Secondary Model dimensions in where linked models ( Blended / joined ) with Primary model in SAC stories will not support due to limitation ( Live Connection Scenario ).Resolution: Create Dimensions based Primary model or Have limited master data below described in this warning.  

Subani Shaikhttp://www.blogger.com/profile/15957045950978198422noreply@blogger.com0tag:blogger.com,1999:blog-5838752206390910658.post-63623599717071210432023-08-17T23:45:00.002+05:302023-08-17T23:45:29.823+05:30

 SAP Analytics Cloud R-Visualization#3Jitter Plot Chart # Simulates data and visualizes then as a Jitter Plot# load packageslibrary(ggplot2)# assign dataset.seed(123)myData <-diamonds[sample(nrow(diamonds),9000),]#add styling outputGraphics <- ggplot(myData, aes(x = color, y = price/carat, color = color))+geom_jitter()+ggtitle("Diamond Price by Color")+xlab("Diamond Colour")+ylab(

Subani Shaikhttp://www.blogger.com/profile/15957045950978198422noreply@blogger.com0tag:blogger.com,1999:blog-5838752206390910658.post-40926483205833025152023-08-17T23:29:00.010+05:302023-08-17T23:46:22.744+05:30

SAP Analytics Cloud R-VisualizationGauge Chartlibrary(plotly)library(ggplot2)fig <- plot_ly(domain = list(x = c(0,100000), y = c(0,100000)),value =  select model$ 'variable',title = list(text="Give your Title"),type = "indicator",mode = "gauge+number+delta",delta= list(reference=80000),gauge= list(axis = list(range= list(NULL,100000), tickwidth=1, tickcolor="darkblue"),bar = list(color= "

Subani Shaikhttp://www.blogger.com/profile/15957045950978198422noreply@blogger.com0tag:blogger.com,1999:blog-5838752206390910658.post-23115809294989490272023-08-17T23:18:00.004+05:302023-08-17T23:18:41.315+05:30

SAP Analytics Cloud R-Visualizations#1#Guagelibrary(googleVis)gvisGuage(BestRunJuice_SampleModel,options=list(min=0, max=800, greenFrom=0, greenTo=100, yellowFrom=101, yellowTo=500,redFrom=501, redTo=800, width=400, height=300))#Guage$html$footer<- NULL#Guage$html$jsfooter<- NULL#Guage$html$caption<- NULLplot(Guage)

Subani Shaikhttp://www.blogger.com/profile/15957045950978198422noreply@blogger.com0tag:blogger.com,1999:blog-5838752206390910658.post-31981550847669697712015-08-01T06:31:00.003+05:302016-10-14T17:07:44.725+05:30

SAP BO Performance Tuning @ Various levels: Connection Level: Use 64 bit connection types @64 bit Operating System rather 32 bit connection type. Database Level/OLAP cubes/BEx Queries: Healthy DWH or well design of Database, its tables with Indexes built. Semantic/Universe Level: Formulas, Aggregate functions, Aggregate_Awareness, LOVs, Group by, Prompts based on Year, Quarter, Month, Weeks,

Subani Shaikhttp://www.blogger.com/profile/15957045950978198422noreply@blogger.com13tag:blogger.com,1999:blog-5838752206390910658.post-37957149421706760292014-07-10T15:48:00.000+05:302015-12-23T09:52:07.733+05:30

1. Linganalysis Configurations: I. Basic II.Stems III.Full 2. Extraction Configurations: I. Core II.Core VoiceOfCustomer

Subani Shaikhttp://www.blogger.com/profile/15957045950978198422noreply@blogger.com11tag:blogger.com,1999:blog-5838752206390910658.post-33220530371262157272014-04-01T19:57:00.002+05:302015-12-23T09:53:04.012+05:30

SAP HANA-HWC-AP Intel Processors: Nehalem, Westmere, Ivy. PAM:http://service.sap.com/~sapidb/011000358700000701932011E  SAPS:SAP Application Benchmark Performance Standard (throughput unit for HW sizing)

Subani Shaikhttp://www.blogger.com/profile/15957045950978198422noreply@blogger.com4tag:blogger.com,1999:blog-5838752206390910658.post-81704404678660791942014-03-31T16:19:00.000+05:302017-01-04T18:29:18.916+05:30

ODBO:OLE DB for OLAP ODBC:Open Database Connectivity JDBC:Java Database Connectivity BICS: BI Consumer Services.

Subani Shaikhttp://www.blogger.com/profile/15957045950978198422noreply@blogger.com0tag:blogger.com,1999:blog-5838752206390910658.post-38787593633185141462014-03-20T16:27:00.005+05:302024-08-13T19:55:24.414+05:30

SAP BW Performance These figures were reported by customers, which already have BW on HANA operating in their IT landscape. 1. Red Bull Red Bull started to run its SAP NetWeaver 7.3. Business Warehouse on HANA in 2011. The migration. Non-disruptive fast migration. Project completed in less than 2 weeks. Database size before migration: 1.5 TB; reduced by 80% after migration. The result: Boost

Subani Shaikhttp://www.blogger.com/profile/15957045950978198422noreply@blogger.com4tag:blogger.com,1999:blog-5838752206390910658.post-2242150478439174062013-01-07T20:55:00.001+05:302013-11-26T08:33:42.013+05:30

Unknownnoreply@blogger.com1tag:blogger.com,1999:blog-5838752206390910658.post-62400384421837677182012-05-27T00:40:00.001+05:302017-01-04T18:30:03.477+05:30

1) Platform Edition: SAP HANA Database SAP HANA Studio SAP HANA Client  SAP Host Agent SAP HANA Information Composer 2) Enterprise Edition: SAP HANA Database SAP HANA Studio SAP HANA Client  SAP Host Agent SAP HANA Information Composer LT Replication Add-on (SLT) LT Replication Server (SLT) SAP BO Data Services 4.0 3) Enterprise

Unknownnoreply@blogger.com37tag:blogger.com,1999:blog-5838752206390910658.post-73175249378677908602012-05-15T17:05:00.001+05:302015-12-23T09:46:11.267+05:30

OLAP Cubes sources (as a DataSource) for SAP BO OLAP, see below • SAP BW InfoCube • MS SQL Server Analysis Services (SSAS) Cube • Hyperion Essbase Cube (Now it is Oracle Essbase) Designer creates universe automatically from a connection to a InfoCube or QueryCube. The cube elements are mapped directly to equivalent structures in the universe. A OLAP flattening driver is used to

Unknownnoreply@blogger.com2tag:blogger.com,1999:blog-5838752206390910658.post-57069403536222270532012-05-15T17:01:00.001+05:302014-05-01T19:42:05.450+05:30

Multisource Universes: An administrator can build a universe (the vendor's term for a data model) drawing on multiple relational data sources. This has been a big competitive weakness in SAP BusinessObjects when compared to Oracle, IBM Cognos and MicroStrategy. I've tested this capability in 4.0 and feel that other products still seem to have a more robust approach. Nonetheless, this is still a

Unknownnoreply@blogger.com5tag:blogger.com,1999:blog-5838752206390910658.post-8310150945754324782011-12-08T17:46:00.001+05:302014-10-17T23:49:41.419+05:30

SAP BW Upgrade usually of 2 Types. 1. Technical Upgrade (Service Pack Stack Upgrade) 2. Functional Upgrade In Technical Upgrade Projects, Lead/Senior Consultant (Expertise) will be involve in many Phases. SAP BW SPS Upgrade phases: If it is a global client (MNCs) : Decisions based on Business Needs/Cost/Time/Effective/Thorough. Some times client will not like to upgrade ECC/CRM...Boxes. 1.

Unknownnoreply@blogger.com5tag:blogger.com,1999:blog-5838752206390910658.post-36948456941861337222011-11-24T10:37:00.001+05:302013-01-07T21:05:30.863+05:30

BWA : How BW Accelerator reduces maintenance effort?!   Aggregate Maintenance Automated caching strategies. Building database indexes Improves implementation and administration Reduces TCO Where as the relational aggregate/caching approach is not obsolete with the BW accelerator, and is suitable for some scenarios Smaller data volume Predictable query patterns Relaxed response

Unknownnoreply@blogger.com3tag:blogger.com,1999:blog-5838752206390910658.post-45793594986134528412011-10-07T06:48:00.000+05:302014-05-01T19:30:18.977+05:30

Row Level Security limits the rows(data) a user/group can view. This is implemented using Supervisor in previous versions of BO.From XI we can implement Row Level Security in Designer.We can use @Variable('BOUSER') in where condition area of an Object Definition.for eg: Employee.EmployeeId  is the object, Go to object properties in Select--we write Employee.EmployeeId, in Where write 

Unknownnoreply@blogger.com2tag:blogger.com,1999:blog-5838752206390910658.post-16987975400137983122011-10-03T04:31:00.000+05:302014-04-01T21:43:17.054+05:30

If the Version is BO Enterprise XI 3.0/3.1, If it is SAP BI 4.0 it doesn't required. Follow the below Steps.  1.To Integrate BO Server with SAP ECC/BW Download appropriate SAP Integration Kit from https://websmp206.sap-ag.de/support   2. Extract the Compressed file. 3. Install the BO Integration Kit on BO server. 4. Open

Unknownnoreply@blogger.com2tag:blogger.com,1999:blog-5838752206390910658.post-12517120595305324652011-09-03T21:39:00.000+05:302014-04-01T21:44:17.389+05:30

This kind issue may rise while log on to BO Designer. Go to this folder location. C:\Documents and Settings\Application Data\Business Objects\Business Objects 12.0\lsi  In the lsi folder, you'll find some .lsi files that are named after the servers that you've connected to. Go ahead and either delete, or cut/paste it to another location (in case you want to save these as a

Unknownnoreply@blogger.com2tag:blogger.com,1999:blog-5838752206390910658.post-76807801387154682082011-08-12T03:32:00.000+05:302014-11-08T02:06:16.700+05:30

COPA Extraction Step by Step: SAP R/3 or SAP ECC: 1. SAP R/3 or ECC goto T.Code KEB0, In Function: Select Create  Control Parameters: Provide a New CO-PA DataSource Name:1_CO_PA%CL%ERK 2. Select your Operating Concern, e.g.,IDES. 3. Select radio button Costing-based or Account-based as OC. 4.Select field names for partitioning.e.g. BUKRS (Company Code), Check 5.Click on Info

Unknownnoreply@blogger.com2tag:blogger.com,1999:blog-5838752206390910658.post-57889869867197728022011-06-29T10:00:00.000+05:302014-05-01T19:39:06.181+05:30

If you got this type of error: If i go through No SID found for value 'LOT' of characteristic 0BASE_UOM Message no. BRAIN070 Diagnosis: Characteristic value LOT does not exist in the master data table of characteristic 0BASE_UOM. Therefore, this value could not be transformed into the internal SID. Procedure: Check whether the value is correct or not. If it is correct, you need to generate

Unknownnoreply@blogger.com2tag:blogger.com,1999:blog-5838752206390910658.post-67625072373593311182011-06-20T11:24:00.000+05:302014-05-26T04:13:14.711+05:30

SAP BW Variables Types and Processing types Matrix: ---------------------------------------------------------------------------------------------- We can check the data provider in the object i_infoprov in debug in RSRT t.code. Check the Code snippet. span { font-family: "Courier New"; font-size: 10pt; color: rgb(0, 0, 0); background: none repeat scroll 0% 0% rgb(255, 255,

Unknownnoreply@blogger.com1tag:blogger.com,1999:blog-5838752206390910658.post-47489917299725274982011-06-10T09:22:00.000+05:302014-04-01T21:54:16.546+05:30

I am on BW3.5. Indeed RSZDELETE removes:   1) a query for me, even if the query does exists in Workbook (btw I do not get any warning from the transaction!).   2) The reference from Workbook to the Query. But Workbook itself is not deleted, which is not a big problem, because I can delete Workbook with function module RRMX_WORKBOOKS_DELETE. When you run transaction RSZDELETE

Unknownnoreply@blogger.com1