Uderc programming article aggregator sites
Index -> omniture data warehouse api

omniture data warehouse api

Advertisement

Best practice of metadata table in data warehouse environment ?

Hi guru's, In datawarehouse, we have 1. Stage schema 2. DWH(Data warehouse reporting schema). In stageing we have about 300 source tables. In DWH schema, we are creating the tables which are only required from reporting prespective . some of the tabl

Diff b/w Data warehouse and Business Warehouse

Hi all, what is the Diff b/w Data warehouse and Business Warehouse?hi.. The diferrence between Datawarehousing and Business Warehouse are as follows. DataWarehousing is the concept and BIW is a tool that uses this concept in Business applicaitons. Da

Performance issues with data warehouse loads

We have performance issues with our data warehouse load ETL process. I have run analyze and dbms_stats and checked database environment. What other things can I do to optimize performance? I cannot use statspack since we are running Oracle 8i. Thanks

Please help to get onhand stock report with last purchase and billed date warehouse and item wise

please help to get onhand stock report with last purchase and billed date warehouse and item wiseHi Rajeesh Ambadi... Try This SELECT distinct T0.ITEMCODE , t1.ItemName, T0.ONHAND as 'Total Qty',     T1.LASTPURDAT ,t1.LastPurPrc FROM OITW T0 INNER JO

Error while creating data warehouse tables.

Hi, I am getting an error while creating data warehouse tables. I am using OBIA 7.9.5. The contents of the generate_clt log are as below. >>>>>>>>>>>>>>>>>>>>>>>>>> Schema will

Service Manager data warehouse management server Installation fails

Hi there, In Virtual Machine Windows Server 2012 R2 Standard with my user being a Local Admin and SQL Admin. I tried to do a Service Manager data warehouse management server first installation I am facing the following image as error: In the event vi

Failure on clean install of Service Manager 2012 R2 Data Warehouse installation - Error about "AssignSdkAccountAsSsrsPublisher"

I'm installing the Data Warehouse component on a new server (Server 2008 R2 SP1 with SQL 2012 SP1 CU6).  Reporting service, analysis services and full text services are installed.  I'm installing under an account that has DBO rights to the instance. 

What are the best solutions for data warehouse configuration in 10gR2

I need help on solutions to be provided to my Client for upgrading the data warehouse. Current Configuration: Oracle database 9.2.0.8. This database contains the data warehouse and one more data mart on the same host.Sizes are respectively 6 Terabyte

Configuration Dataset = 90% of Data Warehouse - Event Errors 31552

Hi All, I'm currently running SCOM 2012 R2 and have recently had some problems with the Data Warehouse Data Sync. We currently have around 800 servers in our production environment, no Network devices, we use Orchestrator for integration with our cal

SAles Order not appearing in Sales Data Warehouse SAles Order List

Hi Gurus, Can you help me in this regard :- My Sales Order has been invoiced but its not appearing in the Sales Data Warehouse Sales Order List.Hi poonam, I don't get clearly, but mean here your sales order doesn't exist in your cube or ODs in BW. If

Connect to MS SQL Server 2000 data warehouse

Hi, I use a MS SQL Server 2000 database for my web application where I use JSP. I suppose to create data warehouse using MS SQL Server's Data Transformation Service. But I don't know it's possible to connect to a MS SQL Server's data warehouse using

Service Manager Data Warehouse Install - Analysis Server Configuration For OLAP Cubes Fail

Hello everyone, I have an issue with my installation of the Data Warehouse for System Center Service Manager 2012 SP1. My install environment is the following: Windows Server 2012 – System Center Service Manager (Successfully Installed) - Virtual Win

Manual data corrections in data-Warehouse/OLAP

Hi to all, is it somewhere in essbase(hyperion) possible Manual data corrections in data-Warehouse/OLAP? Thank you G.Hi NareshV, thanks for your reply. In fact, I have also some difficulties tu understand (I am not autor) this question;-), but ok - l

Service manager console can't connect to Service manager data warehouse SQL reporting services

When I start Service manager console, it gives this kind of error: The Service Manager data warehouse SQL Reporting Services server is currently unavailable. You will be unable to execute reports until this server is available. Please contact your sy

I am getting the error "Unable to connect to data warehouse management server" when I try to register it DWMS

I have a Data Warehouse Server that appears to be functioning but is running System Center Service Manager 2010 (w/ out SP1), Also have a functioning Configuration Management Server with Reporting Services Point installed the is running System Center

Unable to connect to Data Warehouse Server

I have a Data Warehouse Server that appears to be functioning but is running System Center Service Manager 2010 (w/ out SP1), Also have a functioning Configuration Management Server with Reporting Services Point installed the is running System Center

How to convert number datatype to raw datatype for use in data warehouse?

I am picking up the work of another grad student who assembled the initial data for a data warehouse, mapped out a dimensional dw and then created then initial fact and dimension tables. I am using oracle enterprise 11gR2. The student was new to orac

Tablespaces and block size in Data Warehouse

We are preparing to implement Data Warehouse on Oracle 11g R2 and currently I am trying to set up some storage strategy - unfortunately I have very little experience with that. The question is what are general advices in such considerations according

Unread      Implementing heirarichal structure in data warehouse

I want to create a data warehouse for credit card application. Each user can have a credit card and multiple supplementary credit cards. Each credit card has a main limit, which can be sub-divided into sub-limits to supplementary credit cards as requ

Syntax for WriterLoginName in Data Warehouse DB

Hello I'm having a few issues with our management servers writing to the Data Warehouse DB. I've checked the 'Management Group' table and can see the WriterLoginName is set to DOMAIN\sv-scom-dw - however, i'm just querying whether that field should r