Search results for query: *

This likely happens due to memory issues on the I-Server machine. Check the number of projects that are in the Projecty Monitor (loaded and unloaded), each will be using memory, I-Server gets confused and names projects incorrectly.

You only want to break by Product. Sort order Product & Day.

No new SQL is generated. Like a pivet table in excel the data is already available you just see a different view of it.

YOu could use something like excel to build up the following expression for Command manager: CREATE METRIC "New Metric" IN FOLDER "\Public Objects\Metrics\Count Metrics" EXPRESSION "Count(Customer) {Country} <[Year 2001]>" ON PROJECT "MicroStrategy Tutorial"; Cols for the syntax which would...

I installed 8 onto a test box with our license key which didn't include Office. We were getting an out of compliance message when accessing Adminstration thro' desktop or using command manager. Took some digging around, but the administrator user was taking up an Office license, which was...

You can set report data options at template level as well as report level. So if you're drilling from a report with no page-by to a template with a page-by with this set you should be ok. Likewise the setting should carry down on a standard drill down (i.e year to quarter) so if a user where...

there a way that the Page By can default to whatever the user selected to drill into? Yes. Report Data options General/Drilling There are options under 'Add the current page by element as part of filter when drilling from:' I think the 'any other part of the report' checkbox may be what you...

Mizh - are you sure. You can't connect Desktop 7.2.x to I-server 7.5 - there may be backwards compatability but no forward compatability.

There is one tech note on the MSTR knowledge base that believes this issue to occur due to the heap size on the machine if the administrator changes the HeapMinSize parameter to a higher value than the HeapMaxSize value, the error message appears Go to the registry key...

Grid/Long Names will show the attribute form names. You'll get something like Attribute Name <space> Attribute Form Name So in your example Test ID Test Desc There is an issue then if your attribute is called TestID, as the display would then be TestID ID TestID Desc But you can...

as a matter of interest, how many rows does the SQL return when you run it direct in Access?

If it's a sql server database you're talking about for the column you need to setup the indentity seed and identity increment. If you've got SQL Server Enterprise Manager then open up the table in design mode, highlight the column and change identity to yes, indentity seed = 1, indendity...

You can Right Mouse Click and add files in interdev project browser window (I think it's called that, been a while since I used interdev). Then you get into the working directory/live directory scenario. So you change the files in the working d

I'm assuming the ticket field you are displaying in Response.Write "Ticket : " & recordset("id") & "<br>" is an access autonumber column - it's not part of the insert statement, so must automatically be filled in. Therefore the following sql should work in access to bring back one row...

Can you post up the sql being generated?

You need to do this through customization of FilterDisplayCuLib.asp. Get the report XML, find the value for the prompt and display that. Be aware that the prompt answer is NOT in the XML after a drill! some messy code now follows: 'get report xml strReportXML =...

GetData = "<a href=""" & str & ".jpg"">" & strTitle & "</a>" or even str = 123 str = "http://mysite.com/items/" & str & ".jpg" which means GetData = "<a href=""" & str &"">" & strTitle &"</a>

The msft knowledge base comes up with this handy cause of the error: The path that the Web server is reading is not a valid path. Often, this occurs when the Global.asa file is being used, and the connection string is created on a computer other than the Web server. If the path is a mapped...

If you're using SQL92 (which it looks like you are) then the INNER JOIN part of the SQL should be in FROM ie select a.dateid, b.STORE, sum(a.sales) from SALES_TABLE a join STORE_TABLE b on (a.STORE= b.STORE) group by a.date, b.STORE if you use SQL89 then the join would appear in...

You can get anything in the URL by using request.querystring e.g http://www.someurl.com?test.asp?name=aaaa dim strName strName = request.querystring("name") response.write strName would return aaaa you can then pass this string in future url's <a href="next.asp?name=<%strName%>">next</a>