dev

If you are using ASP.NET Membership Provider for a website, one simple and practical way how to get ‘username’ for logging activities on CRUD (Create Read Update Delete) implementation is by storing the “username” on a session. Put this little code on Default page, or first landing page after succesfull user login.

1

using System.Web.Security;

…

1
2
3
4
5
6
7
8
9

 protected void Page_Load(object sender, EventArgs e)
    {
        //check user login
        if (User.Identity.IsAuthenticated)
        {
            //get username and put into session
            Session["UserName"] = Membership.GetUser().UserName.ToString();
        }
    }

Next example, if you are using DataSet , just put the session name on a parameter for later use on SQL Command.

<InsertParameters>
<asp:SessionParameter DefaultValue=”na” Name=”UserName” SessionField=”UserName” Type=”String” />
<InsertParameters>

Managing Query in SAP BW NW7 can be done with theese tools and t-code:

• Query Designer, an application from SAP NW7 Business Explorer installation.
• t-code: RSZC : to Copy Query between InfoCube or MultiProvider
• t-code: RSZDELETE : to Delete Quer between InfoCube or MultiProvider
• t-code: SA38 , program: RSAQ_DELETE_QUERY : Reorganization of WorkBook and Role Storage , this t-code and program can seek query dependency with workbook. Query with workbook cannot be deleted directly, the workbook should be deleted.

Note for Deleting Query

Deleting Query can be easily done by using this t-code: RSZDELETE or using Query Designer, but sometimes problem just happen.

Problem / Symptom that migght happen when Deleting query with RSZDELETE:

The Query Cannot be deleted from Query Designer or SAP GUI (with RSZDELETE). It just keep showing error / warning message  “ Query Block” on SAP GUI interface. If we delete the Query from Query Designer, the query seems deleted but if logoff and log on BEX again the query magically appear.

So, what we have to do then? Both RSZDELETE and Query Designer cannot delete the Query.

Log on to SAP GUI > RSA1 > Transport Connection Menu.We have to set the query to the Bex Transport Request. Note that there are two kind of transport (Transport and Bex Transport). Build a new Bex Requset transport, by clicking the icon with pictures of a ‘car’ and ‘BEx’. Then Click ‘Assingn / Delete ‘, create ‘new request’ …. done!

and the query should be deleted easily. Good Luck

After getting to  know and familiar with SAP BW basic T-CODES. I found another website to help mastering SAP BW is http://sap.seo-gym.com/.

Lots of goodies relating  SAP BW, such as tutorials, learning guides and help files containing PDF or Microsoft Documents (Doc) .

Interesting, I thought the page/sub domain is a technic for Search Engine Optimation(SEO), and it works!

Theese are the list of tutorial that i copy paste from sap.seo-gym.com

• SAP BW Authorizations docs in detail
• SAP BW BPS Planning Folders and Layouts
• How to integrate SAP BI with XI PDF
• How to install SAP BW
• SAP BW Netweaver Installation MEDIA_LIST_NETWEAVER
• Online Analytical Processing(OLAP)
• SAP BW Sizing Help for estimating the hardware resources needed
• SAP BW Business Explorer(BEX) a detail learning document
• ABAP Required in SAP BW for ABAP routines,Functional modules in detail
• SAP BI Accelerator for high performance in queries
• SAP BW Cell editing in BEX
• Control and profitability Analysis in SAP BW
• Exit Function in SAP BW
• SAP BW Front End Designing
• How to handle inventory in SAP BW
• SAP BW Transaction Codes (t-codes)
• SAP BW Performance Tuning for queries
• SAP BW BPS WEB Based Planning