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]

Issue: I have a flash movie that runs as a standalone player on a Demo CD... I also have an install msi file(same as an exe) that when the user is done viewing the flash movie they can click on a menu button in the flash movie that executes the msi o [More]
I have had to reinstall OSX from the discs that came with my MacBook Pro, which are 10.6. I then restored my backups from time machine and now need to upgrade to 10.9 so everything will run. However Mavericks is now at 10.9.1 and will not install wit [More]
Hi all, I just started doing the XML Xquery programming in my SQL Server 2012 Management Studio. I executed the following code: --query the XML Blob using a CTE (pulling from the XML file each time) Products WITH XmlFile (Contents) AS ( SELECT CONVER [More]
How do I remove or delete files and image files within a document foler?  I have tried dragging the files to the trash, but that is not working. Right-click (or ctrl-click) on a file. If the "move to Trash" option is greyed out, select "get [More]
Hi friends, Im in obiee where i downloaded smartview plugin for my 32 bit windows machine and established connection to the BI catalog to access the BI objects. Now i can access the catalog objects in smartview and can created reports within [More]
Hi, I was just wondering which Ram was better for my 2.2ghz intel core 2 duo 13 inch macbook which currently has 1 gb of ram. 8&csid=ITD&body=MAIN OR http://eshop.mac [More]
Does anyone has the same issues on your Imac? Every 10-15 mins i have to turn off wifi and on it again to get signal. My wifi signal is full strength and it does not happen on my macbook or ipad. Updated software to os 10.8.5 ThanksBack up all data b [More]
i have an IMAC 27" late 2009. using an mbox2 pro. i'm using a firewire adapter to connect to the imac cos the imas has the new firewire port. when i shut down the computer the mbox stays on. any ideas? thanksUnfortunately, the firewire as well as the [More]
sometimes when i take google chrome,utorrent, etc apps to full screen the menu bar doesn't pop up no matter how much i click at top... i cant even take the apps out of the full screen mode (not even from the keyboard shortcut)... after i log out and [More]
I get a crash everytime I try to install these drivers on my Bootcamp partition. Windows does a crash dump and restarts computer. I do not know exactly at what point during the installation of the Windows Support drivers this happens. Other comments: [More]