Koen Verbeeck

Forum Replies Created

Viewing 15 posts - 5,971 through 5,985 (of 11,676 total)

RE: Matching Missing Field

Great question!
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP

January 18, 2013 at 12:32 am

#1578573
RE: same measure in 2 cubes, but not displaying data in one cube related reports only

Jayanth_Kurup (1/17/2013)
if the issue is only for the single product make sure the data is present in the underlying database and the cubes have been processed.
Also make sure there isn't...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP

January 18, 2013 at 12:19 am

#1578567
RE: Why is the results take longer in MDX than TSQL?

blom0344 (1/16/2013)
Did the T-sql take 5 seconds on the first execution? If not , then results may still be in the memory cache. The MDX may not have that advantage.
SSAS...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP

January 16, 2013 at 2:32 pm

#1578034
RE: Process Architecture Optimization

sqlnaive (1/16/2013)
Fortunately or unfortunately, it is the same table. That was also in my mind. But I don't understand that how it is not giving any issue currently as it...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP

January 16, 2013 at 1:22 am

#1577685
RE: SSIS Package Not Writing all the Rows to OLE DB Destination Although shows the complete numbers on dataflow Path

Darren Lesnever (1/15/2013)
Make sure you don't have the error output for the OLE DB destination set to ignore errors.
Almost 2 years old this thread, so I hope the OP has...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP

January 16, 2013 at 1:15 am

#1577681
RE: same measure in 2 cubes, but not displaying data in one cube related reports only

niha.736 (1/15/2013)
HI Jayanth, thanks for your reply.
can you please elaborate on these 3, what need to be checked or what can be changed.
Dimension mapping
Perspective
Permissions on the measure group.
Thanks again,
Niha
Dimension mapping...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP

January 16, 2013 at 1:13 am

#1577678
RE: Process Architecture Optimization

sqlnaive (1/16/2013)
Thanks. Apart from drivers, how it works parallely ? Say If i create a SSIS package. Will the same package work in parallel if invoked with different set of...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP

January 16, 2013 at 1:10 am

#1577677
RE: Why is the results take longer in MDX than TSQL?

Hard to tell without knowing the exact structures of the database and cube, but I do know SSAS is strong in showing aggregated data, not really in showing data dumps.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP

January 16, 2013 at 1:06 am

#1577673
RE: Help me Error SSIS Error (Agent Service)

mai0165 (1/15/2013)
The tests showed that error password of oracle source
this connection string of Oracle
Data Source=ptcdw;User ID=nfctp;Password=dkig'bo_ptc;Provider=MSDAORA.1;Persist Security Info=True;
because password has '
this error message
Step ID1
ServerWIN-LGEV2QOJN58
Job Nametest
Step NameTest1
Duration00:00:01
Sql Severity0
Sql Message...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP

January 16, 2013 at 1:03 am

#1577672
RE: pdf generation in sql

You can use Reporting Services (SSRS) for that.
Just build a very simple report using a table.
Output the report to pdf and you're done.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP

January 16, 2013 at 1:00 am

#1577670
RE: Monthly Aggregation

Please provide table definitions and sample data.
(read the first link in my signature on how to do this)
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP

January 16, 2013 at 12:59 am

#1577669
RE: SSAS

SSAS is an OLAP database, where OLAP stands for Online Analytical Processing.
A relational database not used as a data warehouse is an OLTP database, where OLTP stands for Online Transactional...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP

January 16, 2013 at 12:57 am

#1577668
RE: Are the posted questions getting worse?

Congrats to both of you, Lynn and Dwain.
I'm ~~almost~~ over 9000!
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP

January 16, 2013 at 12:45 am

#1577665
RE: TRY...CATCH

Nice question, thanks! Explanation is short, but correct 😀
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP

January 16, 2013 at 12:44 am

#1577664
RE: Excel 64 bit driver

That's great stuff Lowell, I didn't know you could force the installation of the provider.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP

January 15, 2013 at 2:36 pm

#1577545

Viewing 15 posts - 5,971 through 5,985 (of 11,676 total)