OXIESEC PANEL

Name	Size	Modified	Perms
📁 ..	-	02/03/2023 07:34:18 AM	rwxr-xr-x
📄 admaddmetadata.rx.html.svn-base	2.26 KB	02/03/2023 07:34:17 AM	r--r--r--
📄 admcfgform.rx.html.svn-base	300 bytes	02/03/2023 07:34:17 AM	r--r--r--
📄 admcfgform_dimension.rx.html.svn-base	9.87 KB	02/03/2023 07:34:17 AM	r--r--r--
📄 admcfgform_measure.rx.html.svn-base	16.31 KB	02/03/2023 07:34:17 AM	r--r--r--
📄 admcfgform_parent.rx.html.svn-base	6.08 KB	02/03/2023 07:34:17 AM	r--r--r--
📄 admcfgform_target.rx.html.svn-base	7.08 KB	02/03/2023 07:34:17 AM	r--r--r--
📄 admcfglist.rx.html.svn-base	5.06 KB	02/03/2023 07:34:17 AM	r--r--r--
📄 admcfglist1.rx.html.svn-base	1.9 KB	02/03/2023 07:34:17 AM	r--r--r--
📄 admfrmchgpas.rx.html.svn-base	3.5 KB	02/03/2023 07:34:17 AM	r--r--r--
📄 admfrmfb.rx.html.svn-base	2.35 KB	02/03/2023 07:34:17 AM	r--r--r--
📄 admfrmfb_upclogo.rx.html.svn-base	2.3 KB	02/03/2023 07:34:17 AM	r--r--r--
📄 admfrmip.rx.html.svn-base	4.33 KB	02/03/2023 07:34:17 AM	r--r--r--
📄 admfrmip_config_alert.rx.html.svn-base	3.88 KB	02/03/2023 07:34:17 AM	r--r--r--
📄 admfrmip_config_cub.rx.html.svn-base	19.02 KB	02/03/2023 07:34:17 AM	r--r--r--
📄 admfrmip_config_enq.rx.html.svn-base	3.47 KB	02/03/2023 07:34:17 AM	r--r--r--
📄 admfrmip_config_graph.rx.html.svn-base	12.36 KB	02/03/2023 07:34:17 AM	r--r--r--
📄 admfrmip_config_login.rx.html.svn-base	7.62 KB	02/03/2023 07:34:17 AM	r--r--r--
📄 admfrmip_config_user.rx.html.svn-base	6.92 KB	02/03/2023 07:34:17 AM	r--r--r--
📄 admfrmip_menu.rx.html.svn-base	4.36 KB	02/03/2023 07:34:17 AM	r--r--r--
📄 admfrmip_menuodr.rx.html.svn-base	4.73 KB	02/03/2023 07:34:17 AM	r--r--r--
📄 admfrmresetpas.rx.html.svn-base	2.78 KB	02/03/2023 07:34:17 AM	r--r--r--
📄 admgroup.rx.html.svn-base	397 bytes	02/03/2023 07:34:17 AM	r--r--r--
📄 admgroupfilter.rx.html.svn-base	2.7 KB	02/03/2023 07:34:17 AM	r--r--r--
📄 admgroupfilter_values.rx.html.svn-base	2.9 KB	02/03/2023 07:34:17 AM	r--r--r--
📄 admgroupform.rx.html.svn-base	5.08 KB	02/03/2023 07:34:17 AM	r--r--r--
📄 admgrouplist.rx.html.svn-base	3.31 KB	02/03/2023 07:34:17 AM	r--r--r--
📄 admgroups.rx.html.svn-base	2.83 KB	02/03/2023 07:34:17 AM	r--r--r--
📄 admjoin.rx.html.svn-base	365 bytes	02/03/2023 07:34:17 AM	r--r--r--
📄 admjoinform.rx.html.svn-base	4.14 KB	02/03/2023 07:34:17 AM	r--r--r--
📄 admjoinform_edittable.rx.html.svn-base	9.77 KB	02/03/2023 07:34:17 AM	r--r--r--
📄 admjoinform_incr.rx.html.svn-base	4.67 KB	02/03/2023 07:34:17 AM	r--r--r--
📄 admjoinform_mismatch.rx.html.svn-base	638 bytes	02/03/2023 07:34:17 AM	r--r--r--
📄 admjoinform_newjoin.rx.html.svn-base	6.84 KB	02/03/2023 07:34:17 AM	r--r--r--
📄 admjoinform_star.rx.html.svn-base	8.88 KB	02/03/2023 07:34:17 AM	r--r--r--
📄 admjoinform_star_rows.rx.html.svn-base	1.11 KB	02/03/2023 07:34:17 AM	r--r--r--
📄 admjoinform_syn.rx.html.svn-base	4.75 KB	02/03/2023 07:34:17 AM	r--r--r--
📄 admjoinform_table.rx.html.svn-base	4.86 KB	02/03/2023 07:34:17 AM	r--r--r--
📄 admjoinform_tablejoins.rx.html.svn-base	3.91 KB	02/03/2023 07:34:17 AM	r--r--r--
📄 admjoinlist.rx.html.svn-base	2.97 KB	02/03/2023 07:34:17 AM	r--r--r--
📄 admmain.rx.html.svn-base	303 bytes	02/03/2023 07:34:17 AM	r--r--r--
📄 admmenu.rx.html.svn-base	2.71 KB	02/03/2023 07:34:17 AM	r--r--r--
📄 admmeta.rx.html.svn-base	403 bytes	02/03/2023 07:34:17 AM	r--r--r--
📄 admmetadata.rx.html.svn-base	3.87 KB	02/03/2023 07:34:17 AM	r--r--r--
📄 admmetadata_edit.rx.html.svn-base	8.87 KB	02/03/2023 07:34:17 AM	r--r--r--
📄 admmetadata_group.rx.html.svn-base	2.54 KB	02/03/2023 07:34:17 AM	r--r--r--
📄 admmetadata_grouporder.rx.html.svn-base	2.04 KB	02/03/2023 07:34:17 AM	r--r--r--
📄 admmetalist.rx.html.svn-base	2.56 KB	02/03/2023 07:34:17 AM	r--r--r--
📄 admreportoption.rx.html.svn-base	4.58 KB	02/03/2023 07:34:17 AM	r--r--r--
📄 admsysmenu.rx.html.svn-base	4.4 KB	02/03/2023 07:34:17 AM	r--r--r--
📄 admtemplate.rx.html.svn-base	405 bytes	02/03/2023 07:34:17 AM	r--r--r--
📄 admuser.rx.html.svn-base	633 bytes	02/03/2023 07:34:17 AM	r--r--r--
📄 admuserfilter.rx.html.svn-base	2.57 KB	02/03/2023 07:34:17 AM	r--r--r--
📄 admuserfilter_values.rx.html.svn-base	3.7 KB	02/03/2023 07:34:17 AM	r--r--r--
📄 admuserform.rx.html.svn-base	15.32 KB	02/03/2023 07:34:17 AM	r--r--r--
📄 admuserform_AccessMatrix.rx.html.svn-base	2.24 KB	02/03/2023 07:34:17 AM	r--r--r--
📄 admuserform_useranalysis.rx.html.svn-base	23.12 KB	02/03/2023 07:34:17 AM	r--r--r--
📄 admuserform_userinfo.rx.html.svn-base	2.96 KB	02/03/2023 07:34:17 AM	r--r--r--
📄 admuserform_userinfo_filt.rx.html.svn-base	4.47 KB	02/03/2023 07:34:17 AM	r--r--r--
📄 admuserlist.rx.html.svn-base	4.69 KB	02/03/2023 07:34:17 AM	r--r--r--
📄 admusersubtabs.rx.html.svn-base	870 bytes	02/03/2023 07:34:17 AM	r--r--r--
📄 changepass.rx.html.svn-base	2 KB	02/03/2023 07:34:17 AM	r--r--r--
📄 dimhierarchy.rx.html.svn-base	3.13 KB	02/03/2023 07:34:17 AM	r--r--r--
📄 menuorder.rx.html.svn-base	1.1 KB	02/03/2023 07:34:17 AM	r--r--r--
📄 schemaTab.rx.html.svn-base	1.13 KB	02/03/2023 07:34:17 AM	r--r--r--
📄 setdashorder.rx.html.svn-base	2.77 KB	02/03/2023 07:34:17 AM	r--r--r--
📄 settings.rx.html.svn-base	6.08 KB	02/03/2023 07:34:17 AM	r--r--r--
📄 sortorder.rx.html.svn-base	2.58 KB	02/03/2023 07:34:17 AM	r--r--r--
📄 status.rx.html.svn-base	235 bytes	02/03/2023 07:34:17 AM	r--r--r--
📄 tableDesc.rx.html.svn-base	489 bytes	02/03/2023 07:34:17 AM	r--r--r--
📄 template.rx.html.svn-base	8.73 KB	02/03/2023 07:34:17 AM	r--r--r--
📄 template_define.rx.html.svn-base	8.45 KB	02/03/2023 07:34:17 AM	r--r--r--
📄 template_display.rx.html.svn-base	13.52 KB	02/03/2023 07:34:17 AM	r--r--r--
📄 template_list.rx.html.svn-base	2.56 KB	02/03/2023 07:34:17 AM	r--r--r--
📄 template_preview.rx.html.svn-base	2.51 KB	02/03/2023 07:34:17 AM	r--r--r--
📄 template_search.rx.html.svn-base	9.42 KB	02/03/2023 07:34:17 AM	r--r--r--
📄 usersetting.rx.html.svn-base	12.83 KB	02/03/2023 07:34:17 AM	r--r--r--

