JD Edwards OBIEE Time dimension

Very good sample on Julian date time dimension to create sales report check this out sample.

http://www.youtube.com/watch?v=IsNTTweoZ4s

OBIEE development document

http://download.oracle.com/docs/cd/E10415_01/doc/bi.1013/e12187.pdf

OBIEE 11g installation Windows

OBIEE 11g installation for windows...

 

 

http://debaatobiee.wordpress.com/2011/02/13/oracle-business-intelligence-enterprise-editionobiee-11g-installation/

http://www.adivaconsulting.com/adiva-blog/item/10-obiee_install

http://www.oraclenerd.com/2010/08/obiee-11g-install-part-i.html

 

UBE0000084 ERROR: Function: PDFDocGen_Save, Code: 3, Message: Bad parameter.

The issue is that in tools release 8.98.4.4 if a batch job is suppose to produce print
output that is just a single blank page, no PDF file is generated for the
batch job and the batch job ends in an 'E' (error) status. 

Bug# 12977338

The fix will go in tools release 8.98.4.6.

POC fix JD Edwards

A POC fix is an untested fix that you can apply to your tools release to test with to see if it works or not.

Difference Between OBIEE 10g and OBIEE 11g

Difference Between OBIEE 10g and OBIEE 11g

Architectures-
OBIEE 11g architecture...http://www.rittmanmead.com/2010/07/09/obiee-11gr1-architecture-and-use-of-weblogic-server/
OBIEE 10g architecture....http://gerardnico.com/wiki/dat/obiee/obiee_overview

Features-
New features in OBIEE11g...http://forums.oracle.com/forums/thread.jspa?messageID=4392154
http://blogs.oracle.com/robreynolds/2010/07/new_administration_features_of.html

check this out https://forums.oracle.com/forums/thread.jspa?threadID=1554799

ASP.NET MVC dynamic view sections

Intrigued by the question and having no clue on how to do this, I quickly hacked together a SettingsViewModel, to which he could add all section view models no matter what type they are:

 

http://blog.maartenballiauw.be/post/2011/09/08/ASPNET-MVC-dynamic-view-sections.aspx

 

Is Microsoft Office 2000 compatible with Windows 7

Outlook 2000 is not supported on Windows 7

 

Delete All Rows From Table JD edwards

0001 Get Input Output Env Handles
        SL LoginEnvironment                -> szInputEnvironment
        VA rpt_GenericLong <- idInputEnvHandle
        SL LoginEnvironment                -> szOutputEnvironment
        VA rpt_GenericLong_Out <- idOutputEnvHandle
        SL LoginEnvironment                -> szLoginEnvironment
0002 Delete All Rows From Table
        "F550154" -> szTableName
        VA rpt_GenericLong_Out -> idOutputEnvHandle

Roll up account balance JD Edwards

drop

table #temp

select

gbobj,gbsub,gmdl01,gmlda,sum(gbapyc/100)gbapyc,sum(gban01/100)gban01,sum(gban02/100)gban02,sum(gban03/100)gban03,

sum

(gban04/100)gban04,sum(gban05/100)gban05,sum(gban06/100)gban06,sum(gban07/100)gban07,

sum

(gban08/100)gban08,sum(gban09/100)gban09,sum(gban10/100)gban10,sum(gban11/100)gban11,sum(gban12/100)gban12

into

#temp

from

jde_crp.crpdta.f0902

left

outer join jde_crp.crpdta.f0901 on gbaid=gmaid

where

gmco=1 and gmobj>=40000

and

(gban01+gban02+gban03+gban04+gban05+gban06+gban07+gban08+gban09+gban10+gban11+gban12)<>0

group

by gbobj,gbsub,gmlda,gmdl01

order

by gbobj,gbsub,gmlda

drop

table [#temp2]

select

distinct gmobj,gmsub,gmdl01,gmlda into #temp2 from jde_crp.crpdta.f0901 where gmco=1 and gmobj>=40000

drop

table [#temp3]

select

a.gmobj pgmobj,a.gmsub pgmsub,a.gmdl01 pgmdl01,a.gmlda pgmlda, b.*

into

#temp3 from #temp2 a

left

outer join #temp b on gbobj=gmobj and gbsub=gmsub

order

by a.gmobj

delete

from #temp3 where gbobj is null and pgmlda in(7,8)

drop

table #temp4

select

ltrim

(substring(a.gmobj,1,1)+'0000')t01,d.gmdl01 td01,

ltrim

(substring(a.gmobj,1,2)+'000')t02,c.gmdl01 td02,

ltrim

(substring(a.gmobj,1,3)+'00') t03,b.gmdl01 td03,

a

.* into #temp4

from

#temp2 b

left

outer join #temp2 a on ltrim(substring(a.gmobj,1,3)+'00')=b.gmobj

left

outer join #temp2 c on ltrim(substring(a.gmobj,1,2)+'000')=c.gmobj

left

outer join #temp2 d on ltrim(substring(a.gmobj,1,1)+'0000')=d.gmobj

where

a.gmlda in(4,5,6,7)order by a.gmobj

--select * from #temp3

--select * from #temp4

select

t01

,td01,t02,td02,t03,td03,gmobj,gmsub,a.gmdl01,a.gmlda,gbobj,gbsub,gbapyc,gban01,

gban02

,gban03,gban04,gban05,gban06,gban07,gban08,gban09,gban10,gban11,gban12

from

#temp4 b

left

outer join #temp3 a on a.pgmobj=b.gmobj and a.pgmsub=b.gmsub

where

a.pgmobj is not null

Account hierarchy JD edwards - F0901

select

GMMCU,GMOBJ,GMSUB,GMLDA , GMPEC , GMDL01 from testdta.f0901

where

gmobj>40000

group

by GMLDA , GMPEC , GMDL01,GMMCU,GMOBJ,GMSUB

Leading zero drop from CSV file - A solution

In JD Edwards Report we have this issue Leading zero drop from CSV file , you can get output without dropping leading zeros like following:-

 

Open Excel File=> Click on Data=>Double click on From Text =>Select text file SCIInvoice.csv=> click on Delimited=> Click Next=>Select Comma=>click on last column with leading zeros=>Select Text=> Click on Finish =>OK

 

Create Power form JD Edwards Sample

Power form JD Edwards Sample from Oracle site, complete steps:-

 

 

 

https://support.oracle.com/CSP/main/article?cmd=show&type=ATT&id=1320607.1:EXAMPLE

 

https://support.oracle.com/CSP/main/article?cmd=show&type=NOT&doctype=HOWTO&id=1320607.1&addClickInfo=<data search_text="power%20forms%20subforms%20%20" search_result_size="18" search_result_count="18" powerview_id="" on_off="off" item_position_in_list="15"/>

 

 

conversion to black and white works webcam .net

The numbers below the image are delays in milliseconds measured on my 2.8GHz PC with the webcam set to 640x480 pixels. The milliseconds show some interesting results. For example, the slowest step is the webcam image gathering. 100 ms means that you will get 10 frames per second. This is poor. Webcams are typically slow. You can make them faster on account of quality. A lower resolution makes the camera faster, but the image quality may become useless. Another surprise is why the conversion to black and white is so slow (12ms). On the other hand, what is expected to be slow is OCR and the solver. But those are surprisingly fast – only 7 ms. I will explain each step in detail and show how things could be improved. The source code function that invokes the above process is DoSomeImageProcessing().
 
 
http://www.codeproject.com/KB/game/WebcamSudokuSolver.aspx
 
 

Rotate desktop Screen

How  to fix Rotated desktop Screen:-

 

You can use ctl+alt+up/down/left/right