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 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...
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...
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...
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 =...
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>
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.