Editing: admjoinform_star.rx.html.svn-base

<HTML> 
	<link href="/edash///assets/admin/styles/main.css" rel="stylesheet" type="text/css"> 
	<link href="/edash///assets/admin/styles/dash_menu.css" rel="stylesheet" type="text/css"> 
	<script type="text/javascript" src="/edash//jscripts/validate.js"></script>
	<script type="text/javascript" src="/edash//jscripts/navigate.js"></script>
	<script type="text/javascript" src="/edash//jscripts/ajax.js"></script>
	<script type="text/javascript" src="/edash//jscripts/sorttable.js"></script>
	<script language=javascript>
<%@TABLE name=getAccess%>
var Access='<%=LUADMINACCESS%>';
<%/TABLE%>
	</script>
	<body>
		<table border=0 cellpadding=0 cellspacing=0 width=100%>
			<tr class=repo_title>
				<td>
					<div id=dashMenu>
						<ul id=Smenu>
							<li id=dashLink1 title='Joins'>
							<A HREF=cubui.rx?page=admjoinform.rx&page_ix=1&conn=<%=conn_id%>&tbltabsel=1&tabname=<%=tabname%>&tabcat=<%=tabcat%>><span>Joins</span></A>
							</li>
							<li id=dashLink1 title='Table Editor'>
							<A HREF=cubui.rx?page=admjoinform.rx&page_ix=5&conn=<%=conn_id%>&tbltabsel=1&tabname=<%=tabname%>&tabcat=<%=tabcat%>><span>Table Editor</span></A>
							</li>
							<li id=dashLink1 title='Synonyms'>
							<A HREF=cubui.rx?page=admjoinform.rx&page_ix=4&conn=<%=conn_id%>&tbltabsel=2&tabname=<%=tabname%>&tabcat=<%=tabcat%>><span>Synonyms</span></A>
							</li>
							<li id=dashLink1 title='Incremental'>
							<A HREF=cubui.rx?page=admjoinform.rx&page_ix=7&conn=<%=conn_id%>&tbltabsel=3&tabname=<%=tabname%>&tabcat=<%=tabcat%>><span>Incremental</span></A>
							</li>
							<li id=dashLink1 title='Star Star' class=active>
							<A HREF=cubui.rx?page=admjoinform.rx&page_ix=9&conn=<%=conn_id%>&tbltabsel=4&tabname=<%=tabname%>&tabcat=<%=tabcat%>&trntabsel=""><span>Star Star</span></A>
							</li>
							<li id=dashLink1 title='Table Data'>
							<A HREF=admjoinform.rx?rdn=<%=rdn%>&conn=<%=conn_id%>&tbltabsel=5&tabname=<%=tabname%>&tabcat=<%=tabcat%>><span>Table Data</span></A>
							</li>
						</ul>

