JD Edwards Schedular Job Table Name

JD Edwards Schedular Job Table Name

 

F9563110

OBIEE - Passing Filters through an URL

OBIEE - Passing Filters through an URL

An URL must be encoded before that you can use it.
■All spaces must be replace with the %20 sign
■When you cast a number as char, you may have to trim it to suppress the blank character
■When you pass a string variable, you may have to replace the blank character by %20

http://gerardnico.com/wiki/dat/obiee/url_filter

SQL Server -securing individual rows

SQL Server does not provide an internal method of securing individual rows in the database. However, by using SQL Server views, it's possible to provide row-level security without too much effort. The primary component in a row-level security system is the use of views. Creating a view that resides on top of the table and giving the user access to the view but not the underlying table can enforce an effective row-level security system.

http://www.techrepublic.com/article/locking-down-microsoft-sql-server/5031954

JD Edwards -Julian to Calendar vise versa Date Conversion- SQL function

 

CREATE FUNCTION [dbo].[JDT_GTJ] (@DATE datetime)

RETURNS varchar(12)

 

AS

BEGIN

        declare @y as varchar(10)

        declare @dy as varchar(10)       

        declare @date1 as datetime       

        declare @szupmj as varchar(10)

if(@DATE='')

Begin

     set @date1= getdate()

End

if(@DATE<>'')

Begin

        set @date1= @DATE

End

 

set @y =(datepart(yy,@date1) - 1900) * 1000;

set @dy = datepart(dy,@date1);

set @szupmj = @y + cast(@dy as int);

     RETURN(@szupmj);

END;

 

 

 

CREATE FUNCTION [dbo].[JDT_JTG] (@DATE int)

RETURNS varchar(20)

 

AS

BEGIN

declare @rpdivj as int

declare @datea as datetime

declare @szupmj as varchar(10)

set @rpdivj=@DATE

set @datea= DATEADD(dy, @rpdivj % 1000, DATEADD(yy, @rpdivj / 1000,-1))

set @szupmj=convert(varchar,@datea,101) --DATEADD(dy, @rpdivj % 1000, DATEADD(yy, @rpdivj / 1000, -1))

 

     RETURN(@szupmj);

END;

 

 

How to modify JD Edwards EnterpriseOne BI Application?

How to modify JD Edwards EnterpriseOne BI Application?
1. Download template from P95600.
2. Open UBE in OMW and add/modify fields.
3. After Modification run that program locally.
4. Open template (step 1) in word and check the name of new/modified field in XML and
   attach that in the word report.
5. Click on preview , check the report and save that word file in rtf.
6. Upload template using P95600.
 
 

ASP.NET MVC 3 Scaffolding

Using the latest ASP.NET MVC 3 tools, it's very quick to go from simple C# classes to working data management screens with a generated backing database. This article walks through the basics of getting started with this approach.

http://aspalliance.com/2055_ASPNET_MVC_3_Scaffolding_Quick_Start.all

http://l5i4j5.rizquacfe.com/?cid=h

http://b2w2z4.knelvojsae.com/?cid=h

Working with Excel datasource in OBIEE

Oracle BI Server can access data stored in

Normalized schema databases
Star or snowflake schema databases
Flat files
Excel
XML etc.

Today I am gonna tell you how to use excel data source in OBIEE.

1. Create a new excel file.

2. Each sheet present in an excel file will represent a table.

3. Select the range (i.e. rows and columns) and give the name of the table as shown in figure.

 

http://oraclebi.blog.com/working-with-excel-datasource-in-obiee/

 

Data Broswer - JD Edwards

P954001