Amicuk Programming Answers

Help with Count function

-0001-11-30   Views:0


Post Author: RJPiekos CA Forum: Desktop Intelligence Reporting I am trying to use the count function to count the number of unique PO numbers in a column. The program returns a value of "1" even when there are no PO's to be counted. Is there som

Post Author: RJPiekos
CA Forum: Desktop Intelligence Reporting
I am trying to use the count function to count the number of unique PO numbers in a column. The program returns a value of "1" even when there are no PO's to be counted. Is there some system setting that i am missing.
The universe that i am using is a free-hand SQL query to to an MS Access .mdb file. (if that makes a difference)
Desktop IntelligenceBO 11.5

The replay answer
Post Author: RJPiekos
CA Forum: Desktop Intelligence Reporting
Found my problem - 'empty' values in the PO column were not NULL.

Go to See the other 2 answers

Counter function value to multiple elements as same value in different node

Category:DefaultRelease time:2015-10-11Views:130

I need your help! I have a counter function and value of that needs to be passed to two elements of Node A and Sub Node B.. Ex: Mapping Map Counter function to NodeA.Element1 and also to NodeB(subnode).Element2 Expected Result: NodA.Element1 = 1 Node[More]

Count() function throws error in EQL query for metric

Category:DefaultRelease time:2015-10-11Views:130

Hi I am trying to use count function in EQL query for Metric Bar to show the number of occurrences of a record. When the record type doesn't exist i expect the function to return count as 0. Instead the function throws a runtime exception and the who[More]

OBIEE: Incorrect SQL - with count function uses ORDER BY instead GROUP BY

Category:DefaultRelease time:2015-10-11Views:130

I made a basic report that is a client count; I want to know how many clients the company have. But, when I run this report, OBIEE generates a ORDER BY sentence, instead a GROUP BY. Remember that I'm using count function, that is a agregation. The SQ[More]

Sql count function in order by clause

Category:DefaultRelease time:2015-10-11Views:130

Post Author: krypton CA Forum: Data Connectivity and SQL Hi Guys Can i ask a quick question. I am trying to retrieve data remotely from a SQL Server via crystal reports. Within the Database Expert I have entered a SQL query to retrive the number of ([More]

Distinct Count Function-how to use properly

Category:DefaultRelease time:2015-10-11Views:130

Hello, I am new to using forums & have only been using Crystal since May of 2009, so i hope i do this correctly & provide the appropriate information.  i've looked for this answer in what's been posted but cannot find it.  Some things i've read I[More]

Count-Function in Message Mapping

Category:DefaultRelease time:2015-10-11Views:130

Hey, trying to map following structures: message -m1 --m11 -m2 --m22 -m3 --m33 to message -m1 --m11 -m2 --m22 -m3 --m33 -f1 --countItems The nodes m1,m2 and m3 can appear 1..unbounded. In target structure I would like to have the numbers of all nodes[More]

Count function in Administration Tool

Category:DefaultRelease time:2015-10-11Views:130

Hello, I am using Oracle BIEE and tried using the count function in the repository so that the users have the field ready in Answers but the consistency checker returned an error stating: [38083] The Attribute 'No of Movements' defines a mea[More]

How to include the COUNT Function in business rule

Category:DefaultRelease time:2015-10-11Views:130

Hi all,      I am working in oracle data quality in ODI.      This is regarding the business rule in Data quality.      I need to count the number of records when my status_type="A".      But when i include the COUNT function in business rule.  [More]

Why is the Tick Count function slow when used with a .dll but fine with normal lab view code?

Category:DefaultRelease time:2015-10-11Views:130

when using the Tick Count millisecond timer with a .dll I've written in C, I'm getting some odd timing issues. When I code the function I want (I'll explain it below in case it helps) in LV and run it as a subVI, feeding it the Tick count as an argum[More]

Count the no.of rows without using count function

Category:DefaultRelease time:-0001-11-30Views:130

Hi, How to count the no.of rows without using the count function? Thanks,they won't be 100% accurate. You're correct, Bluefrog, but the same goes for doing a count(*) (depending on the size of the table, ofcourse): the table being queried might be un[More]

Error: DAQ-STC Counter functions missing from library

Category:DefaultRelease time:-0001-11-30Views:130

Using LabView 6.1, NI-DAQ 6.6.1 for MacOS on a laptop. DAQ Hardware: DAQCard 16E-4. When trying to use the advanced counter functions (for DAQ-STC type counters), LabVIEW generates an error saying that it can't find the function in the library. The c[More]

Very recently I've noticed that almost all the movies that I've rented in the past are now only available to buy. Also, many new movies do not have "rent" as an option and can only be bought. Since I only bought Apple TV to rent movies, this now [More]
Hii, I have 2 UCS from Cisco with 3 virtual machine ( 1 PUB - 1 SUB - 1 VoiceMail) I will write the steps in order to make the upgrade, pls write if I miss something or I am wrong. 1. I will update on cucm8.6 all the device to firmware supported in c [More]
I have content on my iPOD touch which was from my old laptop which is stolen. How do i transfer as if i sync to my laptop all of it will be erased?See Recover your iTunes library from your iPod or iOS device. tt2Read other 4 answers [More]
I am very discouraged right now.  I am a student and last semester I needed Adobe Photo shop. It was CS6.  It worked great then my trial expired.  So I paid for Adobe Creative Cloud and when I downloaded the programs that I needed the photo shop woul [More]
Do I need to have a more advanced program to always be able to save data on fillable forms?Here's some info on how to use that feature. other 5 answers [More]
Hi ! Is it possible to ADD NEW Itemlines to the Accountingdocument while doing billing(VF01) ? Know that its no problem to change existing lines. Need to ADD one new debit and one new credit item line. Have tried  userexit  EXIT_SAPLV60B_008 and BADI [More]
Itunes will not run in windows 8.1 If started it just freezesI am having the same issue constantly freezes.. I removed the preferense then it works but if I try to sign in it freezes and I am at a loose to figure out why.. I tryed Itunes on another c [More]
What a procedure! Installed, yes the 'Retail' version of Leopard on a Power Mac G4. It did it's check, said good to install. Clicked upgrade install. Half way through installing, error comes up and says it can't install Leopard. So, restarted the com [More]
When I start the computer it opens the desktop...And everything appears good until I launch my browser, firefox, it then goes to windows and everything is magnified and very difficult to navigate due to size. I've tried making adjustments but no prog [More]
Hi, For some reason, whenever my circular buffer is filled and wraps around, right at that moment, my graph screws up for a split second by drawing a line across the graph. But for some reason, this doesn't happen all the time, only sometimes. The pi [More]