</div>
				</td>
			</tr>
		</table>
		<table width=100%><tr class=rep_title><td>Star Star Schema </td></tr></table>
		<TABLE class=tb1_border width=96% border=0 cellspacing=0 cellpadding=0 align=center>
			<TR class= tbl_tds><TD align=center><TD><B>Table Name :</B><%=tabname%></B></TD><TD><B>Table Type : </B><%=tabcat%></TD></TR>
		</TABLE
		<div id=status onclick="Done()" title="Click to refresh"></div>
		<div id=editid>
		<FORM Name=joinform class=sjoinform Method=post Action=cubui.rx Target=admjoinform > 
			<INPUT  Type=hidden Name=conn Value="<%=conn_id%>" Size=30 > 
			<INPUT  Type=hidden Name=tbltabsel Value="4" Size=30 > 
		<div id=EF>
			<TABLE class=tb1_border width=96% border=0 cellspacing=0 cellpadding=0 align=center>
				<TR class= tbl_tds>
				</TR> 
			</TABLE>
			<BR>
			<INPUT  Type=hidden Name=label Value="Create New"> 
			<INPUT  Type=hidden Name=action Value="Add"> 
			<INPUT  Type=hidden Name=ssid Value="-1"> 
			<INPUT  Type=hidden Name=page Value="<%=page%>"> 
			<INPUT  Type=hidden Name=page_ix Value="<%=page_ix%>"> 
			<INPUT  Type=hidden Name=tabname Value="<%=tabname%>"> 
			<TABLE align=center border=0 cellspacing=1 cellpadding=2 width= 98% class=tbl_border >
				<THEAD >
					<tr class=tbl_titles>
						<td class=txttabhead><A>Transaction Table </A></td>
						<td class=txttabhead><A>Master Table </A></td>
						<td class=txttabhead><A>Master Column </A></td>
						<td class=txttabhead><A>Master Value </A></td>
						<td class=txttabhead><A>Redirect Table </A></td>
						<td class=txttabhead><A>Time Join Column </A></td>
					</tr>
					<tr>
						<td>
							<Select  id=trn name="trntabsel" class=inputcombo style="WIDTH:130" >
								<option value="">-Select Table-</option>
<%@TABLE where=#Table_Type=2# name=default%>
								<option value=<%=Table_Name%>><%=Table_Name%></option>
<%/TABLE%>
							</select> 
						</td>
						<td>
							<Select id=mst name="msttblsel" class=inputcombo style="WIDTH:130" Onchange="getMasterValus()">
								<option value="">-Select Table-</option>
<%@TABLE where=#Table_Type=1# name=default%>
								<option value=<%=Table_Name%>><%=Table_Name%></option>
<%/TABLE%>
							</select> 
						</td>
						<td>
							<INPUT  Class=inputbox  Type=text Name=colname Value="<%=colname%>" Size=15  title="Enter Column Name" >
							<Select  id=colnameid name="colnamesel" class=inputcombo style="WIDTH:130" Onchange="filleditfld(colname,colnamesel);submit();">
								<option value="">-Select Column-</option>
<%@TABLE name=getTableDesc%>
								<option value="<%=Field%>"><%=Field%></option>
<%/TABLE%>
							</select> 
						</td>
						<td>
							<INPUT  Class=inputbox  Type=text Name=mstvalue Value="" Size=15  title="Enter Column Value" >
							<Select  id=mval name="mstvaluesel" class=inputcombo style="WIDTH:130" Onchange=filleditfld(mstvalue,mstvaluesel)>
								<option value="">-Select Value-</option>
<%@TABLE name=getValByTableNcol%>
								<option value="<%=VALUES%>"><%=VALUES%></option>
<%/TABLE%>
							</select> 
						</td>
						<td>
							<INPUT  Class=inputbox  Type=text Name=redirtbl Value="" Size=15  title="Enter redirect table Name" >
						</td>
						<td>
							<INPUT  Class=inputbox  Type=text Name=joincolval Value="" Size=15  title="Enter Time Column Name" ><label  title="Enter Column Name"></label>
							<Select  id=tcol name="joincolvalsel" class=inputcombo style="WIDTH:130" Onchange="filleditfld(joincolval,joincolvalsel)">
								<option value="">-Select Time Col-</option>
<%@TABLE name=getTimecolOfTrnTable%>
								<option value="<%=DATECOLS%>"><%=DATECOLS%></option>
<%/TABLE%>
							</SELECT>
						</td>
					</tr>
					<TR>
						<td align=center>
							<B>Create Table: </B>
							<INPUT  Type=checkbox Name=crtstartab Value="C" id="" Size=30  onclick="return confirm('Drop Redirect Table if exists and create a fresh one now.')" title="Create Star table." >
							<label for="" title="Create Star table.(Redirect Table will be dropped if exists.)">
							</label> 
						</TD>
						<td align=center>
							<B>Populate Data: 
							</B>
							<INPUT  Type=checkbox Name=populatestartab Value="P" id="" Size=30 onclick="return confirm('Redirect Table will be if not exists And papulate data .')"  title="Populate Star table" >
							<label for="" title="Populate Star table">
							</label>
						</td>
					</tr>	
					<tr>
						<td align=center colspan=5>
							<INPUT  Type=button Name=action1 Value="Add" class=btn Size=30  title="Add/Update" Onclick='SubmitForm()'> &nbsp;&nbsp;&nbsp; 
							<INPUT  Type=reset Name=action2 Value="Cancel" class=btn Size=30  onclick='showdiv("CN");hidediv("EF");'> 
						</td>
					</tr>
				</TABLE>
			</div>
			<div id=CN style="display:none">
				<table cellpadding=0 cellspacing=0 border=0 width=98% ><tr><td align=center><INPUT  Type=button Name=label Value="Create New" class=btn Size=30  title="Create star schema" Onclick='showdiv("EF");hidediv("CN");'>
				</td></tr></table>
			</div>
		</FORM>
		</div>
		<div id=Srows>
		</div>
	</body>
	<script language=javascript>
		function ClearDropDown(selid){
			ddl=document.getElementById(selid);
			var len = ddl.options.length;
			for (i=0; i<len; i++) {
				ddl.remove(0); //It is 0 (zero) intentionally
			}
		}
		function EditStatRow(id, trn, mst, mcol, mval, rtab, tcol){
			if(Access == 'RA'){			
				alert("You are not authorised to edit star star entries");
				return false;
			}
			select('trn', trn);
			select('mst', mst);
			document.joinform.colname.value=mcol;
			document.joinform.mstvalue.value=mval;
			document.joinform.redirtbl.value=rtab;
			document.joinform.joincolval.value=tcol;		
			document.joinform.ssid.value=id;
			document.joinform.action.value="Update";
			document.joinform.action1.value="Update";
			ClearDropDown('colnameid');
			ClearDropDown('mval');
			ClearDropDown('tcol');
		}
		function getMasterValus(){
			document.joinform.tabname.value=document.joinform.msttblsel.options[document.joinform.msttblsel.selectedIndex].value;
			document.joinform.colname.value="";			
			document.joinform.submit();
		}
		function SubmitForm(){
			document.joinform.Action="admjoinform.rx";
			loadsubmit("admjoinform.rx", "status", "joinform", 1);
			window.parent.admjoinlist.location.href="cubui.rx?page=admjoinlist.rx&conn=<%=conn_id%>&pageix=<%=page_ix%>";
			loadsubmit("cubui.rx?page=admjoinform.rx&page_ix=10&conn=<%=conn_id%>&tabname=<%=tabname%>", "Srows", "", 0);
			//window.parent.admjoinform.location.href='cubui.rx?page=admjoinform.rx&page_ix=9&conn=<%=conn_id%>&tbltabsel=4&tabname=<%=tabname%>&tabcat=<%=tabcat%>&trntabsel=""';
		}
		function Done(){
			window.parent.admjoinform.location.href="cubui.rx?page=<%=page%>&page_ix=<%=page_ix%>&conn=<%=conn_id%>&tabname=<%=tabname%>";
		}
		select('trn','<%=trntabsel%>');
		select('mst','<%=tabname%>');
		select('colnameid','<%=colnamesel%>');
		loadsubmit("cubui.rx?page=admjoinform.rx&page_ix=10&conn=<%=conn_id%>&tabname=<%=tabname%>", "Srows", "", 0);
		if(Access == 'RA')
		hidediv('editid');
	</script>

</HTML>